clear lib dir from paths like xmltodb/lib/something.html
on "DELETE" added delete from xml_index table for a given docidbefore 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 newlinux server (dev.nceas.ucsb.edu). Added "build.sh" shell script thatcalls 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
Changes related to "getdataguide" action
doctype attr in xml_index table has been addedso 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
added Pool of ConnectionsDBQuery, DBReader, DBTransform, DBUtil are created on every request and use the connections from the Poolsame with DBWriter and DBValidate
Added "getdoctypes" and "getdataguide" action handlers
utility class for reading various of data from db
Added "Login Client" action for login from the Desktop Client
Added marine files to metacat package
MetaCatServlet.java
finished user auth & session tracking
changed char stream to byte stream
Fixed bug in DBEntityResolver so that it now properly delegates tothe system id found inthe database.Changed DBValidate to use DBEntityResolver, rather than the OASIScatalog, and to return validation results in XML format.
testing login
testing
Fixed bug where TEXT nodes couldn't be longer than 4000 characters, whichis the maximum length of a VARCHAR2 field in Oracle. Now, if textexceeds the field length, I break the text up into a series of TEXTnodes each of the max field length, and the remainder in the last...
Added feature to now ouput COMMENTs and PIs when the document isread from the database with DBReader.
changed toresponse.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 ofDBWriter. There were problematic interactions between some staticvariables used in DBEntityResolver and the way in which theServlet objects are re-used across multiple client invocations....
Merged in substantial changes to DBWriter and associated classes and tothe MetaCatServlet in order to accomodate the new UPDATE and DELETEfunctions. The command line tools and the parameters for theservlet 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
docid is String
docid is Stringdocid is generated from AccessionNumber.generate() call
gen acc # in new connectionchanging to static methodsinclude 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;
put checkURLConnection(systemId) beforeits register in db or using from the parser
rewrote DBSimpleQuery and associated classes to no longer use Oracle's hierarchichal query syntax -- now this should work with any JDBC compliant backend DB
assign rootnodeid, docid for every node in xml_nodes table by given document
to use single transaction
new class for registering of Accession numbers into metacat db
renamed DBSAXWriter to DBWriter
reincorporated Title registration code for documents
updated documentation
Renamed DBSAXElement to DBSAXNode
rearranged API for incrementing the node index within the parent node