Project

General

Profile

# Date Author Comment
7392 09/24/2012 01:09 PM ben leinfelder

shorten the systemmetadata* table names for Oracle's 30 character limit. move version to 2.0.5. http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5717

7388 09/21/2012 01:30 PM ben leinfelder

use alternative syntax for xml_access table update since oracle does not use joins in a update statement that same way as postgres. http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5717

7387 09/21/2012 01:18 PM ben leinfelder

correct Oracle syntax
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5717

7194 05/28/2012 01:25 PM ben leinfelder

include eml2.0.0beta4 DTD during Metacat build so that we can continue to accept (and validate) beta4 documents.
This arose when testing Metacat as DataONE Coordinating Node where legacy documents are being housed in the CN.

7053 03/12/2012 12:08 PM ben leinfelder

increase amount of text the 'xml_path_index.path' column can accommodate. I was seeing errors like this during indexing:
knb 20120312-11:42:05: [ERROR]: DocumentImpl.buildIndex - SQL Exception while indexing document knb-lter-and.3147 : ERROR: value too long for type character varying(1000) [edu.ucsb.nceas.metacat.DocumentImpl]

6952 01/25/2012 03:50 PM ben leinfelder

eliminate the cross product that occurred when updating xml_access with a join

6949 01/24/2012 10:47 PM ben leinfelder

semicolons!

6947 01/24/2012 04:22 PM ben leinfelder

use a temporary table to calculate the maximum revision for a given docid and use that when setting the accessfileid during upgrade. the query plan for the all-in-one statement must be brutal as it's been running for 4 hours at this point....

6946 01/24/2012 12:20 PM ben leinfelder

do not insert duplicate GUID entries when adding rows from the xml_revisions table

6945 01/24/2012 11:57 AM ben leinfelder

add "IF EXISTS" clause to identifier table drop in case it does not exist on the given deployment (as is the case on the KNB)

6933 01/20/2012 10:46 PM Matt Jones

Added DOI generation to the 2.0.0 upgrade process. To succeed, this script must be run on a fresh 2.0.0 database, or on a 1.9.5 version database, as those are the only ways to get the needed foreign keys to be marked as deferrable. The identifier conversion must be turned on by setting correct properties in metacat.properties. See the comments in GenerateGlobalIdentifiers for details. By default, conversion is set to false in the properties file. If you want to convert an instance to use DOIs, be sure to set metacat.properties up BEFORE running through the Metacat configuration and database upgrade.

6923 01/18/2012 04:18 PM ben leinfelder

use larger ("text") db field for guid in the xml_access.accessfileid column

6814 12/21/2011 01:00 PM ben leinfelder

remove flag for independent system metadata replication -- these entries are replicated along with the data/metadata objects or via hazelcast when the actual object is not on the server.

6766 12/12/2011 10:50 AM ben leinfelder

include 'archived' system metadata element in backing DB store

6764 12/09/2011 03:28 PM ben leinfelder

add ; to end of update command

6761 12/09/2011 02:42 PM ben leinfelder

move latest postgres access upgrade statements to oracle script
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5560

6731 12/02/2011 10:54 AM Jing Tao

fixed a bug that using a wrong table name - acces_log.

6658 11/16/2011 10:38 AM ben leinfelder

remove DataONE schema reference in xml_catalog

6583 11/01/2011 04:53 PM ben leinfelder

drop old identifier when upgrading from 1.9.5 to 2.0.0

6561 10/27/2011 05:51 PM ben leinfelder

move the DataONE 1.0.0-SNAPSHOT

6550 10/27/2011 12:40 PM ben leinfelder

change upgrade scripts/routines to use 2.0.0 version number instead of 1.10.0

6542 10/20/2011 02:03 PM ben leinfelder

add User-Agent logging to support D1 requirements

6460 09/19/2011 03:39 PM ben leinfelder

only include 0.6.4 schemas for D1. Will also need to update this when we release whatever v1 ends up being.

6377 07/29/2011 10:40 AM ben leinfelder

remove ORE mapping from system metadata

6375 07/28/2011 05:11 PM ben leinfelder

include obsoletes and obsoletedBy for system metadata
repurpose the "provenance" table as the ORE mapping table for system metadata

6136 06/08/2011 05:08 PM ben leinfelder

add option for replicating system metadata (dataone)
https://redmine.dataone.org/issues/1626
also make sure the latest table changes are included in upgrade scripts

6092 05/19/2011 01:52 PM Matt Jones

Modified Metacat to build against the D1_SCHEMA_0_6_1 branch of the dataone schemas by incorporating the 0.6.1-SNAPSHOT version of d1_common and d1_libclient libraries, and refactoring Metacat code references to the d1 schema changed types.

6024 03/28/2011 02:44 PM ben leinfelder

do not drop nonexistent table (identifier is not in 1.9.3)

6012 03/16/2011 10:56 PM ben leinfelder

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

5917 02/04/2011 12:39 PM berkley

fixed bugs in listObjects

5887 02/02/2011 03:52 PM berkley

adding fields for additional system metadata info

5709 12/08/2010 04:59 PM ben leinfelder

add support for EML 2.1.1

5657 11/19/2010 03:23 PM berkley

changes for new d1 schemas

5629 10/27/2010 10:51 AM berkley

changes for dataone .5 schema updates

5547 09/17/2010 10:48 AM berkley

updated DB scripts for D1 schemas

5526 08/27/2010 12:27 PM berkley

new values for mets namespace

5524 08/27/2010 11:20 AM berkley

added METS schema to the catalog

5508 08/20/2010 09:17 PM ben leinfelder

do not attempt to drop 'identifier_id_seq' - it does not seem to exist

5400 06/24/2010 12:35 PM Matt Jones

Added SQL lines for registering D1 schemas in the upgrade process.

5398 06/24/2010 12:48 AM Matt Jones

Removing drop statements from upgrade scripts because the systemmetadata table
does not exist in 1.9.2, so these objects can't be dropped on upgrade.

5371 05/20/2010 10:59 AM berkley

added systemMetadata table to the upgrade scripts

5276 03/16/2010 12:33 AM Matt Jones

Modified table structure to change identifiers table (previously unused) to
represent a mapping between arbitrary string identifiers and metacat docids.
More information in https://trac.dataone.org/ticket/361. Modifications to
Oracle schemas were made but not tested.