atg.service.resourcepool
Class MonitoredConnection

java.lang.Object
  atg.service.resourcepool.MonitoredConnection

All Implemented Interfaces:

java.sql.Connection

public class MonitoredConnection
extends java.lang.Object
implements java.sql.Connection

This class is a wrapper for java.sql.Connection. All calls are passed through to an embedded instance of java.sql.Connection.

Field Summary

static java.lang.String

CLASS_VERSION Class version string

Fields inherited from interface java.sql.Connection

TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE

Constructor Summary

MonitoredConnection(java.sql.Connection pWrapped, ApplicationLogging pLog, ConnectionStats pStats, java.lang.String pId)
Constructs a new wrapper java.sql.Connection wrapper

MonitoredConnection(java.sql.Connection pWrapped, ApplicationLogging pLog, ConnectionStats pStats, java.lang.String pId, java.lang.Integer pMaxFieldSize, java.lang.Integer pMaxRows, java.lang.Integer pQueryTimeout)
Constructs a new wrapper java.sql.Connection wrapper

Method Summary

void	checkConnectionIntegrity() Checks to see if this connection has been closed, i.e.
void	clearWarnings() Wraps the call to clearWarnings
void	close() Wraps the call to close
void	commit() Wraps the call to commit
java.sql.Statement	createStatement() Wraps the call to createStatement
java.sql.Statement	createStatement(int p0, int p1) Wraps the call to createStatement
java.sql.Statement	createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) Creates a Statement object that will generate ResultSet objects with the given type, concurrency, and holdability.
java.lang.String	getActiveQuery()
boolean	getAutoCommit() Wraps the call to getAutoCommit
java.lang.String	getCatalog() Wraps the call to getCatalog
java.lang.String	getCreationStackTrace()
int	getHoldability() Retrieves the current holdability of ResultSet objects created using this Connection object.
java.lang.String	getId()
ApplicationLogging	getLog()
java.lang.Integer	getMaxFieldSize()
java.lang.Integer	getMaxRows()
java.sql.DatabaseMetaData	getMetaData() Wraps the call to getMetaData
java.lang.Integer	getQueryTimeout()
ResourceObject	getResourceObject()
ConnectionStats	getStats()
int	getTransactionIsolation() Wraps the call to getTransactionIsolation
java.util.Map	getTypeMap() Wraps the call to getTypeMap
java.sql.SQLWarning	getWarnings() Wraps the call to getWarnings
java.sql.Connection	getWrapped()
boolean	isClosed() Wraps the call to isClosed
boolean	isReadOnly() Wraps the call to isReadOnly
java.lang.String	nativeSQL(java.lang.String p0) Wraps the call to nativeSQL
java.sql.CallableStatement	prepareCall(java.lang.String p0) Wraps the call to prepareCall
java.sql.CallableStatement	prepareCall(java.lang.String p0, int p1, int p2) Wraps the call to prepareCall
java.sql.CallableStatement	prepareCall(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) Creates a CallableStatement object that will generate ResultSet objects with the given type and concurrency.
java.sql.PreparedStatement	prepareStatement(java.lang.String p0) Wraps the call to prepareStatement
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int autoGeneratedKeys) Creates a default PreparedStatement object that has the capability to retrieve auto-generated keys.
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int[] columnIndexes) Creates a default PreparedStatement object capable of returning the auto-generated keys designated by the given array.
java.sql.PreparedStatement	prepareStatement(java.lang.String p0, int p1, int p2) Wraps the call to prepareStatement
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) Creates a PreparedStatement object that will generate ResultSet objects with the given type, concurrency, and holdability.
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, java.lang.String[] columnNames) Creates a default PreparedStatement object capable of returning the auto-generated keys designated by the given array.
void	releaseSavepoint(java.sql.Savepoint savepoint) Removes the given Savepoint object from the current transaction.
void	rollback() Wraps the call to rollback
void	rollback(java.sql.Savepoint savepoint) Undoes all changes made after the given Savepoint object was set.
void	setActiveQuery(java.lang.String pActiveQuery)
void	setAutoCommit(boolean p0) Wraps the call to setAutoCommit
void	setCatalog(java.lang.String p0) Wraps the call to setCatalog
void	setCreationStackTrace(java.lang.String pStackTrace)
void	setHoldability(int holdability) Changes the holdability of ResultSet objects created using this Connection object to the given holdability.
void	setId(java.lang.String pId)
void	setLog(ApplicationLogging pLog)
void	setMaxFieldSize(java.lang.Integer pMaxFieldSize)
void	setMaxRows(java.lang.Integer pMaxRows)
void	setQueryTimeout(java.lang.Integer pQueryTimeout)
void	setReadOnly(boolean p0) Wraps the call to setReadOnly
void	setResourceObject(ResourceObject pRobj)
java.sql.Savepoint	setSavepoint() Creates an unnamed savepoint in the current transaction and returns the new Savepoint object that represents it.
java.sql.Savepoint	setSavepoint(java.lang.String name) Creates a savepoint with the given name in the current transaction and returns the new Savepoint object that represents it.
void	setStats(ConnectionStats pStats)
void	setTransactionIsolation(int p0) Wraps the call to setTransactionIsolation
void	setTypeMap(java.util.Map p0) Wraps the call to setTypeMap
void	setWrapped(java.sql.Connection pWrapped)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

