Metacat

Made changes to createSQuery to allow for multiple parameters of the same name. Also changed the param list to include only "Hashtable params" without a "String doctype" since the doctype is already contained in the params.

fixed bug with handleSQuery() that kept DMan from access the squery functionality

- created transformResultset() which transforms an xml resultset document and displays it to the client useing DBTransform
- renamed transformDocument() to createResultDocument() and modified its functionality to only return a restultset xml document
- changed handleSQuery() and handleQuery() to use the new methods

remove handleQueryAction() in favor of directly calling handleQuery() and handleSQuery() from doGetOrPost()

Cleared hardcoded paths for the location of .html files and use
the new "htmlpath" property from metacat.properties file

Added decodeMouseAction(Hashtable) to decode the mouse click action outside of handleGetOrPost to allow for easy modification of images in a different application.

added new constructor to allow the creation of a metacatutil object that uses a properties file other than edu.ucsb.nceas.metacat.metacat.

Broke up handleQueryAction into handleQuery, handleSQuery, runQuery and transformDocument. handleQueryAction is now a base function which makes calls to each of these functions to create, run and transform a query from CGI parameters.

Added createSQuery() to handle structured queries of an arbitrary number of parameters. Also modified createQuery() to handle a null query in a graceful manner.

Added "release" keyword to all metacat source files so that the release
number will be evident in software distributions.

Updated build process to now use a copy of the source files so that keyword
substitution can ocur before the build. This allows for substitution of
hardcoded values into the source before the compile. Currently, I am
using this feature to do the following:...

added Logout handling

clear lib dir from paths like xmltodb/lib/something.html

on "DELETE" added delete from xml_index table for a given docid
before delete from xml_documents, b' of foreign key in xml_index(docid)
to xml_documents(docid)

Changed exception handling mechanisms for DBReader

added createSQuery

broke up handleQueryAction into handleQuery, handleSQuery, runQuery and transformDocument

changed getRootNode method from public to private

replaced some deprecated methods with the new v2.2 of Java Servlet API

changed paths, b' of new dev server

added HTTPSession.setMaxInactiveInterval(-1)
for every new Session - never to expire

added "anonymous" user connection

-Reorganized xmltodb module to support new install process for the new
linux server (dev.nceas.ucsb.edu). Added "build.sh" shell script that
calls ant withthe proper umask set for installation. Use:

./build.sh install

to post a new copy of the servlet and its supporting files to the install...

rearrange html pages for login and metacat access

no message

more precise handling of the Connection Pool

no message

Changes related to "getdataguide" action

doctype attr in xml_index table has been added
so changed the getDataGuide routine to select for paths by given doctype

DBSAXNode constructor simplified

Call to DBSAXNode constructor simplified

Added public method to return the rootnodeid of the document

Added support for "anonymous" user

no message

added Pool of Connections
DBQuery, DBReader, DBTransform, DBUtil are created on every request and use the connections from the Pool
same with DBWriter and DBValidate

no message

no message

Added "getdoctypes" and "getdataguide" action handlers

utility class for reading various of data from db

no message

Added "Login Client" action for login from the Desktop Client

no message

Added marine files to metacat package

no message

no message

MetaCatServlet.java

finished user auth & session tracking

finished user auth & session tracking

changed char stream to byte stream

Fixed bug in DBEntityResolver so that it now properly delegates to
the system id found inthe database.
Changed DBValidate to use DBEntityResolver, rather than the OASIS
catalog, and to return validation results in XML format.

testing login

testing login

testing login

testing login

testing login

testing login

testing login

testing login

testing login

testing login

testing login

testing login

testing

testing

Fixed bug where TEXT nodes couldn't be longer than 4000 characters, which
is the maximum length of a VARCHAR2 field in Oracle. Now, if text
exceeds the field length, I break the text up into a series of TEXT
nodes each of the max field length, and the remainder in the last...

Added feature to now ouput COMMENTs and PIs when the document is
read from the database with DBReader.

changed to
response.sendRedirect(response.encodeRedirectUrl("/xmltodb/lib/index.html"));

Added srbrmi classes for authentication support

changed to use username/password entered on login

changes releted to login and session tracking

New- class that encapsulates session creation and user authentication

Updated javadoc documentation.

Fixed bugs associated with the new UPDATE and DELETE functions of
DBWriter. There were problematic interactions between some static
variables used in DBEntityResolver and the way in which the
Servlet objects are re-used across multiple client invocations....

Merged in substantial changes to DBWriter and associated classes and to
the MetaCatServlet in order to accomodate the new UPDATE and DELETE
functions. The command line tools and the parameters for the
servlet have changed substantially.

Fixed bug in DBWriter using the new SAX2 interface. Turned out it was a bug in xerces-1_1_1, which was fixed by Andy Clark after I reported it.

1) Simplified database connection creation by adding new utility routine in MetaCatUtil that reads configuration information from the properties file.
2) Created MetaCatUtil.getOption() to retrieve options from properties file.
3) Unified SAX Parser creation by specifying parser driver in the properties file and dynamically loading it using the XMLReaderFactory interface....

cleaned up code for getting options from the properties file, made the database connection inthe MetaCatUtil class use the properties file for the conneciton info

updated javadoc documentation

integrated new structured query facility (DBQuery) into the servlet demo (MetaCatServlet)

removed debugging code

fixed QuerySpecification to produce SQL that does UNION or INTERSECT set operations for query group combinations

finsihed basic functionality for structured queries based on the DBQuery and QuerySpecification classes

added code to build an index of the paths through the DOM tree to each node in the tree as the node is being inserted

for safe nodeid generation

completed work on creating structured query prototype in DBQuery and QuerySpecification classes

added missed conn.close()

continued work on structured query. Now QuerySpecification generates SQL for a given xml input, and DBQuery uses that SQL to send the query to the db

fixed string broken over two lines

documentation cleanup

minor modifications to fix problems introduced with AccessionNumber module

minor modifications to fix problems introduced with AccessionNumber module

docid is String

docid is String
docid is generated from AccessionNumber.generate() call

gen acc # in new connection
changing to static methods
include action parameter

continued work on structured query -- now it reads the queryspec xml docuemnt and can digest its contents

continued work on developing structured query functionality using the QuerySpecification class -- incomplete still

minor changes to TextNode

added incomplete classes for structured query

added result-set filter to DBSimpleQuery to only return specified document type

changed getDocID() only to:
return docid;