Metacat

  /**

   * 

   * @return true if the Access Control for this file already exists in the DB

   * @throws SQLException

   */

  public boolean accessControlExists() throws SQLException 

  {

	  boolean exists = false;

    PreparedStatement pstmt = null;

    DBConnection conn = null;

    int serialNumber = -1;

    try

    {

      //check out DBConnection

      conn=DBConnectionPool.getDBConnection

                               ("AccessControlForSingleFiel.accessControlExists");

      serialNumber=conn.getCheckOutSerialNumber();

      pstmt = conn.prepareStatement(

              "SELECT * FROM xml_access " + 

              "WHERE docid = ? " +

              "AND principal_name = ? " +

              "AND permission = ? " +

              "AND perm_type = ? " +

              "AND perm_order =? ");

      // Bind the values to the query

      pstmt.setString(1, docId);

      pstmt.setString(2, principal);

      pstmt.setInt(3, permission);

      pstmt.setString(4, permType);

      pstmt.setString(5, permOrder);

      pstmt.execute();

      ResultSet rs = pstmt.getResultSet();

      exists = rs.next();

    }//try

    catch (SQLException e)

    {

      logMetacat.error("Error in AccessControlForSingleFile.accessControlExists: "

                               + e.getMessage());

      throw e;

    }

    finally

    {

      try

      {

        pstmt.close();

      }

      finally

      {

        DBConnectionPool.returnDBConnection(conn, serialNumber);

      }

    }

    return exists;

  }