Class ConnectionWrapper
- All Implemented Interfaces:
ManagedResource
,AutoCloseable
,Connection
,Wrapper
The contract with JDBC says that result sets must be closed before statements and statements must be closed before connections but java does not enforce this contract. It is quite possible to close a connection while statements and result sets are still open. While some database drivers handle this condition nicely, others will start failing in undefined ways when this happens.
This wrapper class is a solution to this problem. If the connection is only accessed through the wrapper then the wrapper will ensure that everything is closed in the correct order. It will also ensure that the various jdbc objects (connections, statements, result sets and metadata) cannot be used after they are closed.
This class was created for the JDBCResourceFactory
but can be used
by itself.
- Version:
- $Revision: 1.4 $
-
Field Summary
FieldsModifier and TypeFieldDescriptionprivate Connection
private boolean
private final List
private final List
private String
Fields inherited from interface java.sql.Connection
TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionvoid
private void
Check to see if the connection is still open.void
Clears all warnings reported for thisConnection
object.void
close()
Releases a Connection's database and JDBC resources immediately instead of waiting for them to be automatically released.void
Close any open DatabaseMetaData objectsvoid
Close any open statementsvoid
commit()
Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection.createArrayOf
(String typeName, Object[] elements) Creates aStatement
object for sending SQL statements to the database.createStatement
(int resultSetType, int resultSetConcurrency) Creates aStatement
object that will generateResultSet
objects with the given type and concurrency.createStatement
(int resultSetType, int resultSetConcurrency, int resultSetHoldability) Creates aStatement
object that will generateResultSet
objects with the given type, concurrency, and holdability.createStruct
(String typeName, Object[] attributes) boolean
Gets the current auto-commit state.Returns the Connection's current catalog name.getClientInfo
(String name) final Connection
Return the wrapped connectionint
Retrieves the current holdability ofResultSet
objects created using thisConnection
object.Gets the metadata regarding this connection's database.int
int
Return the number of statements that are currently open.final String
Return the name of the factory that allocated this connectionint
Gets this Connection's current transaction isolation level.Gets the type map object associated with this connection.Returns the first warning reported by calls on this Connection.boolean
isClosed()
Tests to see if a Connection is closed.boolean
Tests to see if the connection is in read-only mode.boolean
isValid
(int timeout) boolean
isWrapperFor
(Class<?> iface) Converts the given SQL statement into the system's native SQL grammar.prepareCall
(String sql) Creates aCallableStatement
object for calling database stored procedures.prepareCall
(String sql, int resultSetType, int resultSetConcurrency) Creates aCallableStatement
object that will generateResultSet
objects with the given type and concurrency.prepareCall
(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) Creates aCallableStatement
object that will generateResultSet
objects with the given type and concurrency.prepareStatement
(String sql) Creates aPreparedStatement
object for sending parameterized SQL statements to the database.prepareStatement
(String sql, int autoGeneratedKeys) Creates a defaultPreparedStatement
object that has the capability to retrieve auto-generated keys.prepareStatement
(String sql, int[] columnIndexes) Creates a defaultPreparedStatement
object capable of returning the auto-generated keys designated by the given array.prepareStatement
(String sql, int resultSetType, int resultSetConcurrency) Creates aPreparedStatement
object that will generateResultSet
objects with the given type and concurrency.prepareStatement
(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) Creates aPreparedStatement
object that will generateResultSet
objects with the given type, concurrency, and holdability.prepareStatement
(String sql, String[] columnNames) Creates a defaultPreparedStatement
object capable of returning the auto-generated keys designated by the given array.void
releaseSavepoint
(Savepoint savepoint) Removes the givenSavepoint
object from the current transaction.void
rollback()
Drops all changes made since the previous commit/rollback and releases any database locks currently held by this Connection.void
Undoes all changes made after the givenSavepoint
object was set.void
setAutoCommit
(boolean autoCommit) Sets this connection's auto-commit mode.void
setCatalog
(String catalog) Sets a catalog name in order to select a subspace of this Connection's database in which to work.void
setClientInfo
(String name, String value) void
setClientInfo
(Properties properties) void
setHoldability
(int holdability) Changes the holdability ofResultSet
objects created using thisConnection
object to the given holdability.void
setNetworkTimeout
(Executor executor, int timeout) void
setReadOnly
(boolean readOnly) Puts this connection in read-only mode as a hint to enable database optimizations.final void
setResourceFactoryName
(String name) Set the name of the factory that allocated this connectionCreates an unnamed savepoint in the current transaction and returns the newSavepoint
object that represents it.setSavepoint
(String name) Creates a savepoint with the given name in the current transaction and returns the newSavepoint
object that represents it.void
void
setTransactionIsolation
(int level) Attempts to change the transaction isolation level to the one given.void
setTypeMap
(Map map) Installs the given type map as the type map for this connection.<T> T
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
Methods inherited from interface java.sql.Connection
beginRequest, endRequest, setShardingKey, setShardingKey, setShardingKeyIfValid, setShardingKeyIfValid
-
Field Details
-
delegate_
-
isOpen_
private boolean isOpen_ -
resourceFactoryName_
-
openStatements_
-
openDatabaseMetaData_
-
-
Constructor Details
-
ConnectionWrapper
Create a new connection wrapper- Parameters:
connection
- The connection that we are wrapping
-
-
Method Details
-
setResourceFactoryName
Set the name of the factory that allocated this connection- Specified by:
setResourceFactoryName
in interfaceManagedResource
- Parameters:
name
- The name of the factory
-
setAutoCommit
Sets this connection's auto-commit mode. If a connection is in auto-commit mode, then all its SQL statements will be executed and committed as individual transactions. Otherwise, its SQL statements are grouped into transactions that are terminated by a call to either the methodcommit
or the methodrollback
. By default, new connections are in auto-commit mode.The commit occurs when the statement completes or the next execute occurs, whichever comes first. In the case of statements returning a ResultSet, the statement completes when the last row of the ResultSet has been retrieved or the ResultSet has been closed. In advanced cases, a single statement may return multiple results as well as output parameter values. In these cases the commit occurs when all results and output parameter values have been retrieved.
- Specified by:
setAutoCommit
in interfaceConnection
- Parameters:
autoCommit
- true enables auto-commit; false disables auto-commit.- Throws:
SQLException
- if a database access error occurs
-
setReadOnly
Puts this connection in read-only mode as a hint to enable database optimizations.Note: This method cannot be called while in the middle of a transaction.
- Specified by:
setReadOnly
in interfaceConnection
- Parameters:
readOnly
- true enables read-only mode; false disables read-only mode.- Throws:
SQLException
- if a database access error occurs
-
setCatalog
Sets a catalog name in order to select a subspace of this Connection's database in which to work. If the driver does not support catalogs, it will silently ignore this request.- Specified by:
setCatalog
in interfaceConnection
- Parameters:
catalog
- The catalog name- Throws:
SQLException
- if a database access error occurs
-
setTransactionIsolation
Attempts to change the transaction isolation level to the one given. The constants defined in the interfaceConnection
are the possible transaction isolation levels.Note: This method cannot be called while in the middle of a transaction.
- Specified by:
setTransactionIsolation
in interfaceConnection
- Parameters:
level
- one of the TRANSACTION_* isolation values with the exception of TRANSACTION_NONE; some databases may not support other values- Throws:
SQLException
- if a database access error occurs
-
setTypeMap
Installs the given type map as the type map for this connection. The type map will be used for the custom mapping of SQL structured types and distinct types.- Specified by:
setTypeMap
in interfaceConnection
- Parameters:
map
- thejava.util.Map
object to install as the replacement for thisConnection
object's default type map- Throws:
SQLException
- If a sql error occurs- Since:
- 1.2
-
getResourceFactoryName
Return the name of the factory that allocated this connection- Specified by:
getResourceFactoryName
in interfaceManagedResource
- Returns:
- The name of the factory
-
getDelegate
Return the wrapped connection- Returns:
- The wrapped connection
-
getAutoCommit
Gets the current auto-commit state.- Specified by:
getAutoCommit
in interfaceConnection
- Returns:
- the current state of auto-commit mode
- Throws:
SQLException
- if a database access error occurs- See Also:
-
isClosed
Tests to see if a Connection is closed.- Specified by:
isClosed
in interfaceConnection
- Returns:
- true if the connection is closed; false if it's still open
- Throws:
SQLException
- if a database access error occurs
-
getMetaData
Gets the metadata regarding this connection's database. A Connection's database is able to provide information describing its tables, its supported SQL grammar, its stored procedures, the capabilities of this connection, and so on. This information is made available through a DatabaseMetaData object.- Specified by:
getMetaData
in interfaceConnection
- Returns:
- a DatabaseMetaData object for this Connection
- Throws:
SQLException
- if a database access error occurs
-
isReadOnly
Tests to see if the connection is in read-only mode.- Specified by:
isReadOnly
in interfaceConnection
- Returns:
- true if connection is read-only and false otherwise
- Throws:
SQLException
- if a database access error occurs
-
getCatalog
Returns the Connection's current catalog name.- Specified by:
getCatalog
in interfaceConnection
- Returns:
- the current catalog name or null
- Throws:
SQLException
- if a database access error occurs
-
getTransactionIsolation
Gets this Connection's current transaction isolation level.- Specified by:
getTransactionIsolation
in interfaceConnection
- Returns:
- the current TRANSACTION_* mode value
- Throws:
SQLException
- if a database access error occurs
-
getWarnings
Returns the first warning reported by calls on this Connection.Note: Subsequent warnings will be chained to this SQLWarning.
- Specified by:
getWarnings
in interfaceConnection
- Returns:
- the first SQLWarning or null
- Throws:
SQLException
- if a database access error occurs
-
getTypeMap
Gets the type map object associated with this connection. Unless the application has added an entry to the type map, the map returned will be empty.- Specified by:
getTypeMap
in interfaceConnection
- Returns:
- the
java.util.Map
object associated with thisConnection
object - Throws:
SQLException
- If a sql error occurs- Since:
- 1.2
-
createStatement
Creates aStatement
object for sending SQL statements to the database. SQL statements without parameters are normally executed using Statement objects. If the same SQL statement is executed many times, it is more efficient to use aPreparedStatement
object.Result sets created using the returned
Statement
object will by default have forward-only type and read-only concurrency.- Specified by:
createStatement
in interfaceConnection
- Returns:
- a new Statement object
- Throws:
SQLException
- if a database access error occurs
-
prepareStatement
Creates aPreparedStatement
object for sending parameterized SQL statements to the database. A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.Note: This method is optimized for handling parametric SQL statements that benefit from precompilation. If the driver supports precompilation, the method
prepareStatement
will send the statement to the database for precompilation. Some drivers may not support precompilation. In this case, the statement may not be sent to the database until thePreparedStatement
is executed. This has no direct effect on users; however, it does affect which method throws certain SQLExceptions.Result sets created using the returned PreparedStatement will have forward-only type and read-only concurrency, by default.
- Specified by:
prepareStatement
in interfaceConnection
- Parameters:
sql
- a SQL statement that may contain one or more '?' IN parameter placeholders- Returns:
- a new PreparedStatement object containing the pre-compiled statement
- Throws:
SQLException
- if a database access error occurs
-
prepareCall
Creates aCallableStatement
object for calling database stored procedures. TheCallableStatement
object provides methods for setting up its IN and OUT parameters, and methods for executing the call to a stored procedure.Note: This method is optimized for handling stored procedure call statements. Some drivers may send the call statement to the database when the method
prepareCall
is done; others may wait until theCallableStatement
object is executed. This has no direct effect on users; however, it does affect which method throws certain SQLExceptions. Result sets created using the returned CallableStatement will have forward-only type and read-only concurrency, by default.- Specified by:
prepareCall
in interfaceConnection
- Parameters:
sql
- a SQL statement that may contain one or more '?' parameter placeholders. Typically this statement is a JDBC function call escape string.- Returns:
- a new CallableStatement object containing the pre-compiled SQL statement
- Throws:
SQLException
- if a database access error occurs
-
nativeSQL
Converts the given SQL statement into the system's native SQL grammar. A driver may convert the JDBC sql grammar into its system's native SQL grammar prior to sending it; this method returns the native form of the statement that the driver would have sent.- Specified by:
nativeSQL
in interfaceConnection
- Parameters:
sql
- a SQL statement that may contain one or more '?' parameter placeholders- Returns:
- the native form of this statement
- Throws:
SQLException
- if a database access error occurs
-
commit
Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection. This method should be used only when auto-commit mode has been disabled.- Specified by:
commit
in interfaceConnection
- Throws:
SQLException
- if a database access error occurs- See Also:
-
rollback
Drops all changes made since the previous commit/rollback and releases any database locks currently held by this Connection. This method should be used only when auto- commit has been disabled.- Specified by:
rollback
in interfaceConnection
- Throws:
SQLException
- if a database access error occurs- See Also:
-
close
Releases a Connection's database and JDBC resources immediately instead of waiting for them to be automatically released.Note: A Connection is automatically closed when it is garbage collected. Certain fatal errors also result in a closed Connection.
- Specified by:
close
in interfaceAutoCloseable
- Specified by:
close
in interfaceConnection
- Throws:
SQLException
- if a database access error occurs
-
closeAnyOpenStatements
Close any open statements- Throws:
SQLException
- If an error occurs
-
closeAnyOpenMetaDatas
Close any open DatabaseMetaData objects- Throws:
SQLException
- If an error occurs
-
clearWarnings
Clears all warnings reported for thisConnection
object. After a call to this method, the methodgetWarnings
returns null until a new warning is reported for this Connection.- Specified by:
clearWarnings
in interfaceConnection
- Throws:
SQLException
- if a database access error occurs
-
createStatement
Creates aStatement
object that will generateResultSet
objects with the given type and concurrency. This method is the same as thecreateStatement
method above, but it allows the default result set type and result set concurrency type to be overridden.- Specified by:
createStatement
in interfaceConnection
- Parameters:
resultSetType
- a result set type; see ResultSet.TYPE_XXXresultSetConcurrency
- a concurrency type; see ResultSet.CONCUR_XXX- Returns:
- a new Statement object
- Throws:
SQLException
- if a database access error occurs- Since:
- 1.2
-
prepareStatement
public PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency) throws SQLException Creates aPreparedStatement
object that will generateResultSet
objects with the given type and concurrency. This method is the same as theprepareStatement
method above, but it allows the default result set type and result set concurrency type to be overridden.- Specified by:
prepareStatement
in interfaceConnection
- Parameters:
sql
- a SQL statement that may contain one or more '?' parameter placeholders. Typically this statement is a JDBC function call escape string.resultSetType
- a result set type; see ResultSet.TYPE_XXXresultSetConcurrency
- a concurrency type; see ResultSet.CONCUR_XXX- Returns:
- a new PreparedStatement object containing the pre-compiled SQL statement
- Throws:
SQLException
- if a database access error occurs- Since:
- 1.2
-
prepareCall
public CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency) throws SQLException Creates aCallableStatement
object that will generateResultSet
objects with the given type and concurrency. This method is the same as theprepareCall
method above, but it allows the default result set type and result set concurrency type to be overridden.- Specified by:
prepareCall
in interfaceConnection
- Parameters:
sql
- a SQL statement that may contain one or more '?' parameter placeholders. Typically this statement is a JDBC function call escape string.resultSetType
- a result set type; see ResultSet.TYPE_XXXresultSetConcurrency
- a concurrency type; see ResultSet.CONCUR_XXX- Returns:
- a new CallableStatement object containing the pre-compiled SQL statement
- Throws:
SQLException
- if a database access error occurs- Since:
- 1.2
-
checkConnection
Check to see if the connection is still open. If not, throw an exception.- Throws:
SQLException
-
getOpenStatementCount
public int getOpenStatementCount()Return the number of statements that are currently open. Useful for debugging purposes.- Returns:
- The number of statements that are currently open.
-
setHoldability
Changes the holdability ofResultSet
objects created using thisConnection
object to the given holdability.- Specified by:
setHoldability
in interfaceConnection
- Parameters:
holdability
- aResultSet
holdability constant; one ofResultSet.HOLD_CURSORS_OVER_COMMIT
orResultSet.CLOSE_CURSORS_AT_COMMIT
- Throws:
SQLException
- if a database access occurs, the given parameter is not aResultSet
constant indicating holdability, or the given holdability is not supported- Since:
- 1.4
- See Also:
-
getHoldability
Retrieves the current holdability ofResultSet
objects created using thisConnection
object.- Specified by:
getHoldability
in interfaceConnection
- Returns:
- the holdability, one of
ResultSet.HOLD_CURSORS_OVER_COMMIT
orResultSet.CLOSE_CURSORS_AT_COMMIT
- Throws:
SQLException
- if a database access occurs- Since:
- 1.4
- See Also:
-
setSavepoint
Creates an unnamed savepoint in the current transaction and returns the newSavepoint
object that represents it.- Specified by:
setSavepoint
in interfaceConnection
- Returns:
- the new
Savepoint
object - Throws:
SQLException
- if a database access error occurs or thisConnection
object is currently in auto-commit mode- Since:
- 1.4
- See Also:
-
setSavepoint
Creates a savepoint with the given name in the current transaction and returns the newSavepoint
object that represents it.- Specified by:
setSavepoint
in interfaceConnection
- Parameters:
name
- aString
containing the name of the savepoint- Returns:
- the new
Savepoint
object - Throws:
SQLException
- if a database access error occurs or thisConnection
object is currently in auto-commit mode- Since:
- 1.4
- See Also:
-
rollback
Undoes all changes made after the givenSavepoint
object was set.This method should be used only when auto-commit has been disabled.
- Specified by:
rollback
in interfaceConnection
- Parameters:
savepoint
- theSavepoint
object to roll back to- Throws:
SQLException
- if a database access error occurs, theSavepoint
object is no longer valid, or thisConnection
object is currently in auto-commit mode- Since:
- 1.4
- See Also:
-
releaseSavepoint
Removes the givenSavepoint
object from the current transaction. Any reference to the savepoint after it have been removed will cause anSQLException
to be thrown.- Specified by:
releaseSavepoint
in interfaceConnection
- Parameters:
savepoint
- theSavepoint
object to be removed- Throws:
SQLException
- if a database access error occurs or the givenSavepoint
object is not a valid savepoint in the current transaction- Since:
- 1.4
-
createStatement
public Statement createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException Creates aStatement
object that will generateResultSet
objects with the given type, concurrency, and holdability. This method is the same as thecreateStatement
method above, but it allows the default result set type, concurrency, and holdability to be overridden.- Specified by:
createStatement
in interfaceConnection
- Parameters:
resultSetType
- one of the followingResultSet
constants:ResultSet.TYPE_FORWARD_ONLY
,ResultSet.TYPE_SCROLL_INSENSITIVE
, orResultSet.TYPE_SCROLL_SENSITIVE
resultSetConcurrency
- one of the followingResultSet
constants:ResultSet.CONCUR_READ_ONLY
orResultSet.CONCUR_UPDATABLE
resultSetHoldability
- one of the followingResultSet
constants:ResultSet.HOLD_CURSORS_OVER_COMMIT
orResultSet.CLOSE_CURSORS_AT_COMMIT
- Returns:
- a new
Statement
object that will generateResultSet
objects with the given type, concurrency, and holdability - Throws:
SQLException
- if a database access error occurs or the given parameters are notResultSet
constants indicating type, concurrency, and holdability- Since:
- 1.4
- See Also:
-
prepareStatement
public PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException Creates aPreparedStatement
object that will generateResultSet
objects with the given type, concurrency, and holdability.This method is the same as the
prepareStatement
method above, but it allows the default result set type, concurrency, and holdability to be overridden.- Specified by:
prepareStatement
in interfaceConnection
- Parameters:
sql
- aString
object that is the SQL statement to be sent to the database; may contain one or more ? IN parametersresultSetType
- one of the followingResultSet
constants:ResultSet.TYPE_FORWARD_ONLY
,ResultSet.TYPE_SCROLL_INSENSITIVE
, orResultSet.TYPE_SCROLL_SENSITIVE
resultSetConcurrency
- one of the followingResultSet
constants:ResultSet.CONCUR_READ_ONLY
orResultSet.CONCUR_UPDATABLE
resultSetHoldability
- one of the followingResultSet
constants:ResultSet.HOLD_CURSORS_OVER_COMMIT
orResultSet.CLOSE_CURSORS_AT_COMMIT
- Returns:
- a new
PreparedStatement
object, containing the pre-compiled SQL statement, that will generateResultSet
objects with the given type, concurrency, and holdability - Throws:
SQLException
- if a database access error occurs or the given parameters are notResultSet
constants indicating type, concurrency, and holdability- Since:
- 1.4
- See Also:
-
prepareCall
public CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException Creates aCallableStatement
object that will generateResultSet
objects with the given type and concurrency. This method is the same as theprepareCall
method above, but it allows the default result set type, result set concurrency type and holdability to be overridden.- Specified by:
prepareCall
in interfaceConnection
- Parameters:
sql
- aString
object that is the SQL statement to be sent to the database; may contain on or more ? parametersresultSetType
- one of the followingResultSet
constants:ResultSet.TYPE_FORWARD_ONLY
,ResultSet.TYPE_SCROLL_INSENSITIVE
, orResultSet.TYPE_SCROLL_SENSITIVE
resultSetConcurrency
- one of the followingResultSet
constants:ResultSet.CONCUR_READ_ONLY
orResultSet.CONCUR_UPDATABLE
resultSetHoldability
- one of the followingResultSet
constants:ResultSet.HOLD_CURSORS_OVER_COMMIT
orResultSet.CLOSE_CURSORS_AT_COMMIT
- Returns:
- a new
CallableStatement
object, containing the pre-compiled SQL statement, that will generateResultSet
objects with the given type, concurrency, and holdability - Throws:
SQLException
- if a database access error occurs or the given parameters are notResultSet
constants indicating type, concurrency, and holdability- Since:
- 1.4
- See Also:
-
prepareStatement
Creates a defaultPreparedStatement
object that has the capability to retrieve auto-generated keys. The given constant tells the driver whether it should make auto-generated keys available for retrieval. This parameter is ignored if the SQL statement is not anINSERT
statement.Note: This method is optimized for handling parametric SQL statements that benefit from precompilation. If the driver supports precompilation, the method
prepareStatement
will send the statement to the database for precompilation. Some drivers may not support precompilation. In this case, the statement may not be sent to the database until thePreparedStatement
object is executed. This has no direct effect on users; however, it does affect which methods throw certain SQLExceptions.Result sets created using the returned
PreparedStatement
object will by default be typeTYPE_FORWARD_ONLY
and have a concurrency level ofCONCUR_READ_ONLY
.- Specified by:
prepareStatement
in interfaceConnection
- Parameters:
sql
- an SQL statement that may contain one or more '?' IN parameter placeholdersautoGeneratedKeys
- a flag indicating whether auto-generated keys should be returned; one ofStatement.RETURN_GENERATED_KEYS
orStatement.NO_GENERATED_KEYS
- Returns:
- a new
PreparedStatement
object, containing the pre-compiled SQL statement, that will have the capability of returning auto-generated keys - Throws:
SQLException
- if a database access error occurs or the given parameter is not aStatement
constant indicating whether auto-generated keys should be returned- Since:
- 1.4
-
prepareStatement
Creates a defaultPreparedStatement
object capable of returning the auto-generated keys designated by the given array. This array contains the indexes of the columns in the target table that contain the auto-generated keys that should be made available. This array is ignored if the SQL statement is not anINSERT
statement.An SQL statement with or without IN parameters can be pre-compiled and stored in a
PreparedStatement
object. This object can then be used to efficiently execute this statement multiple times.Note: This method is optimized for handling parametric SQL statements that benefit from precompilation. If the driver supports precompilation, the method
prepareStatement
will send the statement to the database for precompilation. Some drivers may not support precompilation. In this case, the statement may not be sent to the database until thePreparedStatement
object is executed. This has no direct effect on users; however, it does affect which methods throw certain SQLExceptions.Result sets created using the returned
PreparedStatement
object will by default be typeTYPE_FORWARD_ONLY
and have a concurrency level ofCONCUR_READ_ONLY
.- Specified by:
prepareStatement
in interfaceConnection
- Parameters:
sql
- an SQL statement that may contain one or more '?' IN parameter placeholderscolumnIndexes
- an array of column indexes indicating the columns that should be returned from the inserted row or rows- Returns:
- a new
PreparedStatement
object, containing the pre-compiled statement, that is capable of returning the auto-generated keys designated by the given array of column indexes - Throws:
SQLException
- if a database access error occurs- Since:
- 1.4
-
prepareStatement
Creates a defaultPreparedStatement
object capable of returning the auto-generated keys designated by the given array. This array contains the names of the columns in the target table that contain the auto-generated keys that should be returned. This array is ignored if the SQL statement is not anINSERT
statement.An SQL statement with or without IN parameters can be pre-compiled and stored in a
PreparedStatement
object. This object can then be used to efficiently execute this statement multiple times.Note: This method is optimized for handling parametric SQL statements that benefit from precompilation. If the driver supports precompilation, the method
prepareStatement
will send the statement to the database for precompilation. Some drivers may not support precompilation. In this case, the statement may not be sent to the database until thePreparedStatement
object is executed. This has no direct effect on users; however, it does affect which methods throw certain SQLExceptions.Result sets created using the returned
PreparedStatement
object will by default be typeTYPE_FORWARD_ONLY
and have a concurrency level ofCONCUR_READ_ONLY
.- Specified by:
prepareStatement
in interfaceConnection
- Parameters:
sql
- an SQL statement that may contain one or more '?' IN parameter placeholderscolumnNames
- an array of column names indicating the columns that should be returned from the inserted row or rows- Returns:
- a new
PreparedStatement
object, containing the pre-compiled statement, that is capable of returning the auto-generated keys designated by the given array of column names - Throws:
SQLException
- if a database access error occurs- Since:
- 1.4
-
getNetworkTimeout
- Specified by:
getNetworkTimeout
in interfaceConnection
- Throws:
SQLException
-
setNetworkTimeout
- Specified by:
setNetworkTimeout
in interfaceConnection
- Throws:
SQLException
-
abort
- Specified by:
abort
in interfaceConnection
- Throws:
SQLException
-
getSchema
- Specified by:
getSchema
in interfaceConnection
- Throws:
SQLException
-
setSchema
- Specified by:
setSchema
in interfaceConnection
- Throws:
SQLException
-
createStruct
- Specified by:
createStruct
in interfaceConnection
- Throws:
SQLException
-
createArrayOf
- Specified by:
createArrayOf
in interfaceConnection
- Throws:
SQLException
-
getClientInfo
- Specified by:
getClientInfo
in interfaceConnection
- Throws:
SQLException
-
getClientInfo
- Specified by:
getClientInfo
in interfaceConnection
- Throws:
SQLException
-
setClientInfo
- Specified by:
setClientInfo
in interfaceConnection
- Throws:
SQLClientInfoException
-
setClientInfo
- Specified by:
setClientInfo
in interfaceConnection
- Throws:
SQLClientInfoException
-
isValid
- Specified by:
isValid
in interfaceConnection
- Throws:
SQLException
-
createSQLXML
- Specified by:
createSQLXML
in interfaceConnection
- Throws:
SQLException
-
createNClob
- Specified by:
createNClob
in interfaceConnection
- Throws:
SQLException
-
createBlob
- Specified by:
createBlob
in interfaceConnection
- Throws:
SQLException
-
createClob
- Specified by:
createClob
in interfaceConnection
- Throws:
SQLException
-
isWrapperFor
- Specified by:
isWrapperFor
in interfaceWrapper
- Throws:
SQLException
-
unwrap
- Specified by:
unwrap
in interfaceWrapper
- Throws:
SQLException
-