/ - Diff - Metacat - Ecoinformatics Redmine

src/upgrade-db-to-2.0.0-oracle.sql
11	11	submitter VARCHAR2(256), -- the user who originally submitted the doc
12	12	object_format VARCHAR2(256), --the format of the object
13	13	size VARCHAR2(256), --the size of the object
	14	archived boolean, -- specifies whether this an archived object
14	15	replication_allowed boolean, -- replication allowed
15	16	number_replicas NUMBER(8), -- the number of replicas allowed
16	17	obsoletes VARCHAR2(2000), -- the identifier of the record that this replaces

src/xmltables-oracle.sql
414	414	submitter VARCHAR2(256), -- the user who originally submitted the doc
415	415	object_format VARCHAR2(256), --the format of the object
416	416	size VARCHAR2(256), --the size of the object
	417	archived boolean, -- specifies whether this an archived object
417	418	replication_allowed boolean, -- replication allowed
418	419	number_replicas NUMBER(8), -- the number of replicas allowed
419	420	obsoletes VARCHAR2(2000), -- the identifier of the record that this replaces

src/upgrade-db-to-2.0.0-postgres.sql
11	11	submitter VARCHAR(256), -- the user who originally submitted the doc
12	12	object_format VARCHAR(256), --the format of the object
13	13	size VARCHAR(256), --the size of the object
	14	archived boolean, -- specifies whether this an archived object
14	15	replication_allowed boolean, -- replication allowed
15	16	number_replicas INT8, -- the number of replicas allowed
16	17	obsoletes text, -- the identifier that this record obsoletes

src/xmltables-postgres.sql
306	306	submitter VARCHAR(256), -- the user who originally submitted the doc
307	307	object_format VARCHAR(256), --the format of the object
308	308	size VARCHAR(256), --the size of the object
	309	archived boolean, -- specifies whether this an archived object
309	310	replication_allowed boolean, -- replication allowed
310	311	number_replicas INT8, -- the number of replicas allowed
311	312	obsoletes text, -- the identifier that this record obsoletes

         private void updateSystemMetadataFields(long dateUploaded, String rightsHolder,
                 String checksum, String checksumAlgorithm, String originMemberNode,
                 String authoritativeMemberNode, long modifiedDate, String submitter,
                 String guid, String objectFormat, BigInteger size, boolean replicationAllowed,
                 String guid, String objectFormat, BigInteger size, boolean archived, boolean replicationAllowed,
                 int numberReplicas, String obsoletes, String obsoletedBy, BigInteger serialVersion)
+        {
             DBConnection dbConn = null;
-...
                 String query = "update " + TYPE_SYSTEM_METADATA +
                     " set (date_uploaded, rights_holder, checksum, checksum_algorithm, " +
                     "origin_member_node, authoritive_member_node, date_modified, " +
                     "submitter, object_format, size, replication_allowed, number_replicas, " +
                     "submitter, object_format, size, archived, replication_allowed, number_replicas, " +
                     "obsoletes, obsoleted_by, serial_version) " +
                     "= (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) where guid = ?";
                     "= (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) where guid = ?";
                 PreparedStatement stmt = dbConn.prepareStatement(query);
                 //data values
-...
                 stmt.setString(8, submitter);
                 stmt.setString(9, objectFormat);
                 stmt.setString(10, size.toString());
                 stmt.setBoolean(11, replicationAllowed);
                 stmt.setInt(12, numberReplicas);
                 stmt.setString(13, obsoletes);
                 stmt.setString(14, obsoletedBy);
                 stmt.setString(15, serialVersion.toString());
                 stmt.setBoolean(11, archived);
                 stmt.setBoolean(12, replicationAllowed);
                 stmt.setInt(13, numberReplicas);
                 stmt.setString(14, obsoletes);
                 stmt.setString(15, obsoletedBy);
                 stmt.setString(16, serialVersion.toString());
                 //where clause
                 stmt.setString(16, guid);
                 stmt.setString(17, guid);
                 logMetacat.debug("stmt: " + stmt.toString());
                 //execute
                 int rows = stmt.executeUpdate();
-...
                 stmt.close();
             } catch (SQLException e) {
                 e.printStackTrace();
                 logMetacat.error("insertAdditionalSystemMetadataFields: SQL error while creating a mapping to the system metadata identifier: "
                 logMetacat.error("updateSystemMetadataFields: SQL error while updating system metadata: "
                         + e.getMessage());
             } catch (NumberFormatException e) {
                 e.printStackTrace();
                 logMetacat.error("insertAdditionalSystemMetadataFields: NumberFormat error while creating a mapping to the system metadata identifier: "
                 logMetacat.error("updateSystemMetadataFields: NumberFormat error while updating system metadata: "
                         + e.getMessage());
             } finally {
                 // Return database connection to the pool
-...
     				sm.getAuthoritativeMemberNode() == null ? null: sm.getAuthoritativeMemberNode().getValue(),
     				sm.getDateSysMetadataModified() == null ? null: sm.getDateSysMetadataModified().getTime(),
     				sm.getSubmitter() == null ? null: sm.getSubmitter().getValue(),
             sm.getIdentifier().getValue(),
             sm.getFormatId() == null ? null: sm.getFormatId().getValue(),
             sm.getSize(),
             replicationAllowed,
             numberReplicas,
             sm.getObsoletes() == null ? null:sm.getObsoletes().getValue(),
             sm.getObsoletedBy() == null ? null: sm.getObsoletedBy().getValue(),
             sm.getSerialVersion()
     		        sm.getIdentifier().getValue(),
     		        sm.getFormatId() == null ? null: sm.getFormatId().getValue(),
     		        sm.getSize(),
     		        sm.getArchived() == null ? false: sm.getArchived(),
     		        replicationAllowed,
     		        numberReplicas,
     		        sm.getObsoletes() == null ? null:sm.getObsoletes().getValue(),
     		        sm.getObsoletedBy() == null ? null: sm.getObsoletedBy().getValue(),
     		        sm.getSerialVersion()
             );
             String guid = sm.getIdentifier().getValue();

Project

General

Profile

Metacat

Revision 6766

Added by ben leinfelder almost 13 years ago