Metacat

  /**

   * To a given docid, found a dataset docid which conatains the the given doicd

   * This will be done by searching xml_relation table

   * If couldn't find, null will be return

   * @param givenDocId, the docid which we want to find

   */

  public static String findDataSetDocIdForGivenDocument(String givenDocId)

  {

    // Prepared statement for sql

    PreparedStatement pStmt = null;

    // Result set

    ResultSet resultSet = null;

    // String to store the data set docid

    String dataSetDocId = null;

    // DBConnection will be checkout

    DBConnection dbConn = null;

    int serialNumber = -1;

    // String to store the sql command

    String sqlCommand = null;

    try

    {

      // Checkout DBConnection from pool

      dbConn=DBConnectionPool.

                  getDBConnection("DBUtil.findDataSetDocIdForGivenDocument");

      serialNumber=dbConn.getCheckOutSerialNumber();

      // Sql command to chose a docid from xm_relation table

      sqlCommand = "select docid from xml_relation where object like ? or " 

                                                    + "subject like ?";

      // Prepared statement

      pStmt = dbConn.prepareStatement(sqlCommand);

      // Bind variable

      pStmt.setString(1, givenDocId);

      pStmt.setString(2, givenDocId);

      // Excute prepared statement

      pStmt.execute();

      // Get result set

      resultSet = pStmt.getResultSet();

      // There has record

      if (resultSet.next())

      {

        // Put the docid into dataSetDocid

        dataSetDocId = resultSet.getString(1);

        return dataSetDocId;

      }//if

      else

      {

        // No record in xml_relation table for given doicd, null returned

        return dataSetDocId;

      }//else

    }//try

    catch ( SQLException e)

    {

      // Print out excepition

      MetaCatUtil.debugMessage("Error in DBUil.findDataSEtDocIdForGivenDocument"

                                +e.getMessage(), 30);

      // return null

      return dataSetDocId;

    }//catch

    finally

    {

      try

      {

        // Close result set

        resultSet.close();

        // Close preparedStatement

        pStmt.close();

      }//try

      catch ( SQLException e)

      {

        // Print out excepition

        MetaCatUtil.debugMessage("Error in DBUil.findDataSetDocIdForGivenDoc"

                                + e.getMessage(), 30);

      }//catch

      finally

      {

        // Return DBConnection to the pool

        DBConnectionPool.returnDBConnection(dbConn, serialNumber);

      }//finally

    }//finally

  }//findDataSetDocIdForGivenDocument

  /**

   * Method to get current revision and doctype for a given docid

   * The output will look like "rev;doctype"

   * @param givenDocId, the docid which we want 

   */

  public String getCurrentRevisionAndDocTypeForGivenDocument(String givenDocId)

                                                 throws SQLException

  {

    // DBConection for JDBC

    DBConnection dbConn = null;

    int serialNumber = -1;

    // Prepared Statement

    PreparedStatement pstmt = null;

    // String to store a docid without rev

    String docIdWithoutRevision = null;

    // SQL comand

    String sqlCommand = null;

    // Resulst set

    ResultSet rs = null;

    // String to store the revision

    String revision = null;

    // String to store the doctype

    String docType = null;

    // Get docid without rev

    docIdWithoutRevision = MetaCatUtil.getDocIdFromString(givenDocId);

    // SQL comand is:

    sqlCommand = "select rev, doctype from xml_documents where docid like ?";

    try

    {

      // Check out the connection

      dbConn=DBConnectionPool.

         getDBConnection("DBUtil.getCurrentRevisionAndDocTypeForGivenDocument");

      serialNumber=dbConn.getCheckOutSerialNumber();

      // Prepare the sql command

      pstmt = dbConn.prepareStatement(sqlCommand);

      // Bin vairable

      pstmt.setString(1, docIdWithoutRevision);

      // Excute the prepared statement

      pstmt.execute();

      // Get result set

      rs = pstmt.getResultSet();

      // If there is some record

      if (rs.next())

      {

        revision = rs.getString(1);

        docType = rs.getString(2);

      }//if

      else

      {

        // No record, throw a exception

        throw new 

              SQLException("There is not record for given docid:"+givenDocId);

      }//else

    }

    finally

    {

      try

      {

        // Close result set

        rs.close();

        // Close preparedStatement

        pstmt.close();

      }//try

      catch ( SQLException e)

      {

        // Print out excepition

        MetaCatUtil.debugMessage("Error in DBUil.getCurrentRevisionAndDocType"

                                + e.getMessage(), 30);

      }//catch

      finally

      {

        // Return DBConnection to the pool

        DBConnectionPool.returnDBConnection(dbConn, serialNumber);

      }//finally

    }

    return revision+";"+docType;

  }//getCurrentRevisionAndDocTypeForGivenDocument