Metacat

    /**

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

        }

    }