CLASS_VERSION

public static java.lang.String CLASS_VERSION

Class version string

Constructor Detail

MonitoredConnection

public MonitoredConnection(java.sql.Connection pWrapped,
                           ApplicationLogging pLog,
                           ConnectionStats pStats,
                           java.lang.String pId)

Constructs a new wrapper java.sql.Connection wrapper

Parameters:

pWrapped - the instance being wrapped

pLog - the ApplicationLogging to which output should be sent. SQL statements are logged as info, the actual arguments and result set values are logged as debug. If null, then no logging is sent.

pStats - the object that receives notifications about connection statistics, such as the number of statements executed. If null, then no notifications are sent.

pId - an identifier for the connection, used when logging.

MonitoredConnection

public MonitoredConnection(java.sql.Connection pWrapped,
                           ApplicationLogging pLog,
                           ConnectionStats pStats,
                           java.lang.String pId,
                           java.lang.Integer pMaxFieldSize,
                           java.lang.Integer pMaxRows,
                           java.lang.Integer pQueryTimeout)

Constructs a new wrapper java.sql.Connection wrapper

Parameters:

pWrapped - the instance being wrapped

pLog - the ApplicationLogging to which output should be sent. SQL statements are logged as info, the actual arguments and result set values are logged as debug. If null, then no logging is sent.

pStats - the object that receives notifications about connection statistics, such as the number of statements executed. If null, then no notifications are sent.

pId - an identifier for the connection, used when logging.

pMaxFieldSize - if not null then set on every Statement created

pMaxRow - if not null then set on every Statement created

pQueryTimeout - if not null then set on every Statement created

Method Detail

getResourceObject

public ResourceObject getResourceObject()

setResourceObject

public void setResourceObject(ResourceObject pRobj)

getWrapped

public java.sql.Connection getWrapped()

setWrapped

public void setWrapped(java.sql.Connection pWrapped)

getLog

public ApplicationLogging getLog()

setLog

public void setLog(ApplicationLogging pLog)

getStats

public ConnectionStats getStats()

setStats

public void setStats(ConnectionStats pStats)

getId

public java.lang.String getId()

setId

public void setId(java.lang.String pId)

getMaxFieldSize

public java.lang.Integer getMaxFieldSize()

setMaxFieldSize

public void setMaxFieldSize(java.lang.Integer pMaxFieldSize)

getMaxRows

public java.lang.Integer getMaxRows()

setMaxRows

public void setMaxRows(java.lang.Integer pMaxRows)

getQueryTimeout

public java.lang.Integer getQueryTimeout()

setQueryTimeout

public void setQueryTimeout(java.lang.Integer pQueryTimeout)

getCreationStackTrace

public java.lang.String getCreationStackTrace()

setCreationStackTrace

