Metacat

        ph("testGetGUID");

        ph("testGetAllLocalIds");

                System.out.println(l.get(i));

        ph("testGetInstance");

        ph("testGetLocalId");

        ph("testGetLocalIdNotFound");

        ph("testIdentifierExists");

       ph("testCreateMapping");

        ph("testCreateSystemMetadataMapping");

        System.out.println("inserting doc: " + emldoc);

    private void ph(String s)

    {

        System.out.println("*********************** " + s + " ****************************");

    }

   rev    NUMBER(8),          -- the revision part of the local identifier

   date_uploaded DATE, -- the date/time the document was first submitted

   rights_holder VARCHAR2(250), --the user who has rights to the document, usually the first persons to upload it

   checksum VARCHAR2(512), --the checksum of the doc using the given algorithm (see below)

   checksum_algorithm VARCHAR2(250), --the algorithm used to calculate the checksum

   origin_member_node VARCHAR2(250), --the member node where the document was first uploaded

   authoritive_member_node VARCHAR2(250), --the member node that currently controls the document

   date_modified DATE, -- the last date/time that the file was changed

   submitter VARCHAR2(256) -- the user who originally submitted the doc

   date_uploaded TIMESTAMP, -- the date/time the document was first submitted

   rights_holder VARCHAR(250), --the user who has rights to the document, usually the first persons to upload it

   checksum VARCHAR(512), --the checksum of the doc using the given algorithm (see below)

   checksum_algorithm VARCHAR(250), --the algorithm used to calculate the checksum

   origin_member_node VARCHAR(250), --the member node where the document was first uploaded

   authoritive_member_node VARCHAR(250), --the member node that currently controls the document

   date_modified TIMESTAMP, -- the last date/time that the file was changed

   submitter VARCHAR(256), -- the user who originally submitted the doc

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

   date_uploaded TIMESTAMP, -- the date/time the document was first submitted

   rights_holder VARCHAR(250), --the user who has rights to the document, usually the first persons to upload it

   checksum VARCHAR(512), --the checksum of the doc using the given algorithm (see below)

   checksum_algorithm VARCHAR(250), --the algorithm used to calculate the checksum

   origin_member_node VARCHAR(250), --the member node where the document was first uploaded

   authoritive_member_node VARCHAR(250), --the member node that currently controls the document

   date_modified TIMESTAMP, -- the last date/time that the file was changed

   submitter VARCHAR(256), -- the user who originally submitted the doc

   rev    NUMBER(8),          -- the revision part of the local identifier

   date_uploaded DATE, -- the date/time the document was first submitted

   rights_holder VARCHAR2(250), --the user who has rights to the document, usually the first persons to upload it

   checksum VARCHAR2(512), --the checksum of the doc using the given algorithm (see below)

   checksum_algorithm VARCHAR2(250), --the algorithm used to calculate the checksum

   origin_member_node VARCHAR2(250), --the member node where the document was first uploaded

   authoritive_member_node VARCHAR2(250), --the member node that currently controls the document

   date_modified DATE, -- the last date/time that the file was changed

   submitter VARCHAR2(256) -- the user who originally submitted the doc

                sysmeta, sysMetaGuid.getValue());

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: "