Metacat

############### Application Values ############

## one of the few places where we use ANT tokens

application.metacatReleaseInfo=-1

application.deployDir=

database.upgradeVersion.2.0.2=upgrade-db-to-2.0.2

database.upgradeVersion.2.0.3=upgrade-db-to-2.0.3

database.upgradeVersion.2.0.4=upgrade-db-to-2.0.4

## for running java-based utilities

database.upgradeUtility.1.5.0=edu.ucsb.nceas.metacat.admin.upgrade.Upgrade1_5_0

database.upgradeUtility.2.0.0=edu.ucsb.nceas.metacat.admin.upgrade.Upgrade2_0_0

		PRIMARY KEY (guid)

)

	guid VARCHAR2(2000),	-- the globally unique string identifier of the object that the system metadata describes

	member_node VARCHAR(250),	 -- replication member node

	policy VARCHAR2(2000),	 -- the policy (preferred, blocked, etc...TBD)

		FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE

);

	guid VARCHAR2(2000),	-- the globally unique string identifier of the object that the system metadata describes

	member_node VARCHAR(250),	 -- replication member node

	status VARCHAR(250),	 -- replication status

	date_verified DATE, 	-- the date replication was verified   

		FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE

);

		PRIMARY KEY (guid)

)

	guid VARCHAR2(2000),	-- the globally unique string identifier of the object that the system metadata describes

	member_node VARCHAR(250),	 -- replication member node

	policy VARCHAR2(2000),	 -- the policy (preferred, blocked, etc...TBD)

		FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE

);

	guid VARCHAR2(2000),	-- the globally unique string identifier of the object that the system metadata describes

	member_node VARCHAR(250),	 -- replication member node

	status VARCHAR(250),	 -- replication status

	date_verified DATE, 	-- the date replication was verified   

		FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE

);

 */

	guid text,	-- the globally unique string identifier of the object that the system metadata describes

	member_node VARCHAR(250),	 -- replication member node

	policy text,	 -- the policy (preferred, blocked, etc...TBD)

		FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE

);

	guid text,	-- the globally unique string identifier of the object that the system metadata describes

	member_node VARCHAR(250),	 -- replication member node

	status VARCHAR(250),	 -- replication status

	date_verified TIMESTAMP, 	-- the date replication was verified   

		FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE

);

 * xml_replication, then only convert the IDs for server 1 to GUIDs if the

 * property 'guid.ezid.doishoulder.1' defines a valid doi shoulder.

 * 

 * @author jones

 */

public class GenerateGlobalIdentifiers implements UpgradeUtilityInterface {

        // Convert other tables once, after the identifier table conversion has established the new

        // global identifiers to be used

        // This incudes: xml_access table, including accessfileid field, systemmetadata, 

        convertIdentifierField(con, "xml_access", "guid");

        convertIdentifierField(con, "xml_access", "accessfileid");

        convertIdentifierField(con, "systemmetadata", "guid");

        // Now clean up the temporary column we created, but note this makes it much

        // harder to revert our changes

        /*      

        // The following SQL commands will revert the changes made by this script as long as the identifier.old_guid column is intact

        start transaction;

        update systemmetadata set guid = id.old_guid FROM identifier id WHERE systemmetadata.guid = id.guid;

        update xml_access set accessfileid = id.old_guid FROM identifier id WHERE xml_access.accessfileid = id.guid;

        update xml_access set guid = id.old_guid FROM identifier id WHERE xml_access.guid = id.guid;

		List<NodeReference> nodes = new ArrayList<NodeReference>();

		String sql = "select guid, policy, member_node " +

	    DBConnection dbConn = null;

	    int serialNumber = -1;

	    try {

		List<Replica> replicas = new ArrayList<Replica>();

		String sql = "select guid, member_node, status, date_verified " +

	    DBConnection dbConn = null;

	    int serialNumber = -1;

	    try {

    {

        // remove existing values first

        "where guid = ? and policy = ?";

        PreparedStatement stmt = dbConn.prepareStatement(delete);

        //data values

        for (String memberNode: memberNodes) {

            // Execute the insert statement

                "(guid, policy, member_node) " +

                "values (?, ?, ?)";

            PreparedStatement insertStatement = dbConn.prepareStatement(insert);

            insertStatement.setString(2, policy);

            insertStatement.setString(3, memberNode);

            //execute

            int rows = insertStatement.executeUpdate();

    private void insertReplicationStatus(String guid, List<Replica> replicas, DBConnection dbConn) throws SQLException {

        // remove existing values first

        "where guid = ?";

        PreparedStatement stmt = dbConn.prepareStatement(delete);

        //data values

        if (replicas != null) {

            for (Replica replica: replicas) {

	            // Execute the insert statement

	                "(guid, member_node, status, date_verified) " +

	                "values (?, ?, ?, ?)";

	            PreparedStatement insertStatement = dbConn.prepareStatement(insert);

	            insertStatement.setString(3, status);

	            insertStatement.setDate(4, sqlDate);

	            //execute

	            int rows = insertStatement.executeUpdate();

            rows = stmt.executeUpdate();

            stmt.close();

            "where guid = ?";

            stmt = dbConn.prepareStatement(query);

            stmt.setString(1, guid);

            rows = stmt.executeUpdate();

            stmt.close();

            "where guid = ?";

            stmt = dbConn.prepareStatement(query);

            stmt.setString(1, guid);

            rows = stmt.executeUpdate();

            stmt.close();

	-- do we want to remove the SM records too?

	IF deleteSystemMetadata THEN

		GET DIAGNOSTICS deleted_count = ROW_COUNT;

		GET DIAGNOSTICS deleted_count = ROW_COUNT;

		DELETE FROM systemMetadata WHERE guid = pid;

		GET DIAGNOSTICS deleted_count = ROW_COUNT;

#Version of this build.  This needs to be a dotted numeric version.  For

#instance 1.9.1 is okay.  1.9.1_rc1 is not.

#This is for packaging purposes.  leave it blank for final production release.

metacat.releaseCandidate=

Metacat: XML Metadata and Data Management System

------------------------------------------------                      

Send feedback and bugs to: metacat-dev@ecoinformatics.org

                           http://bugzilla.ecoinformatics.org

See the file "docs/install.html" for detailed instructions

for your OS.

Release Notes for 2.0.4:

------------------------

This patch release focuses on Metacat-Metacat replication.