Exemple #1
0
 /**
  * Creates a prepared statement with the specified result set type, concurrency, and holdability.
  *
  * @return the prepared statement
  * @throws SQLException if the connection is closed or the result set type, concurrency, or
  *     holdability are not supported
  */
 public PreparedStatement prepareStatement(
     String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
     throws SQLException {
   try {
     int id = getNextId(TraceObject.PREPARED_STATEMENT);
     if (isDebugEnabled()) {
       debugCodeAssign(
           "PreparedStatement",
           TraceObject.PREPARED_STATEMENT,
           id,
           "prepareStatement("
               + quote(sql)
               + ", "
               + resultSetType
               + ", "
               + resultSetConcurrency
               + ", "
               + resultSetHoldability
               + ")");
     }
     checkTypeConcurrency(resultSetType, resultSetConcurrency);
     checkHoldability(resultSetHoldability);
     checkClosed();
     sql = translateSQL(sql);
     return new JdbcPreparedStatement(this, sql, id, resultSetType, resultSetConcurrency, false);
   } catch (Exception e) {
     throw logAndConvert(e);
   }
 }
Exemple #2
0
 /**
  * Creates a statement with the specified result set type, concurrency, and holdability.
  *
  * @return the statement
  * @throws SQLException if the connection is closed or the result set type, concurrency, or
  *     holdability are not supported
  */
 public Statement createStatement(
     int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException {
   try {
     int id = getNextId(TraceObject.STATEMENT);
     if (isDebugEnabled()) {
       debugCodeAssign(
           "Statement",
           TraceObject.STATEMENT,
           id,
           "createStatement("
               + resultSetType
               + ", "
               + resultSetConcurrency
               + ", "
               + resultSetHoldability
               + ")");
     }
     checkTypeConcurrency(resultSetType, resultSetConcurrency);
     checkHoldability(resultSetHoldability);
     checkClosed();
     return new JdbcStatement(this, id, resultSetType, resultSetConcurrency, false);
   } catch (Exception e) {
     throw logAndConvert(e);
   }
 }
Exemple #3
0
 /**
  * Changes the current result set holdability.
  *
  * @param holdability ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT;
  * @throws SQLException if the connection is closed or the holdability is not supported
  */
 public void setHoldability(int holdability) throws SQLException {
   try {
     debugCodeCall("setHoldability", holdability);
     checkClosed();
     checkHoldability(holdability);
     this.holdability = holdability;
   } catch (Exception e) {
     throw logAndConvert(e);
   }
 }