/src/edu/ucsb/nceas/metacat/IdentifierManager.java - Annotate - Metacat - Ecoinformatics Redmine

metacat/src/edu/ucsb/nceas/metacat/IdentifierManager.java @ 6107

-            jones
+/**
  *  '$RCSfile$'
  *  Copyright: 2010 Regents of the University of California and the
  *             National Center for Ecological Analysis and Synthesis
+ *
  *   '$Author: jones $'
  *     '$Date: 2010-02-03 17:58:12 -0900 (Wed, 03 Feb 2010) $'
  * '$Revision: 5211 $'
+ *
  * This program is free software; you can redistribute it and/or modify
  * it under the terms of the GNU General Public License as published by
  * the Free Software Foundation; either version 2 of the License, or
  * (at your option) any later version.
+ *
  * This program is distributed in the hope that it will be useful,
  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  * GNU General Public License for more details.
+ *
  * You should have received a copy of the GNU General Public License
  * along with this program; if not, write to the Free Software
  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  */
 package edu.ucsb.nceas.metacat;
 import java.sql.PreparedStatement;
 import java.sql.ResultSet;
 import java.sql.SQLException;
-            berkley
+import java.sql.Timestamp;
-            leinfelder
+import java.util.ArrayList;
 import java.util.Date;
 import java.util.Hashtable;
 import java.util.List;
 import java.util.Vector;
             jones
 import org.apache.log4j.Logger;
-            berkley
+import org.dataone.service.types.Checksum;
 import org.dataone.service.types.ChecksumAlgorithm;
-            leinfelder
+import org.dataone.service.types.Identifier;
-            leinfelder
+import org.dataone.service.types.NodeReference;
-            berkley
+import org.dataone.service.types.ObjectFormat;
 import org.dataone.service.types.ObjectInfo;
 import org.dataone.service.types.ObjectList;
-            leinfelder
+import org.dataone.service.types.Replica;
 import org.dataone.service.types.ReplicationPolicy;
 import org.dataone.service.types.ReplicationStatus;
-            leinfelder
+import org.dataone.service.types.Subject;
-            berkley
+import org.dataone.service.types.SystemMetadata;
             jones
 import edu.ucsb.nceas.metacat.database.DBConnection;
 import edu.ucsb.nceas.metacat.database.DBConnectionPool;