public void setCreationStackTrace(java.lang.String pStackTrace)

getActiveQuery

public java.lang.String getActiveQuery()

setActiveQuery

public void setActiveQuery(java.lang.String pActiveQuery)

checkConnectionIntegrity

public void checkConnectionIntegrity()
                              throws java.sql.SQLException

Checks to see if this connection has been closed, i.e. is the underlying resource null. If the resource is null, an exception is thrown.

Throws:

java.sql.SQLException

createStatement

public java.sql.Statement createStatement()
                                   throws java.sql.SQLException

Wraps the call to createStatement

Specified by:

createStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

createStatement

public java.sql.Statement createStatement(int p0,
                                          int p1)
                                   throws java.sql.SQLException

Wraps the call to createStatement

Specified by:

createStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String p0)
                                            throws java.sql.SQLException

Wraps the call to prepareStatement

Specified by:

prepareStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String p0,
                                                   int p1,
                                                   int p2)
                                            throws java.sql.SQLException

Wraps the call to prepareStatement

Specified by:

prepareStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String p0)
                                       throws java.sql.SQLException

Wraps the call to prepareCall

Specified by:

prepareCall in interface java.sql.Connection

Throws:

java.sql.SQLException

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String p0,
                                              int p1,
                                              int p2)
                                       throws java.sql.SQLException

Wraps the call to prepareCall

Specified by:

prepareCall in interface java.sql.Connection

Throws:

java.sql.SQLException

nativeSQL

public java.lang.String nativeSQL(java.lang.String p0)
                           throws java.sql.SQLException

Wraps the call to nativeSQL

Specified by:

nativeSQL in interface java.sql.Connection

Throws:

java.sql.SQLException

setAutoCommit

public void setAutoCommit(boolean p0)
                   throws java.sql.SQLException

Wraps the call to setAutoCommit

Specified by:

setAutoCommit in interface java.sql.Connection

Throws:

java.sql.SQLException

getAutoCommit

public boolean getAutoCommit()
                      throws java.sql.SQLException

Wraps the call to getAutoCommit

Specified by:

getAutoCommit in interface java.sql.Connection

Throws:

java.sql.SQLException

commit

public void commit()
            throws java.sql.SQLException

Wraps the call to commit

Specified by:

commit in interface java.sql.Connection

Throws:

java.sql.SQLException

rollback

public void rollback()
              throws java.sql.SQLException

Wraps the call to rollback

Specified by:

rollback in interface java.sql.Connection

Throws:

java.sql.SQLException

close

public void close()
           throws java.sql.SQLException

Wraps the call to close

Specified by:

close in interface java.sql.Connection

Throws:

java.sql.SQLException

isClosed

public boolean isClosed()
                 throws java.sql.SQLException

Wraps the call to isClosed

Specified by:

isClosed in interface java.sql.Connection

Throws:

java.sql.SQLException

getMetaData

public java.sql.DatabaseMetaData getMetaData()
                                      throws java.sql.SQLException

Wraps the call to getMetaData

Specified by:

getMetaData in interface java.sql.Connection

Throws:

java.sql.SQLException

setTypeMap

public void setTypeMap(java.util.Map p0)
                throws java.sql.SQLException

Wraps the call to setTypeMap

Specified by:

setTypeMap in interface java.sql.Connection

Throws:

java.sql.SQLException

getTypeMap

public java.util.Map getTypeMap()
                         throws java.sql.SQLException

Wraps the call to getTypeMap

Specified by:

getTypeMap in interface java.sql.Connection

Throws:

java.sql.SQLException

setReadOnly

public void setReadOnly(boolean p0)
                 throws java.sql.SQLException

Wraps the call to setReadOnly

Specified by:

setReadOnly in interface java.sql.Connection

Throws:

java.sql.SQLException

isReadOnly

public boolean isReadOnly()
                   throws java.sql.SQLException

Wraps the call to isReadOnly

Specified by:

isReadOnly in interface java.sql.Connection

Throws:

java.sql.SQLException

setCatalog

public void setCatalog(java.lang.String p0)
                throws java.sql.SQLException

