Metacat

import org.dataone.service.types.SystemMetadata;

import edu.ucsb.nceas.metacat.properties.PropertyService;

    public static String DATAONE_SM_DOCTYPE;

        try

        {

            DATAONE_SM_DOCTYPE = PropertyService.getProperty("crudService.listObjects.ReturnDoctype");

        }

        catch(Exception e)

        {

            throw new RuntimeException("Error getting System Metadata doctype from " + 

                    "the properties file.  Please make sure crudService.listObjects.ReturnDoctype " +

                    "exists in metacat.properties.");

        }

     * creates a mapping for a system metadata document, but DOES NOT add any

     * of the extra system metadata information to the table.  You must call 

     * insertAdditionalSystemMetadataFields to complete the entry

     * 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

     */

    public void createSystemMetadataMapping(SystemMetadata sysmeta, String localId)

    {

        createGenericMapping(sysmeta.getIdentifier().getValue(), localId, TYPE_SYSTEM_METADATA);

        insertAdditionalSystemMetadataFields(sysmeta);

    }

    /**

    public void insertAdditionalSystemMetadataFields(long dateUploaded, String rightsHolder,

            String checksum, String checksumAlgorithm, String originMemberNode,

            String authoritativeMemberNode, long modifiedDate, String submitter, String guid)

    {

        DBConnection dbConn = null;

        int serialNumber = -1;

        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, " +

                "origin_member_node, authoritive_member_node, date_modified, submitter) " +

                "= (?, ?, ?, ?, ?, ?, ?, ?) where guid = ?";

            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);

            //where clause

            stmt.setString(9, guid);

            System.out.println("stmt: " + stmt.toString());

            //execute

            int rows = stmt.executeUpdate();

            stmt.close();

        } catch (SQLException e) {

            e.printStackTrace();

            logMetacat.error("SQL error while creating a mapping to the system metadata identifier: " 

                    + e.getMessage());

        } catch (NumberFormatException e) {

            e.printStackTrace();

            logMetacat.error("NumberFormat error while creating a mapping to the system metadata identifier: " 

                    + e.getMessage());

        } finally {

            // Return database connection to the pool

            DBConnectionPool.returnDBConnection(dbConn, serialNumber);

        }

    }

     * Insert the system metadata fields into the db

     * @param sm

     */

    public void insertAdditionalSystemMetadataFields(SystemMetadata sm)

    {

        insertAdditionalSystemMetadataFields(

                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(), 

                sm.getIdentifier().getValue());

    }

    /**

            System.out.println("generic mapping query: " + stmt.toString());

            logMetacat.warn("SQL error while creating a mapping to the system metadata identifier: "