retry: add node name in the correct order for predicate navigationhttp://bugzilla.ecoinformatics.org/show_bug.cgi?id=5561
add node name in the correct order for predicate navigationhttp://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 querieshttp://bugzilla.ecoinformatics.org/show_bug.cgi?id=5527
handle more than "contains" searchmode when using the path index for querieshttp://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 pathqueryhttp://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'.
release
Reverting to previous QueryTerm.java that uses 'LIKE' for comparisons. Thisallows substring matching to work properly, but prevents the postgres indexfrom being used. As a result, full table scans are done on the tables, causinga major performance hit. Need to determine how to eliminate the use of LIKE...
Modifications to the table definitions to add indices that should be usedwhen searching the database. Added an upgrade script to create theseindices as well. Modified QueryTerm.java to use the '=' comparator ratherthan '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 likepathquery 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, thenthe SQL generated needs to search for attribute nodetypes with parentnodenames equal to the path expression element content. However, whenonly 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 extendedreturn fields using only xml_nodes and not xml_index. Onestep 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.