Wraps the call to setCatalog

Specified by:

setCatalog in interface java.sql.Connection

Throws:

java.sql.SQLException

getCatalog

public java.lang.String getCatalog()
                            throws java.sql.SQLException

Wraps the call to getCatalog

Specified by:

getCatalog in interface java.sql.Connection

Throws:

java.sql.SQLException

setTransactionIsolation

public void setTransactionIsolation(int p0)
                             throws java.sql.SQLException

Wraps the call to setTransactionIsolation

Specified by:

setTransactionIsolation in interface java.sql.Connection

Throws:

java.sql.SQLException

getTransactionIsolation

public int getTransactionIsolation()
                            throws java.sql.SQLException

Wraps the call to getTransactionIsolation

Specified by:

getTransactionIsolation in interface java.sql.Connection

Throws:

java.sql.SQLException

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException

Wraps the call to getWarnings

Specified by:

getWarnings in interface java.sql.Connection

Throws:

java.sql.SQLException

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException

Wraps the call to clearWarnings

Specified by:

clearWarnings in interface java.sql.Connection

Throws:

java.sql.SQLException

setHoldability

public void setHoldability(int holdability)
                    throws java.sql.SQLException

Changes the holdability of ResultSet objects created using this Connection object to the given holdability.

Specified by:

setHoldability in interface java.sql.Connection

Parameters:

holdability - a ResultSet holdability constant; one of ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT

Throws:

SQLException - if a database access occurs, the given parameter is not a ResultSet constant indicating holdability, or the given holdability is not supported

Since:

1.4

See Also:

getHoldability(), ResultSet

getHoldability

public int getHoldability()
                   throws java.sql.SQLException

Retrieves the current holdability of ResultSet objects created using this Connection object.

Specified by:

getHoldability in interface java.sql.Connection

Returns:

the holdability, one of ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT

Throws:

SQLException - if a database access occurs

Since:

1.4

See Also:

setHoldability(int), ResultSet

setSavepoint

public java.sql.Savepoint setSavepoint()
                                throws java.sql.SQLException

Creates an unnamed savepoint in the current transaction and returns the new Savepoint object that represents it.

Specified by:

setSavepoint in interface java.sql.Connection

Returns:

the new Savepoint object

Throws:

SQLException - if a database access error occurs or this Connection object is currently in auto-commit mode

Since:

1.4

See Also:

Savepoint

setSavepoint

public java.sql.Savepoint setSavepoint(java.lang.String name)
                                throws java.sql.SQLException

Creates a savepoint with the given name in the current transaction and returns the new Savepoint object that represents it.

Specified by:

setSavepoint in interface java.sql.Connection

Parameters:

name - a String containing the name of the savepoint

Returns:

the new Savepoint object

Throws:

SQLException - if a database access error occurs or this Connection object is currently in auto-commit mode

Since:

1.4

See Also:

Savepoint

rollback

public void rollback(java.sql.Savepoint savepoint)
              throws java.sql.SQLException

Undoes all changes made after the given Savepoint object was set.

This method should be used only when auto-commit has been disabled.

Specified by:

rollback in interface java.sql.Connection

Parameters:

savepoint - the Savepoint object to roll back to

Throws:

SQLException - if a database access error occurs, the Savepoint object is no longer valid, or this Connection object is currently in auto-commit mode

Since:

1.4

See Also:

Savepoint, rollback()

releaseSavepoint

public void releaseSavepoint(java.sql.Savepoint savepoint)
                      throws java.sql.SQLException

Removes the given Savepoint object from the current transaction. Any reference to the savepoint after it have been removed will cause an SQLException to be thrown.

Specified by:

releaseSavepoint in interface java.sql.Connection

Parameters:

savepoint - the Savepoint object to be removed

Throws:

SQLException - if a database access error occurs or the given Savepoint object is not a valid savepoint in the current transaction

Since:

1.4

createStatement

public java.sql.Statement createStatement(int resultSetType,
                                          int resultSetConcurrency,
                                          int resultSetHoldability)
                                   throws java.sql.SQLException

