Metacat

retry: add node name in the correct order for predicate navigation
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5561

add node name in the correct order for predicate navigation
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5561

handle queries with predicates correctly.
when docids are used in the return field look up, we need to make sure they are included in the values in the correct order for their corresponding parameter place holders (?)

uses prepared statement parameter binding for queries
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5527

handle more than "contains" searchmode when using the path index for queries
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5443

use the jaxb date parser for ISO 8601 formats. the numeric and date node values are now calculated after the document has been successfully inserted in the db so any sql exceptions do not prevent the raw node data from being saved.
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=2084

add support for temporal element query in pathquery
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=2084

QueryTerm.java will produce an incorrect SQL statement when there is an attribute in the XPath being used to search on. Regardless of the presence of the attribute, the clause:

(SELECT nodeid FROM xml_index WHERE path LIKE " + "'" + path + "') "

would be added to the query....

Create database and shared directories for database management code and shared code respectively.

Beef up exception handling from file utilities. Move UtilException to MetacatUtilException to eliminate conflict with similar exception in utility package.

Format indexPaths in metacat.properties. Remove from build.properties and build.xml. Move indexPath list getter from MetacatUtil to SystemUtil.

Renamed MetaCatUtil to MetacatUtil

Merge 1.9 changes into Head

Fixed a bug pathexpr was modified if pathexpr is an attribute.

Fixed bug that lsid couldn't be shown up in result page of kepler skin. The bug is that in extended query, lsid attribute was treated as a element, but it is attribute.
I also optimized the query by deleting xml_documents table from query. The table is not needed.

Use or to replace union

Add new variable indicate if this query term in a union group.

Add some new constance

Limited use of predicates in XPath return fields

Add a new method to compare the query terms to see if they have same search value.

adding changes to make paged query results possible

Removed the release ant token from all files in 'src'.

Reverting to previous QueryTerm.java that uses 'LIKE' for comparisons. This
allows substring matching to work properly, but prevents the postgres index
from being used. As a result, full table scans are done on the tables, causing
a major performance hit. Need to determine how to eliminate the use of LIKE...

Modifications to the table definitions to add indices that should be used
when searching the database. Added an upgrade script to create these
indices as well. Modified QueryTerm.java to use the '=' comparator rather
than 'LIKE' so that we can do index scans rather than table scans. This needs...

Bug fix in the changes made in previous commit

Fix for bug 2222. So that correct query is generated when searchmode is 'not-contains'.

Adding code to check if all the paths being searched for indexed are not. If all paths are indexed, the code will use xml_path_index instead of using xml_nodes and xml_index

Fixed a bug in last commit. Doing a search like
pathquery version="1.2">
<returndoctype>eml://ecoinformatics.org/eml-2.0.0</returndoctype><returnfield>originator/individualName/surName</returnfield><querygroup operator="INTERSECT"><queryterm casesensitive="false" searchmode="contains"><value>%</value></queryterm><queryterm casesensitive="false" searchmode="contains"><value>National Center for Ecological Analysis and Synthesis</value><pathexpr>organizationName</pathexpr></queryterm></querygroup></pathquery>...

When a path expression includes element content and attribute content, then
the SQL generated needs to search for attribute nodetypes with parent
nodenames equal to the path expression element content. However, when
only searching for attribute content (such as just @packageId), then...

Modified handling of greater-than and less-than so that comparison is done against nodedatanumerical column.

Created new printExtendedSQL function that can get the extended
return fields using only xml_nodes and not xml_index. One
step closer to eliminating the dependence ofn xml_index.

Created test class QuerySpecificationTest and started process of removing the xml_index from the QuerySpecification code. Reformatted some classes for readability.

Remove UPPER function for >, < operator.

Add a new search mode not-contains.

New class will be used in metacat ecogrid impl.