package uk.ac.ebi.intenz.mapper;

 import java.sql.CallableStatement;

 import java.sql.Connection;

 import java.sql.SQLException;

 import java.sql.Types;

 /**

  * Provides methods for access to procedures not related to a specific package.

  *

  * @author Michael Darsow

  * @version $Revision: 1.2 $ $Date: 2008/01/28 12:33:07 $

  */

 public class CommonProceduresMapper {

   public CommonProceduresMapper() {

   }

   private String callCloneStatement() {

     return "{CALL p_clone_enzyme(?, ?, ?, ?)}";

   }

   /**

    * Creates a clone of an enzyme by using its enzyme ID.

    *

    * @param enzymeId The enzyme's ID.

    * @param con      The connection.

    * @throws SQLException

    */

   public Long createClone(Long enzymeId, Connection con) throws SQLException {

     int newEnzymeId = 0;

     CallableStatement cStmt = null;

     try {

       cStmt = con.prepareCall(callCloneStatement());

       cStmt.setString(1, "" + enzymeId);

       cStmt.registerOutParameter(2, Types.VARCHAR);

       cStmt.setString(3, "OK");

       cStmt.setString(4, "Y");

       cStmt.execute();

       newEnzymeId = Integer.parseInt(cStmt.getString(2));

     } finally {

       if (cStmt != null) cStmt.close();

     }

     return new Long(newEnzymeId);

   }

 }