Creates a Statement object that will generate ResultSet objects with the given type, concurrency, and holdability. This method is the same as the createStatement method above, but it allows the default result set type, concurrency, and holdability to be overridden.

Specified by:

createStatement in interface java.sql.Connection

Parameters:

resultSetType - one of the following ResultSet constants: ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE

resultSetConcurrency - one of the following ResultSet constants: ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

resultSetHoldability - one of the following ResultSet constants: ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT

Returns:

a new Statement object that will generate ResultSet objects with the given type, concurrency, and holdability

Throws:

SQLException - if a database access error occurs or the given parameters are not ResultSet constants indicating type, concurrency, and holdability

Since:

1.4

See Also:

ResultSet

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   int resultSetType,
                                                   int resultSetConcurrency,
                                                   int resultSetHoldability)
                                            throws java.sql.SQLException

Creates a PreparedStatement object that will generate ResultSet 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 interface java.sql.Connection

Parameters:

sql - a String object that is the SQL statement to be sent to the database; may contain one or more ? IN parameters

resultSetType - one of the following ResultSet constants: ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE

resultSetConcurrency - one of the following ResultSet constants: ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

resultSetHoldability - one of the following ResultSet constants: ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT

Returns:

a new PreparedStatement object, containing the pre-compiled SQL statement, that will generate ResultSet objects with the given type, concurrency, and holdability

Throws:

SQLException - if a database access error occurs or the given parameters are not ResultSet constants indicating type, concurrency, and holdability

Since:

1.4

See Also:

ResultSet

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String sql,
                                              int resultSetType,
                                              int resultSetConcurrency,
                                              int resultSetHoldability)
                                       throws java.sql.SQLException

Creates a CallableStatement object that will generate ResultSet objects with the given type and concurrency. This method is the same as the prepareCall method above, but it allows the default result set type, result set concurrency type and holdability to be overridden.

Specified by:

prepareCall in interface java.sql.Connection

Parameters:

sql - a String object that is the SQL statement to be sent to the database; may contain on or more ? parameters

resultSetType - one of the following ResultSet constants: ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE

resultSetConcurrency - one of the following ResultSet constants: ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

resultSetHoldability - one of the following ResultSet constants: ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT

Returns:

a new CallableStatement object, containing the pre-compiled SQL statement, that will generate ResultSet objects with the given type, concurrency, and holdability

Throws:

SQLException - if a database access error occurs or the given parameters are not ResultSet constants indicating type, concurrency, and holdability

Since:

1.4

See Also:

ResultSet

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   int autoGeneratedKeys)
                                            throws java.sql.SQLException

Creates a default PreparedStatement 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 an INSERT 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 the PreparedStatement 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 type TYPE_FORWARD_ONLY and have a concurrency level of CONCUR_READ_ONLY.

Specified by:

prepareStatement in interface java.sql.Connection

Parameters:

sql - an SQL statement that may contain one or more '?' IN parameter placeholders

autoGeneratedKeys - a flag indicating whether auto-generated keys should be returned; one of Statement.RETURN_GENERATED_KEYS or Statement.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 a Statement constant indicating whether auto-generated keys should be returned

Since:

1.4

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   int[] columnIndexes)
                                            throws java.sql.SQLException

Creates a default PreparedStatement 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 an INSERT 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 the PreparedStatement 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 type TYPE_FORWARD_ONLY and have a concurrency level of CONCUR_READ_ONLY.

Specified by:

prepareStatement in interface java.sql.Connection

Parameters:

sql - an SQL statement that may contain one or more '?' IN parameter placeholders

columnIndexes - 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

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   java.lang.String[] columnNames)
                                            throws java.sql.SQLException

Creates a default PreparedStatement 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 an INSERT 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 the PreparedStatement 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 type TYPE_FORWARD_ONLY and have a concurrency level of CONCUR_READ_ONLY.

Specified by:

prepareStatement in interface java.sql.Connection

Parameters:

sql - an SQL statement that may contain one or more '?' IN parameter placeholders

columnNames - 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