Metacat

 * Table used to store all document identifiers for system metadata objects

 * similar restraints to identifier.  Cannot use identifier table for this 

 * purpose because then you have to worry about whether you insert the

 * data first or the systemMetadata first.

 */

CREATE TABLE systemMetadata (

   guid   text,          -- the globally unique string identifier

   docid  VARCHAR(250),	 -- the local document id #

   rev    INT8,          -- the revision part of the local identifier

   CONSTRAINT systemMetadata_pk PRIMARY KEY (guid)

);

/*

      //hack...fix this

    //change crud service into a singleton.  dont pass servlet data structures here

        String localId = insertDocument(xml, sysMetaGuid, sessionData);

        //insert the system metadata doc id into the identifiers table to 

        //link it to the data or metadata document

        IdentifierManager.getInstance().createSystemMetadataMapping(sysMetaGuid.getValue(), localId);

    /**

     * insert a document, return the id of the document that was inserted

     */

    private String insertDocument(String xml, Identifier guid, SessionData sessionData) 

        logMetacat.debug("Finsished inserting xml document with id " + localId);

        return localId;

    /**

     * insert a system metadata id for a local id

     * 

     * @param guid the id to insert

     * @param localId the systemMetadata object to get the local id for

     */

    public void createSystemMetadataMapping(String guid, String localId)

    {

      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 = (new Integer(acc.getRev()).intValue());

            // Get a database connection from the pool

            dbConn = 

                DBConnectionPool.getDBConnection("Identifier.createMapping");

            serialNumber = dbConn.getCheckOutSerialNumber();

            // Execute the insert statement

            String query = "insert into systemMetadata (guid, docid, rev) values (?, ?, ?)";            

            PreparedStatement stmt = dbConn.prepareStatement(query);

            stmt.setString(1, guid);

            stmt.setString(2, docid);

            stmt.setInt(3, rev);

            int rows = stmt.executeUpdate();

            stmt.close();

        } catch (SQLException e) {

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

                    + e.getMessage());

        } catch (NumberFormatException e) {

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

                    + e.getMessage());

        } catch (AccessionNumberException e) {

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

                    + e.getMessage());

        } finally {

            // Return database connection to the pool

            DBConnectionPool.returnDBConnection(dbConn, serialNumber);

        }

    }