Metacat

Modifications to allow printing of SQL with and without INDEX option.

added print info and timing info

print the nested statements sql query

included flag in DBQuery to run pathqueries with or without the index,
but for the command line only.

there were more mentions of DOCTITLE attr - cleared them

added precise location information (class.method) to each catch statement so that errors are more easily traced.

Added license terms to source code files, and cleaned up some javadoc
documentation in a few places.

fixed sql error

Modified pathquery.dtd and QuerySpecification to allow some new constraints
on queries submitted to Metacat. Now, queries can contain an optional
set of <owner> tags that identify the users for which documents should be
returned, and a list of <site> tags constraining the site identifiers...

added functionality to return the doctype of a relation in a relationdoctype tag. This information is now returned automatically in the resultset under the path resultset/relation/relationdoctype.

Added backtrack functionality. Backtracking works by passing a returndoc parameter. There can be more than one. If a document that is hit by a query is not of type returndoc then it searches the database for a related file of type returndoc. If one is found it is displayed, if no relation is found, the original is displayed....

Added functionality for package specifications. metacatservlet now contains a new action called getrelateddocument that handles retrieving related documents using the metacatURL specification (metacatURL.java). DBQuery contains new code in runQuery that embeds relation tags in the returned hashtable describing the documents related to each docid. querySpecification contains a new method which prints the sql that does the relation query.

changed xslf for new returnfield scheme. the returnfields are now returned as <param name="<returnfield>"> tags.
hThe sql for the returnfield query was redone to fix a previous problem with slow queries

changed the field names to be case-sensitive in the returnfields

added support for the returnfield parameter
-QuerySpecification now sets a flag (containsExtendedSQL) when there are returnfield items in the pathquery document.
the accessor method containsExtendedSQL() can be called by other classes to check for extended return parameters...

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

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.

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....

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

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

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

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

added incomplete classes for structured query