/**
* 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);
}
}
/**
* 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);
}
}
/**
* 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);
}
}