-            berkley
+import edu.ucsb.nceas.metacat.properties.PropertyService;
-            jones
+import edu.ucsb.nceas.metacat.util.DocumentUtil;
             jones
 /**
  * Manage the relationship between Metacat local identifiers (LocalIDs) that are
-            leinfelder
+ * codified as the (docid, rev) pair with globally unique string identifiers
-            jones
+ * (GUIDs) that are opaque strings.  This class provides methods to manage these
  * identifiers, and to search for and look up LocalIDs based on their GUID and
  * vice versa. IdentifierManager is a singleton.
+ *
  * @author Matthew Jones
  */
 public class IdentifierManager {
-            berkley
+    public static final String TYPE_SYSTEM_METADATA = "systemmetadata";
     public static final String TYPE_IDENTIFIER = "identifier";
-            jones
+    /**
      * The single instance of the manager that is always returned.
      */
     private static IdentifierManager self = null;
-            leinfelder
+    private Logger logMetacat = Logger.getLogger(IdentifierManager.class);
             jones
     /**
      * A private constructor that initializes the class when getInstance() is
      * called.
      */
-            leinfelder
+    private IdentifierManager() {}
             jones
     /**
      * Return the single instance of the manager after initializing it if it
      * wasn't previously initialized.
+     *
      * @return the single IdentifierManager instance
      */
     public static IdentifierManager getInstance()
+    {
         if (self == null) {
             self = new IdentifierManager();
+        }
         return self;
+    }
-            leinfelder
+    public SystemMetadata asSystemMetadata(Date dateUploaded, String rightsHolder,
             String checksum, String checksumAlgorithm, String originMemberNode,
             String authoritativeMemberNode, Date dateModified, String submitter,
             String guid, String objectFormat, long size) {
         SystemMetadata sysMeta = new SystemMetadata();
         Identifier sysMetaId = new Identifier();
         sysMetaId.setValue(guid);
         sysMeta.setIdentifier(sysMetaId);
         sysMeta.setDateUploaded(dateUploaded);
         Subject rightsHolderSubject = new Subject();
         rightsHolderSubject.setValue(rightsHolder);
         sysMeta.setRightsHolder(rightsHolderSubject);
         Checksum checksumObject = new Checksum();
         checksumObject.setValue(checksum);
         checksumObject.setAlgorithm(ChecksumAlgorithm.convert(checksumAlgorithm));
         sysMeta.setChecksum(checksumObject);
         NodeReference omn = new NodeReference();
         omn.setValue(originMemberNode);
         sysMeta.setOriginMemberNode(omn);
         NodeReference amn = new NodeReference();
         amn.setValue(authoritativeMemberNode);
         sysMeta.setAuthoritativeMemberNode(amn);
         sysMeta.setDateSysMetadataModified(dateModified);
         Subject submitterSubject = new Subject();
         submitterSubject.setValue(submitter);
         sysMeta.setSubmitter(submitterSubject);
         sysMeta.setObjectFormat(ObjectFormat.convert(objectFormat));
         sysMeta.setSize(size);
         return sysMeta;
+    }
-            jones
+    /**
-            berkley
+     * return a hash of all of the info that is in the systemmetadata table
      * @param localId
      * @return
      */
     public Hashtable<String, String> getSystemMetadataInfo(String localId)
     throws McdbDocNotFoundException
+    {
         try
+        {
             AccessionNumber acc = new AccessionNumber(localId, "NONE");
             localId = acc.getDocid();
+        }
         catch(Exception e)
+        {
             //do nothing. just try the localId as it is
+        }
         Hashtable<String, String> h = new Hashtable<String, String>();
         String sql = "select guid, date_uploaded, rights_holder, checksum, checksum_algorithm, " +
-            berkley
+          "origin_member_node, authoritive_member_node, date_modified, submitter, object_format, size " +
-            berkley
+          "from systemmetadata where docid = ?";
         DBConnection dbConn = null;
         int serialNumber = -1;
         try
+        {
             // Get a database connection from the pool
             dbConn = DBConnectionPool.getDBConnection("IdentifierManager.getDocumentInfo");
             serialNumber = dbConn.getCheckOutSerialNumber();
             // Execute the insert statement
             PreparedStatement stmt = dbConn.prepareStatement(sql);
             stmt.setString(1, localId);
             ResultSet rs = stmt.executeQuery();
             if (rs.next())
+            {
                 String guid = rs.getString(1);
                 Timestamp dateUploaded = rs.getTimestamp(2);
                 String rightsHolder = rs.getString(3);
                 String checksum = rs.getString(4);
                 String checksumAlgorithm = rs.getString(5);
                 String originMemberNode = rs.getString(6);
                 String authoritativeMemberNode = rs.getString(7);
                 Timestamp dateModified = rs.getTimestamp(8);
                 String submitter = rs.getString(9);
-            berkley
+                String objectFormat = rs.getString(10);
                 long size = new Long(rs.getString(11)).longValue();
             berkley
                 h.put("guid", guid);
                 h.put("date_uploaded", new Long(dateUploaded.getTime()).toString());
                 h.put("rights_holder", rightsHolder);
                 h.put("checksum", checksum);
                 h.put("checksum_algorithm", checksumAlgorithm);
                 h.put("origin_member_node", originMemberNode);
                 h.put("authoritative_member_node", authoritativeMemberNode);
                 h.put("date_modified", new Long(dateModified.getTime()).toString());
                 h.put("submitter", submitter);
-            berkley
+                h.put("object_format", objectFormat);
                 h.put("size", new Long(size).toString());
             berkley
                 stmt.close();
+            }
             else
+            {
                 stmt.close();
                 DBConnectionPool.returnDBConnection(dbConn, serialNumber);
                 throw new McdbDocNotFoundException("2Could not find document " + localId);
+            }
+        }
         catch (SQLException e)
+        {
             e.printStackTrace();
             logMetacat.error("Error while getting system metadata info for localid " + localId + " : "
                     + e.getMessage());
+        }
         finally
+        {
             // Return database connection to the pool
             DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+        }
         return h;
+    }
     /**
-            leinfelder
+     * return a hash of all of the info that is in the systemmetadata table
-            leinfelder
+     * @param guid
-            leinfelder
+     * @return
      */
-            leinfelder
+    public SystemMetadata getSystemMetadata(String guid)
-            leinfelder
+    	throws McdbDocNotFoundException
+    {
             leinfelder
-            leinfelder
+        SystemMetadata sysMeta = new SystemMetadata();
         String sql = "select guid, date_uploaded, rights_holder, checksum, checksum_algorithm, " +
           "origin_member_node, authoritive_member_node, date_modified, submitter, object_format, size " +
-            leinfelder
+          "from systemmetadata where guid = ?";
-            leinfelder
+        DBConnection dbConn = null;
         int serialNumber = -1;
         try
+        {
             // Get a database connection from the pool
             dbConn = DBConnectionPool.getDBConnection("IdentifierManager.getSystemMetadata");
             serialNumber = dbConn.getCheckOutSerialNumber();
             // Execute the statement
             PreparedStatement stmt = dbConn.prepareStatement(sql);
-            leinfelder
+            stmt.setString(1, guid);
-            leinfelder
+            ResultSet rs = stmt.executeQuery();
             if (rs.next())
+            {
                 Timestamp dateUploaded = rs.getTimestamp(2);
                 String rightsHolder = rs.getString(3);
                 String checksum = rs.getString(4);
                 String checksumAlgorithm = rs.getString(5);
                 String originMemberNode = rs.getString(6);
                 String authoritativeMemberNode = rs.getString(7);
                 Timestamp dateModified = rs.getTimestamp(8);
                 String submitter = rs.getString(9);
                 String objectFormat = rs.getString(10);
                 long size = new Long(rs.getString(11)).longValue();
                 Identifier sysMetaId = new Identifier();
                 sysMetaId.setValue(guid);
                 sysMeta.setIdentifier(sysMetaId);
                 sysMeta.setDateUploaded(dateUploaded);
                 Subject rightsHolderSubject = new Subject();
                 rightsHolderSubject.setValue(rightsHolder);
                 sysMeta.setRightsHolder(rightsHolderSubject);
                 Checksum checksumObject = new Checksum();
                 checksumObject.setValue(checksum);
                 checksumObject.setAlgorithm(ChecksumAlgorithm.convert(checksumAlgorithm));
                 sysMeta.setChecksum(checksumObject);
                 NodeReference omn = new NodeReference();
                 omn.setValue(originMemberNode);
                 sysMeta.setOriginMemberNode(omn);
                 NodeReference amn = new NodeReference();
                 amn.setValue(authoritativeMemberNode);
                 sysMeta.setAuthoritativeMemberNode(amn);
                 sysMeta.setDateSysMetadataModified(dateModified);
                 Subject submitterSubject = new Subject();
                 submitterSubject.setValue(submitter);
                 sysMeta.setSubmitter(submitterSubject);
                 sysMeta.setObjectFormat(ObjectFormat.convert(objectFormat));
                 sysMeta.setSize(size);
                 stmt.close();
+            }
             else
+            {
                 stmt.close();
                 DBConnectionPool.returnDBConnection(dbConn, serialNumber);
-            leinfelder
+                throw new McdbDocNotFoundException("Could not find " + guid);
             leinfelder
+        }
         catch (SQLException e)
+        {
             e.printStackTrace();
-            leinfelder
+            logMetacat.error("Error while getting system metadata for guid " + guid + " : "
-            leinfelder
+                    + e.getMessage());
+        }
         finally
+        {
             // Return database connection to the pool
             DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+        }
         // look up provenance information
         sysMeta.setObsoleteList(getSystemMetadataProvenance(sysMeta.getIdentifier().getValue(), "obsoletes"));
         sysMeta.setObsoletedByList(getSystemMetadataProvenance(sysMeta.getIdentifier().getValue(), "obsoletedBy"));
         sysMeta.setDescribeList(getSystemMetadataProvenance(sysMeta.getIdentifier().getValue(), "describes"));
         sysMeta.setDescribedByList(getSystemMetadataProvenance(sysMeta.getIdentifier().getValue(), "describedBy"));
         sysMeta.setDerivedFromList(getSystemMetadataProvenance(sysMeta.getIdentifier().getValue(), "derivedFrom"));
-            leinfelder
+        // look up replication policy
         ReplicationPolicy replicationPolicy = new ReplicationPolicy();
         replicationPolicy.setBlockedMemberNodeList(getReplicationPolicy(guid, "blocked"));
         replicationPolicy.setPreferredMemberNodeList(getReplicationPolicy(guid, "preferred"));
 		sysMeta.setReplicationPolicy(replicationPolicy);
 		// look up replication status
 		sysMeta.setReplicaList(getReplicationStatus(guid));
-            leinfelder
+        return sysMeta;
+    }
     private List<Identifier> getSystemMetadataProvenance(String guid, String relationship)
     	throws McdbDocNotFoundException {
     	List<Identifier> identifiers = new ArrayList<Identifier>();
     	String sql = "select guid, relationship, target_guid " +
     		"from systemMetadataProvenance where guid = ? and relationship = ?";
-            leinfelder
+	    DBConnection dbConn = null;
 	    int serialNumber = -1;
 	    try {
 	        // Get a database connection from the pool
 	        dbConn = DBConnectionPool.getDBConnection("IdentifierManager.getSystemMetadataProvenance");
 	        serialNumber = dbConn.getCheckOutSerialNumber();
 	        // Execute the statement
 	        PreparedStatement stmt = dbConn.prepareStatement(sql);
 	        stmt.setString(1, guid);
 	        stmt.setString(2, relationship);
 	        ResultSet rs = stmt.executeQuery();
 	        while (rs.next())
+	        {
 	            String targetGuid = rs.getString(3);
 	            Identifier id = new Identifier();
 	            id.setValue(targetGuid);
 	            identifiers.add(id);
+	        }
 	        stmt.close();
+	    }
 	    catch (SQLException e) {
 	        logMetacat.error("Error while getting system metadata provenance for guid " + guid, e);
+	    }
 	    finally {
 	        // Return database connection to the pool
 	        DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+	    }
 	    return identifiers;
+	}
             leinfelder
-            leinfelder
+    private List<NodeReference> getReplicationPolicy(String guid, String policy)
 		throws McdbDocNotFoundException {
 		List<NodeReference> nodes = new ArrayList<NodeReference>();
 		String sql = "select guid, policy, member_node " +
 			"from systemMetadataReplicationPolicy where guid = ? and policy = ?";
 	    DBConnection dbConn = null;
 	    int serialNumber = -1;
 	    try {
 	        // Get a database connection from the pool
 	        dbConn = DBConnectionPool.getDBConnection("IdentifierManager.getReplicationPolicy");
 	        serialNumber = dbConn.getCheckOutSerialNumber();
 	        // Execute the statement
 	        PreparedStatement stmt = dbConn.prepareStatement(sql);
 	        stmt.setString(1, guid);
 	        stmt.setString(2, policy);
 	        ResultSet rs = stmt.executeQuery();
 	        while (rs.next())
+	        {
 	            String memberNode = rs.getString(3);
 	            NodeReference node = new NodeReference();
 	            node.setValue(memberNode);
 	            nodes.add(node);
+	        }
 	        stmt.close();
 	    } catch (SQLException e) {
 	        logMetacat.error("Error while getting system metadata replication policy for guid " + guid, e);
+	    }
 	    finally {
 	        // Return database connection to the pool
 	        DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+	    }
 	    return nodes;
+	}
             leinfelder
-            leinfelder
+    private List<Replica> getReplicationStatus(String guid) throws McdbDocNotFoundException {
 		List<Replica> replicas = new ArrayList<Replica>();
 		String sql = "select guid, member_node, status, date_verified " +
 			"from systemMetadataReplicationStatus where guid = ?";
 	    DBConnection dbConn = null;
 	    int serialNumber = -1;
 	    try {
 	        // Get a database connection from the pool
 	        dbConn = DBConnectionPool.getDBConnection("IdentifierManager.getReplicas");
 	        serialNumber = dbConn.getCheckOutSerialNumber();
 	        // Execute the statement
 	        PreparedStatement stmt = dbConn.prepareStatement(sql);
 	        stmt.setString(1, guid);
 	        ResultSet rs = stmt.executeQuery();
 	        while (rs.next())
+	        {
 	            String memberNode = rs.getString(2);
 	            String status = rs.getString(3);
 	            java.sql.Date verified = rs.getDate(4);
 	            Replica replica = new Replica();
 	            NodeReference node = new NodeReference();
 	            node.setValue(memberNode);
 	            replica.setReplicaMemberNode(node);
 	            replica.setReplicationStatus(ReplicationStatus.convert(status));
 	            replica.setReplicaVerified(new Date(verified.getTime()));
 	            replicas.add(replica);
+	        }
 	        stmt.close();
 	    } catch (SQLException e) {
 	        logMetacat.error("Error while getting system metadata replication policy for guid " + guid, e);
+	    }
 	    finally {
 	        // Return database connection to the pool
 	        DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+	    }
 	    return replicas;
+	}
-            leinfelder
+    /**
-            berkley
+     * return information on the document with localId.  These are the fields
      * from the xml_documents table.  They can be used to contstruct metadata
      * about the object that is stored.
      * @param localId
      * @return
      * @throws McdbDocNotFoundException
      */
-            berkley
+    public Hashtable<String, Object> getDocumentInfo(String localId)
-            berkley
+        throws McdbDocNotFoundException
+    {
-            berkley
+        try
+        {
             AccessionNumber acc = new AccessionNumber(localId, "NONE");
             localId = acc.getDocid();
+        }
         catch(Exception e)
+        {
             //do nothing. just try the localId as it is
+        }
-            berkley
+        Hashtable<String, Object> h = new Hashtable<String, Object>();
-            berkley
+        String sql = "select docname, doctype, user_owner, user_updated, " +
             "server_location, rev, date_created, date_updated from " +
             "xml_documents where docid like '" + localId + "'";
         DBConnection dbConn = null;
         int serialNumber = -1;
         try
+        {
             // Get a database connection from the pool
             dbConn = DBConnectionPool.getDBConnection("IdentifierManager.getDocumentInfo");
             serialNumber = dbConn.getCheckOutSerialNumber();
             // Execute the insert statement
             PreparedStatement stmt = dbConn.prepareStatement(sql);
             ResultSet rs = stmt.executeQuery();
             if (rs.next())
+            {
                 String docname = rs.getString(1);
                 String doctype = rs.getString(2);
                 String user_owner = rs.getString(3);
                 String user_updated = rs.getString(4);
                 String server_location = rs.getString(5);
                 int rev = rs.getInt(6);
                 String date_created = rs.getString(7);
                 String date_updated = rs.getString(8);
-            cjones
+                h.put("docid", localId);
-            berkley
+                h.put("docname", docname);
                 h.put("doctype", doctype);
                 h.put("user_owner", user_owner);
                 h.put("user_updated", user_updated);
                 h.put("server_location", server_location);
                 h.put("rev", new Integer(rev).toString());
                 h.put("date_created", date_created);
                 h.put("date_updated", date_updated);
                 stmt.close();
+            }
             else
+            {
                 stmt.close();
                 DBConnectionPool.returnDBConnection(dbConn, serialNumber);
-            berkley
+                throw new McdbDocNotFoundException("2Could not find document " + localId);
             berkley
             berkley
-            berkley
+            String sql2 = "select principal_name, permission, perm_type, perm_order from xml_access " +
-            berkley
+            "where docid like '" + localId + "'";
-            leinfelder
+            logMetacat.debug("executing sql: " + sql2);
-            berkley
+            PreparedStatement stmt2 = dbConn.prepareStatement(sql2);
-            berkley
+            rs = stmt2.executeQuery();
-            berkley
+            Vector accessVector = new Vector();
-            berkley
+            while(rs.next())
             berkley
                 Hashtable accessHash = new Hashtable();
                 String principal_name = rs.getString(1);
                 String permission = rs.getString(2);
                 String permissionType = rs.getString(3);
                 String permissionOrder = rs.getString(4);
                 accessHash.put("principal_name", principal_name);
                 accessHash.put("permission", permission);
                 accessHash.put("permission_type", permissionType);
                 accessHash.put("permission_order", permissionOrder);
-            leinfelder
+                logMetacat.debug("accessHash: " + accessHash.toString());
-            berkley
+                accessVector.add(accessHash);
+            }
             h.put("access", accessVector);
             berkley
         catch (SQLException e)
+        {
-            berkley
+            e.printStackTrace();
-            berkley
+            logMetacat.error("Error while getting document info for localid " + localId + " : "
                     + e.getMessage());
+        }
         finally
+        {
             // Return database connection to the pool
             DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+        }
         return h;
+    }
     /**
      * return the newest rev for a given localId
      * @param localId
      * @return
      */
     public int getLatestRevForLocalId(String localId)
         throws McdbDocNotFoundException
+    {
-            berkley
+        try
+        {
             AccessionNumber acc = new AccessionNumber(localId, "NONE");
             localId = acc.getDocid();
+        }
         catch(Exception e)
+        {
             //do nothing. just try the localId as it is
+        }
-            berkley
+        int rev = 0;
         String sql = "select rev from xml_documents where docid like '" + localId + "'";
         DBConnection dbConn = null;
         int serialNumber = -1;
         try
+        {
             // Get a database connection from the pool
             dbConn = DBConnectionPool.getDBConnection("IdentifierManager.getLatestRevForLocalId");
             serialNumber = dbConn.getCheckOutSerialNumber();
             // Execute the insert statement
             PreparedStatement stmt = dbConn.prepareStatement(sql);
             ResultSet rs = stmt.executeQuery();
             if (rs.next())
+            {
                 rev = rs.getInt(1);
                 stmt.close();
+            }
             else
+            {
                 stmt.close();
                 DBConnectionPool.returnDBConnection(dbConn, serialNumber);
-            berkley
+                throw new McdbDocNotFoundException("While trying to get the latest rev, could not find document " + localId);
             berkley
+        }
         catch (SQLException e)
+        {
             logMetacat.error("Error while looking up the guid: "
                     + e.getMessage());
+        }
         finally
+        {
             // Return database connection to the pool
             DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+        }
         return rev;
+    }
     /**
-            berkley
+     * return all local ids in the object store that do not have associated
-            leinfelder
+     * system metadata
-            berkley
+     */
     public List<String> getLocalIdsWithNoSystemMetadata()
+    {
         Vector<String> ids = new Vector<String>();
-            leinfelder
+        String sql = "select docid, rev from xml_documents " +
         		"where docid not in " +
         		"(select docid from identifier where guid in (select guid from systemmetadata)))";
-            berkley
+        DBConnection dbConn = null;
         int serialNumber = -1;
         try
+        {
             // Get a database connection from the pool
             dbConn = DBConnectionPool.getDBConnection("IdentifierManager.getLocalIdsWithNoSystemMetadata");
             serialNumber = dbConn.getCheckOutSerialNumber();
             // Execute the insert statement
             PreparedStatement stmt = dbConn.prepareStatement(sql);
             ResultSet rs = stmt.executeQuery();
             while (rs.next())
+            {
                 String localid = rs.getString(1);
-            berkley
+                String rev = rs.getString(2);
                 localid += "." + rev;
-            leinfelder
+                logMetacat.debug("id to add SM for: " + localid);
-            berkley
+                ids.add(localid);
+            }
             stmt.close();
+        }
         catch (SQLException e)
+        {
             logMetacat.error("Error while looking up the guid: "
                     + e.getMessage());
+        }
         finally
+        {
             // Return database connection to the pool
             DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+        }
         return ids;
+    }
     /**
      * return a listing of all local ids in the object store
      * @return a list of all local ids in metacat
      */
     public List<String> getAllLocalIds()
        throws Exception
+    {
         Vector<String> ids = new Vector<String>();
         String sql = "select docid from xml_documents";
         DBConnection dbConn = null;
         int serialNumber = -1;
         try
+        {
             // Get a database connection from the pool
             dbConn = DBConnectionPool.getDBConnection("IdentifierManager.getAllLocalIds");
             serialNumber = dbConn.getCheckOutSerialNumber();
             // Execute the insert statement
             PreparedStatement stmt = dbConn.prepareStatement(sql);
             ResultSet rs = stmt.executeQuery();
             while (rs.next())
+            {
                 String localid = rs.getString(1);
                 ids.add(localid);
+            }
             stmt.close();
+        }
         catch (SQLException e)
+        {
             logMetacat.error("Error while looking up the guid: "
                     + e.getMessage());
+        }
         finally
+        {
             // Return database connection to the pool
             DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+        }
         return ids;
+    }
             leinfelder
             jones
     /**
      * Determine if an identifier exists already, returning true if so.
+     *
      * @param guid the global identifier to look up
      * @return boolean true if the identifier exists
      */
     public boolean identifierExists(String guid)
+    {
         boolean idExists = false;
         try {
             String id = getLocalId(guid);
             if (id != null) {
                 idExists = true;
+            }
         } catch (McdbDocNotFoundException e) {
             idExists = false;
+        }
         return idExists;
+    }
     /**
+     *
-            berkley
+     * @param guid
      * @param rev
      * @return
      */
     public String generateLocalId(String guid, int rev)
+    {
         return generateLocalId(guid, rev, false);
+    }
             jones
     /**
      * Given a global identifier (guid), create a suitable local identifier that
      * follows Metacat's docid semantics and format (scope.id.rev), and create
      * a mapping between these two identifiers.  This effectively reserves both
      * the global and the local identifier, as they will now be present in the
      * identifier mapping table.  If the incoming guid has the syntax of a
      * Metacat docid (scope.id.rev), then simply use it.
+     *
      * @param guid the global string identifier
      * @param rev the revision number to be used in the localId
      * @return String containing the localId to be used for Metacat operations
      */
-            berkley
+    public String generateLocalId(String guid, int rev, boolean isSystemMetadata)
             jones
         String localId = "";
         boolean conformsToDocidFormat = false;
         // Check if the guid passed in is already in docid (scope.id.rev) format
         try {
             AccessionNumber acc = new AccessionNumber(guid, "NONE");
             if (new Integer(acc.getRev()).intValue() > 0) {
                 conformsToDocidFormat = true;
+            }
         } catch (NumberFormatException e) {
             // No action needed, simply detecting invalid AccessionNumbers
         } catch (AccessionNumberException e) {
             // No action needed, simply detecting invalid AccessionNumbers
         } catch (SQLException e) {
             // No action needed, simply detecting invalid AccessionNumbers
+        }
         if (conformsToDocidFormat) {
             // if it conforms, use it for both guid and localId
             localId = guid;
         } else {
             // if not, then generate a new unique localId
             localId = DocumentUtil.generateDocumentId(rev);
+        }
         // Register this new pair in the identifier mapping table
-            leinfelder
+        logMetacat.debug("creating mapping in generateLocalId");
-            berkley
+        if(!isSystemMetadata)
         { //don't do this if we're generating for system metadata
             createMapping(guid, localId);
+        }
             jones
         return localId;
+    }
             berkley
     /**
      * given a local identifer, look up the guid.  Throw McdbDocNotFoundException
-            berkley
+     * if the docid, rev is not found in the identifiers or systemmetadata tables
             berkley
      * @param docid the docid to look up
      * @param rev the revision of the docid to look up
      * @return String containing the mapped guid
      * @throws McdbDocNotFoundException if the docid, rev is not found
      */
     public String getGUID(String docid, int rev)
       throws McdbDocNotFoundException
+    {
-            leinfelder
+        logMetacat.debug("getting guid for " + docid);
-            berkley
+        String query = "select guid from identifier where docid = ? and rev = ?";
         String guid = null;
         DBConnection dbConn = null;
         int serialNumber = -1;
         try {
             // Get a database connection from the pool
-            berkley
+            dbConn = DBConnectionPool.getDBConnection("IdentifierManager.getGUID");
-            berkley
+            serialNumber = dbConn.getCheckOutSerialNumber();
             // Execute the insert statement
             PreparedStatement stmt = dbConn.prepareStatement(query);
             stmt.setString(1, docid);
             stmt.setInt(2, rev);
             ResultSet rs = stmt.executeQuery();
-            berkley
+            if (rs.next())
+            {
-            berkley
+                guid = rs.getString(1);
             berkley
             else
+            {
-            leinfelder
+            	throw new McdbDocNotFoundException("No guid registered for docid " + docid + "." + rev);
             berkley
             berkley
-            berkley
+        } catch (SQLException e) {
             logMetacat.error("Error while looking up the guid: "
                     + e.getMessage());
         } finally {
             // Return database connection to the pool
             DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+        }
         return guid;
+    }
             berkley
     /**
-            berkley
+     * creates a system metadata mapping and adds additional fields from sysmeta
      * to the table for quick searching.
+     *
      * @param guid the id to insert
      * @param localId the systemMetadata object to get the local id for
      */
-            leinfelder
+    public void createSystemMetadata(SystemMetadata sysmeta)
             berkley
-            leinfelder
+        insertSystemMetadata(sysmeta.getIdentifier().getValue());
         updateSystemMetadata(sysmeta);
             berkley
             leinfelder
             berkley
     /**
-            leinfelder
+     * update a mapping
      * @param guid
      * @param localId
      */
     public void updateMapping(String guid, String localId)
+    {
-            leinfelder
+        logMetacat.debug("$$$$$$$$$$$$$$ updating mapping table");
-            berkley
+        int serialNumber = -1;
         DBConnection dbConn = null;
         try {
             // Parse the localId into scope and rev parts
             AccessionNumber acc = new AccessionNumber(localId, "NOACTION");
             String docid = acc.getDocid();
             int rev = 1;
             if(acc.getRev() != null)
+            {
               rev = (new Integer(acc.getRev()).intValue());
+            }
             // Get a database connection from the pool
             dbConn =
-            leinfelder
+                DBConnectionPool.getDBConnection("IdentifierManager.updateMapping");
-            berkley
+            serialNumber = dbConn.getCheckOutSerialNumber();
-            leinfelder
+            // Execute the update statement
             String query = "update " + TYPE_IDENTIFIER + " set (docid, rev) = (?, ?) where guid='" + guid + "'";
-            berkley
+            PreparedStatement stmt = dbConn.prepareStatement(query);
             stmt.setString(1, docid);
             stmt.setInt(2, rev);
             int rows = stmt.executeUpdate();
             stmt.close();
         } catch (SQLException e) {
             e.printStackTrace();
-            leinfelder
+            logMetacat.error("SQL error while updating a mapping identifier: "
-            berkley
+                    + e.getMessage());
         } catch (NumberFormatException e) {
             e.printStackTrace();
-            leinfelder
+            logMetacat.error("NumberFormat error while updating a mapping identifier: "
-            berkley
+                    + e.getMessage());
         } catch (AccessionNumberException e) {
             e.printStackTrace();
-            leinfelder
+            logMetacat.error("AccessionNumber error while updating a mapping identifier: "
-            berkley
+                    + e.getMessage());
         } finally {
             // Return database connection to the pool
             DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+        }
-            leinfelder
+        logMetacat.debug("done updating mapping");
             berkley
             leinfelder
     private void updateSystemMetadataFields(long dateUploaded, String rightsHolder,
-            berkley
+            String checksum, String checksumAlgorithm, String originMemberNode,
-            berkley
+            String authoritativeMemberNode, long modifiedDate, String submitter,
-            leinfelder
+            String guid, String objectFormat, long size, boolean replicationAllowed,
             int numberReplicas)
             berkley
         DBConnection dbConn = null;
         int serialNumber = -1;
             berkley
-            berkley
+        try {
             // Get a database connection from the pool
             dbConn =
                 DBConnectionPool.getDBConnection("IdentifierManager.createMapping");
             serialNumber = dbConn.getCheckOutSerialNumber();
             // Execute the insert statement
             String query = "update " + TYPE_SYSTEM_METADATA +
                 " set (date_uploaded, rights_holder, checksum, checksum_algorithm, " +
-            berkley
+                "origin_member_node, authoritive_member_node, date_modified, " +
-            leinfelder
+                "submitter, object_format, size, replication_allowed, number_replicas) " +
                 "= (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) where guid = ?";
-            berkley
+            PreparedStatement stmt = dbConn.prepareStatement(query);
             //data values
             stmt.setTimestamp(1, new java.sql.Timestamp(dateUploaded));
             stmt.setString(2, rightsHolder);
             stmt.setString(3, checksum);
             stmt.setString(4, checksumAlgorithm);
             stmt.setString(5, originMemberNode);
             stmt.setString(6, authoritativeMemberNode);
             stmt.setTimestamp(7, new java.sql.Timestamp(modifiedDate));
             stmt.setString(8, submitter);
-            berkley
+            stmt.setString(9, objectFormat);
             stmt.setString(10, new Long(size).toString());
-            leinfelder
+            stmt.setBoolean(11, replicationAllowed);
             stmt.setInt(12, numberReplicas);
-            berkley
+            //where clause
-            leinfelder
+            stmt.setString(13, guid);
-            leinfelder
+            logMetacat.debug("stmt: " + stmt.toString());
-            berkley
+            //execute
             int rows = stmt.executeUpdate();
             stmt.close();
         } catch (SQLException e) {
             e.printStackTrace();
-            berkley
+            logMetacat.error("insertAdditionalSystemMetadataFields: SQL error while creating a mapping to the system metadata identifier: "
-            berkley
+                    + e.getMessage());
         } catch (NumberFormatException e) {
             e.printStackTrace();
-            berkley
+            logMetacat.error("insertAdditionalSystemMetadataFields: NumberFormat error while creating a mapping to the system metadata identifier: "
-            berkley
+                    + e.getMessage());
         } finally {
             // Return database connection to the pool
             DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+        }
+    }
-            leinfelder
+    private void insertSystemMetadataProvenance(String guid, String relationship, List<String> targetGuids)
+    {
         DBConnection dbConn = null;
         int serialNumber = -1;
         try {
             // Get a database connection from the pool
             dbConn =
-            leinfelder
+                DBConnectionPool.getDBConnection("IdentifierManager.insertSystemMetadataProvenance");
-            leinfelder
+            serialNumber = dbConn.getCheckOutSerialNumber();
             // remove existing values first
             String delete = "delete from systemMetadataProvenance " +
             "where guid = ? and relationship = ?";
 	        PreparedStatement stmt = dbConn.prepareStatement(delete);
 	        //data values
 	        stmt.setString(1, guid);
 	        stmt.setString(2, relationship);
 	        //execute
 	        int deletedCount = stmt.executeUpdate();
 	        stmt.close();
             for (String targetGuid: targetGuids) {
 	            // Execute the insert statement
 	            String insert = "insert into systemMetadataProvenance " +
 	                "(guid, relationship, target_guid) " +
 	                "values (?, ?, ?)";
 	            PreparedStatement insertStatement = dbConn.prepareStatement(insert);
 	            //data values
 	            insertStatement.setString(1, guid);
 	            insertStatement.setString(2, relationship);
 	            insertStatement.setString(3, targetGuid);
 	            //execute
 	            int rows = insertStatement.executeUpdate();
 	            insertStatement.close();
+            }
         } catch (SQLException e) {
             logMetacat.error("SQL error while adding systemMetadataProvenance for: " + guid, e);
         } finally {
             // Return database connection to the pool
             DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+        }
+    }
-            leinfelder
+    private void insertReplicationPolicy(String guid, String policy, List<String> memberNodes)
+    {
         DBConnection dbConn = null;
         int serialNumber = -1;
         try {
             // Get a database connection from the pool
             dbConn =
                 DBConnectionPool.getDBConnection("IdentifierManager.insertReplicationPolicy");
             serialNumber = dbConn.getCheckOutSerialNumber();
             // remove existing values first
             String delete = "delete from systemMetadataReplicationPolicy " +
             "where guid = ? and policy = ?";
 	        PreparedStatement stmt = dbConn.prepareStatement(delete);
 	        //data values
 	        stmt.setString(1, guid);
 	        stmt.setString(2, policy);
 	        //execute
 	        int deletedCount = stmt.executeUpdate();
 	        stmt.close();
             for (String memberNode: memberNodes) {
 	            // Execute the insert statement
 	            String insert = "insert into systemMetadataReplicationPolicy " +
 	                "(guid, policy, member_node) " +
 	                "values (?, ?, ?)";
 	            PreparedStatement insertStatement = dbConn.prepareStatement(insert);
 	            //data values
 	            insertStatement.setString(1, guid);
 	            insertStatement.setString(2, policy);
 	            insertStatement.setString(3, memberNode);
 	            //execute
 	            int rows = insertStatement.executeUpdate();
 	            insertStatement.close();
+            }
         } catch (SQLException e) {
             logMetacat.error("SQL error while adding systemMetadataReplicationPolicy for: " + guid, e);
         } finally {
             // Return database connection to the pool
             DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+        }
+    }
     private void insertReplicationStatus(String guid, List<Replica> replicas) {
         DBConnection dbConn = null;
         int serialNumber = -1;
         try {
             // Get a database connection from the pool
             dbConn = DBConnectionPool.getDBConnection("IdentifierManager.insertReplicas");
             serialNumber = dbConn.getCheckOutSerialNumber();
             // remove existing values first
             String delete = "delete from systemMetadataReplicationStatus " +
             "where guid = ?";
 	        PreparedStatement stmt = dbConn.prepareStatement(delete);
 	        //data values
 	        stmt.setString(1, guid);
 	        //execute
 	        int deletedCount = stmt.executeUpdate();
 	        stmt.close();
             for (Replica replica: replicas) {
 	            // Execute the insert statement
 	            String insert = "insert into systemMetadataReplicationStatus " +
 	                "(guid, member_node, status, date_verified) " +
 	                "values (?, ?, ?, ?)";
 	            PreparedStatement insertStatement = dbConn.prepareStatement(insert);
 	            //data values
 	            String memberNode = replica.getReplicaMemberNode().getValue();
 	            String status = replica.getReplicationStatus().toString();
 	            java.sql.Date sqlDate = new java.sql.Date(replica.getReplicaVerified().getTime());
 	            insertStatement.setString(1, guid);
 	            insertStatement.setString(2, memberNode);
 	            insertStatement.setString(3, status);
 	            insertStatement.setDate(4, sqlDate);
 	            //execute
 	            int rows = insertStatement.executeUpdate();
 	            insertStatement.close();
+            }
         } catch (SQLException e) {
             logMetacat.error("SQL error while adding systemMetadataReplicationStatus for: " + guid, e);
         } finally {
             // Return database connection to the pool
             DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+        }
+    }
-            berkley
+    /**
-            berkley
+     * Insert the system metadata fields into the db
      * @param sm
      */
-            leinfelder
+    public void updateSystemMetadata(SystemMetadata sm) {
         Boolean replicationAllowed = false;
 		Integer numberReplicas = -1;
     	ReplicationPolicy replicationPolicy = sm.getReplicationPolicy();
     	if (replicationPolicy != null) {
     		replicationAllowed = replicationPolicy.getReplicationAllowed();
     		numberReplicas = replicationPolicy.getNumberReplicas();
     		replicationAllowed = replicationAllowed == null ? false: replicationAllowed;
     		numberReplicas = numberReplicas == null ? -1: numberReplicas;
+    	}
     	// the main systemMetadata fields
 		updateSystemMetadataFields(
-            berkley
+                sm.getDateUploaded().getTime(),
                 sm.getRightsHolder().getValue(),
                 sm.getChecksum().getValue(),
                 sm.getChecksum().getAlgorithm().name(),
                 sm.getOriginMemberNode().getValue(),
                 sm.getAuthoritativeMemberNode().getValue(),
                 sm.getDateSysMetadataModified().getTime(),
                 sm.getSubmitter().getValue(),
-            berkley
+                sm.getIdentifier().getValue(),
                 sm.getObjectFormat().toString(),
-            leinfelder
+                sm.getSize(),
                 replicationAllowed,
                 numberReplicas);
             leinfelder
         // add provenance information
         String guid = sm.getIdentifier().getValue();
         List<String> targetGuids = null;
         String relationship = null;
         relationship = "obsoletedBy";
         targetGuids = new ArrayList<String>();
         for (Identifier id: sm.getObsoletedByList()) {
         	targetGuids.add(id.getValue());
+        }
         this.insertSystemMetadataProvenance(guid, relationship, targetGuids);
         relationship = "obsoletes";
         targetGuids = new ArrayList<String>();
         for (Identifier id: sm.getObsoleteList()) {
         	targetGuids.add(id.getValue());
+        }
         this.insertSystemMetadataProvenance(guid, relationship, targetGuids);
         relationship = "describes";
         targetGuids = new ArrayList<String>();
         for (Identifier id: sm.getDescribeList()) {
         	targetGuids.add(id.getValue());
+        }
         this.insertSystemMetadataProvenance(guid, relationship, targetGuids);
         relationship = "describedBy";
         targetGuids = new ArrayList<String>();
         for (Identifier id: sm.getDescribedByList()) {
         	targetGuids.add(id.getValue());
+        }
         this.insertSystemMetadataProvenance(guid, relationship, targetGuids);
         relationship = "derivedFrom";
         targetGuids = new ArrayList<String>();
         for (Identifier id: sm.getDerivedFromList()) {
         	targetGuids.add(id.getValue());
+        }
         this.insertSystemMetadataProvenance(guid, relationship, targetGuids);
             leinfelder
         // save replication policies
         if (replicationPolicy != null) {
 		    List<String> nodes = null;
 		    String policy = null;
 		    nodes = new ArrayList<String>();
 		    policy = "blocked";
 		    for (NodeReference node: replicationPolicy.getBlockedMemberNodeList()) {
 		    	nodes.add(node.getValue());
+		    }
 		    this.insertReplicationPolicy(guid, policy, nodes);
 		    nodes = new ArrayList<String>();
 		    policy = "preferred";
 		    for (NodeReference node: replicationPolicy.getPreferredMemberNodeList()) {
 		    	nodes.add(node.getValue());
+		    }
 	        this.insertReplicationPolicy(guid, policy, nodes);
+        }
             leinfelder
-            leinfelder
+        // save replica information
         this.insertReplicationStatus(guid, sm.getReplicaList());
             berkley
     /**
-            leinfelder
+     * Lookup a localId given the GUID. If
      * the identifier is not found, throw an exception.
+     *
      * @param guid the global identifier to look up
      * @return String containing the corresponding LocalId
      * @throws McdbDocNotFoundException if the identifier is not found
-            berkley
+     */
-            leinfelder
+    public String getLocalId(String guid) throws McdbDocNotFoundException {
             berkley
       String db_guid = "";
       String docid = "";
       int rev = 0;
-            leinfelder
+      String query = "select guid, docid, rev from " + TYPE_IDENTIFIER + " where guid = ?";
             berkley
       DBConnection dbConn = null;
-            berkley
+      int serialNumber = -1;
-            berkley
+      try {
           // Get a database connection from the pool
           dbConn = DBConnectionPool.getDBConnection("Identifier.getLocalId");
           serialNumber = dbConn.getCheckOutSerialNumber();
           // Execute the insert statement
           PreparedStatement stmt = dbConn.prepareStatement(query);
           stmt.setString(1, guid);
           ResultSet rs = stmt.executeQuery();
           if (rs.next()) {
               db_guid = rs.getString(1);
               docid = rs.getString(2);
               rev = rs.getInt(3);
               assert(db_guid.equals(guid));
           } else {
               throw new McdbDocNotFoundException("Document not found:" + guid);
+          }
           stmt.close();
       } catch (SQLException e) {
           logMetacat.error("Error while looking up the local identifier: "
                   + e.getMessage());
       } finally {
           // Return database connection to the pool
           DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+      }
       return docid + "." + rev;
+    }
-            berkley
+    /**
-            berkley
+     * query the systemmetadata table based on the given parameters
      * @param startTime
      * @param endTime
      * @param objectFormat
      * @param replicaStatus
      * @param start
      * @param count
      * @return ObjectList
      */
     public ObjectList querySystemMetadata(Date startTime, Date endTime,
             ObjectFormat objectFormat, boolean replicaStatus, int start, int count)
+    {
         ObjectList ol = new ObjectList();
         int total = 0;
-            berkley
+        DBConnection dbConn = null;
         int serialNumber = -1;
             berkley
         try
+        {
             String sql = "select guid, date_uploaded, rights_holder, checksum, " +
                 "checksum_algorithm, origin_member_node, authoritive_member_node, " +
-            berkley
+                "date_modified, submitter, object_format, size from systemmetadata";
             berkley
             boolean f1 = false;
             boolean f2 = false;
             boolean f3 = false;
             if(startTime != null)
+            {
-            berkley
+                sql += " where systemmetadata.date_modified > ?";
-            berkley
+                f1 = true;
+            }
             if(endTime != null)
+            {
-            berkley
+                if(!f1)
+                {
                     sql += " where systemmetadata.date_modified < ?";
+                }
                 else
+                {
                     sql += " and systemmetadata.date_modified < ?";
+                }
-            berkley
+                f2 = true;
+            }
             if(objectFormat != null)
+            {
-            berkley
+                if(!f1 && !f2)
+                {
                     sql += " where object_format = ?";
+                }
                 else
+                {
                     sql += " and object_format = ?";
+                }
-            berkley
+                f3 = true;
+            }
             if(replicaStatus)
+            {
                 String currentNodeId = PropertyService.getInstance().getProperty("dataone.memberNodeId");
-            berkley
+                if(!f1 && !f2 && !f3)
+                {
                     sql += " where authoritive_member_node != '" + currentNodeId.trim() + "'";
+                }
                 else
+                {
                     sql += " and authoritive_member_node != '" + currentNodeId.trim() + "'";
+                }
             berkley
-            berkley
+            dbConn = DBConnectionPool.getDBConnection("IdentifierManager.querySystemMetadata");
             serialNumber = dbConn.getCheckOutSerialNumber();
-            berkley
+            PreparedStatement stmt = dbConn.prepareStatement(sql);
             if(f1 && f2 && f3)
+            {
                 stmt.setTimestamp(1, new Timestamp(startTime.getTime()));
                 stmt.setTimestamp(2, new Timestamp(endTime.getTime()));
                 stmt.setString(3, objectFormat.toString());
+            }
             else if(f1 && f2 && !f3)
+            {
                 stmt.setTimestamp(1, new Timestamp(startTime.getTime()));
                 stmt.setTimestamp(2, new Timestamp(endTime.getTime()));
+            }
             else if(f1 && !f2 && f3)
+            {
                 stmt.setTimestamp(1, new Timestamp(startTime.getTime()));
                 stmt.setString(2, objectFormat.toString());
+            }
             else if(f1 && !f2 && !f3)
+            {
                 stmt.setTimestamp(1, new Timestamp(startTime.getTime()));
+            }
             else if(!f1 && f2 && f3)
+            {
                 stmt.setTimestamp(1, new Timestamp(endTime.getTime()));
                 stmt.setString(2, objectFormat.toString());
+            }
             else if(!f1 && !f2 && f3)
+            {
                 stmt.setString(1, objectFormat.toString());
+            }
             else if(!f1 && f2 && !f3)
+            {
                 stmt.setTimestamp(1, new Timestamp(endTime.getTime()));
+            }
-            leinfelder
+            //logMetacat.debug("LISTOBJECTS QUERY: " + stmt.toString());
             berkley
             ResultSet rs = stmt.executeQuery();
-            berkley
+            for(int i=0; i<start; i++)
             berkley
-            berkley
+                if(rs.next())
+                {
                     total++;
+                }
                 else
+                {
                     break;
+                }
             berkley
             berkley
-            berkley
+            int countIndex = 0;
             while(rs.next())
+            {
                 total++;
                 if(countIndex >= count)
+                {
                     break;
+                }
                 String guid = rs.getString(1);
-            leinfelder
+                //logMetacat.debug("query found doc with guid " + guid);
-            berkley
+                //Timestamp dateUploaded = rs.getTimestamp(2);
                 //String rightsHolder = rs.getString(3);
                 String checksum = rs.getString(4);
                 String checksumAlgorithm = rs.getString(5);
                 //String originMemberNode = rs.getString(6);
                 String authoritiveMemberNode = rs.getString(7);
                 Timestamp dateModified = rs.getTimestamp(8);
                 //String submitter = rs.getString(9);
                 String format = rs.getString(10);
-            berkley
+                String sz = rs.getString(11);
                 long size = 0;
                 if(sz != null && !sz.trim().equals(""))
+                {
                     size = new Long(rs.getString(11)).longValue();
+                }
             berkley
                 ObjectInfo oi = new ObjectInfo();
                 Identifier id = new Identifier();
                 id.setValue(guid);
                 oi.setIdentifier(id);
                 oi.setDateSysMetadataModified(new Date(dateModified.getTime()));
                 Checksum cs = new Checksum();
                 cs.setValue(checksum);
-            berkley
+                cs.setAlgorithm(ChecksumAlgorithm.valueOf(checksumAlgorithm));
-            berkley
+                //cs.setAlgorithm(ChecksumAlgorithm.convert(checksumAlgorithm));
-            berkley
+                oi.setChecksum(cs);
-            cjones
+                ObjectFormat oFormat = ObjectFormat.convert(format);
-            berkley
+                if(oFormat != null)
+                {
                     oi.setObjectFormat(oFormat);
+                }
-            berkley
+                else
                 { //if there is no object format, just default to text/plain
-            cjones
+                    oi.setObjectFormat(ObjectFormat.OCTET_STREAM);
             berkley
             berkley
                 oi.setSize(size);
             berkley
                 ol.addObjectInfo(oi);
                 countIndex++;
+            }
             while(rs.next())
             { //expend the resultset to get the total count of possible rows
                 total++;
+            }
+        }
         catch(Exception e)
+        {
            e.printStackTrace();
-            leinfelder
+           logMetacat.error("Error querying system metadata: " + e.getMessage());
             berkley
-            berkley
+        finally
+        {
             // Return database connection to the pool
             DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+        }
             berkley
         ol.setStart(start);
-            berkley
+        ol.setCount(ol.sizeObjectInfoList());
-            berkley
+        ol.setTotal(total);
         return ol;
+    }
     /**
-            leinfelder
+     * create a mapping in the identifier table
-            berkley
+     * @param guid
      * @param localId
      */
-            leinfelder
+    public void createMapping(String guid, String localId)
             berkley
             berkley
         int serialNumber = -1;
-            berkley
+        DBConnection dbConn = null;
         try {
             // Parse the localId into scope and rev parts
             AccessionNumber acc = new AccessionNumber(localId, "NOACTION");
             String docid = acc.getDocid();
-            berkley
+            int rev = 1;
-            leinfelder
+            if (acc.getRev() != null) {
-            berkley
+              rev = (new Integer(acc.getRev()).intValue());
+            }
             berkley
             // Get a database connection from the pool
-            leinfelder
+            dbConn = DBConnectionPool.getDBConnection("IdentifierManager.createMapping");
-            berkley
+            serialNumber = dbConn.getCheckOutSerialNumber();
             // Execute the insert statement
-            leinfelder
+            String query = "insert into " + TYPE_IDENTIFIER + " (guid, docid, rev) values (?, ?, ?)";
-            berkley
+            PreparedStatement stmt = dbConn.prepareStatement(query);
             stmt.setString(1, guid);
             stmt.setString(2, docid);
             stmt.setInt(3, rev);
-            leinfelder
+            logMetacat.debug("mapping query: " + stmt.toString());
-            berkley
+            int rows = stmt.executeUpdate();
             stmt.close();
         } catch (SQLException e) {
-            berkley
+            e.printStackTrace();
-            leinfelder
+            logMetacat.error("createGenericMapping: SQL error while creating a mapping to the " + TYPE_IDENTIFIER + " identifier: "
-            berkley
+                    + e.getMessage());
         } catch (NumberFormatException e) {
-            berkley
+            e.printStackTrace();
-            leinfelder
+            logMetacat.error("createGenericMapping: NumberFormat error while creating a mapping to the " + TYPE_IDENTIFIER + " identifier: "
-            berkley
+                    + e.getMessage());
         } catch (AccessionNumberException e) {
-            berkley
+            e.printStackTrace();
-            leinfelder
+            logMetacat.error("createGenericMapping: AccessionNumber error while creating a mapping to the " + TYPE_IDENTIFIER + " identifier: "
-            berkley
+                    + e.getMessage());
         } finally {
             // Return database connection to the pool
             DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+        }
+    }
             leinfelder
     /**
      * create the systemmetadata record
      * @param guid
      */
     public void insertSystemMetadata(String guid)
+    {
         int serialNumber = -1;
         DBConnection dbConn = null;
         try {
             // Get a database connection from the pool
             dbConn = DBConnectionPool.getDBConnection("IdentifierManager.insertSystemMetadata");
             serialNumber = dbConn.getCheckOutSerialNumber();
             // Execute the insert statement
             String query = "insert into " + TYPE_SYSTEM_METADATA + " (guid) values (?)";
             PreparedStatement stmt = dbConn.prepareStatement(query);
             stmt.setString(1, guid);
             logMetacat.debug("system metadata query: " + stmt.toString());
             int rows = stmt.executeUpdate();
             stmt.close();
         } catch (Exception e) {
             e.printStackTrace();
             logMetacat.error("Error while creating " + TYPE_SYSTEM_METADATA + " record: "
                     + e.getMessage());
         } finally {
             // Return database connection to the pool
             DBConnectionPool.returnDBConnection(dbConn, serialNumber);
+        }
+    }
             jones

Project

General

Profile

Metacat