/**
   * Returns the Code Object for the given code id
   *
   * @param PCSession session, the PCSession object for the database to use.
   * @param String sCodeID, the code id for the particular code object
   * @return a Code object for the given code id
   * @exception java.sql.SQLException
   */
  public Code getCode(PCSession session, String sCodeID) throws SQLException {

    DBConnection dbcon = getDatabaseManager().requestConnection(session.getModelName());

    Code code = DBCode.getCode(dbcon, sCodeID);

    getDatabaseManager().releaseConnection(session.getModelName(), dbcon);

    return code;
  }