jOOQ 3.18.7 · org.jooq.tools.jdbc.DefaultConnection

Modifier and Type	Field and Description
private final Connection	delegate

Access	Constructor and Description
public	DefaultConnection(Connection delegate)

Method Summary

Modifier and Type	Method and Description
public void	abort(Executor The `Executor` implementation which will be used by `abort`. executor) Overrides org.jooq.tools.jdbc.JDBC41Connection.abort. Implements java.sql.Connection.abort. Terminates an open connection.
public void	beginRequest() Overrides default java.sql.Connection.beginRequest. Hints to the driver that a request, an independent unit of work, is beginning on this connection.
public void	clearWarnings() Implements java.sql.Connection.clearWarnings. Clears all warnings reported for this `Connection` object.
public void	close() Implements java.sql.Connection.close. Releases this `Connection` object's database and JDBC resources immediately instead of waiting for them to be automatically released.
public void	commit() Implements java.sql.Connection.commit. Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by this `Connection` object.
public Array	createArrayOf(String the SQL name of the type the elements of the array map to. The typeName is a database-specific name which may be the name of a built-in type, a user-defined type or a standard SQL type supported by this database. This is the value returned by `Array.getBaseTypeName` typeName, Object[] the elements that populate the returned object elements) Implements java.sql.Connection.createArrayOf. Factory method for creating Array objects.
public Blob	createBlob() Implements java.sql.Connection.createBlob. Constructs an object that implements the `Blob` interface.
public Clob	createClob() Implements java.sql.Connection.createClob. Constructs an object that implements the `Clob` interface.
public NClob	createNClob() Implements java.sql.Connection.createNClob. Constructs an object that implements the `NClob` interface.
public SQLXML	createSQLXML() Implements java.sql.Connection.createSQLXML. Constructs an object that implements the `SQLXML` interface.
public Statement	createStatement() Implements java.sql.Connection.createStatement. Creates a `Statement` object for sending SQL statements to the database.
public Statement	createStatement(int a result set type; one of `ResultSet.TYPE_FORWARD_ONLY`, `ResultSet.TYPE_SCROLL_INSENSITIVE`, or `ResultSet.TYPE_SCROLL_SENSITIVE` resultSetType, int a concurrency type; one of `ResultSet.CONCUR_READ_ONLY` or `ResultSet.CONCUR_UPDATABLE` resultSetConcurrency) Implements java.sql.Connection.createStatement. Creates a `Statement` object that will generate `ResultSet` objects with the given type and concurrency.
public Statement	createStatement(int one of the following `ResultSet` constants: `ResultSet.TYPE_FORWARD_ONLY`, `ResultSet.TYPE_SCROLL_INSENSITIVE`, or `ResultSet.TYPE_SCROLL_SENSITIVE` resultSetType, int one of the following `ResultSet` constants: `ResultSet.CONCUR_READ_ONLY` or `ResultSet.CONCUR_UPDATABLE` resultSetConcurrency, int one of the following `ResultSet` constants: `ResultSet.HOLD_CURSORS_OVER_COMMIT` or `ResultSet.CLOSE_CURSORS_AT_COMMIT` resultSetHoldability) Implements java.sql.Connection.createStatement. Creates a `Statement` object that will generate `ResultSet` objects with the given type, concurrency, and holdability.
public Struct	createStruct(String the SQL type name of the SQL structured type that this `Struct` object maps to. The typeName is the name of a user-defined type that has been defined for this database. It is the value returned by `Struct.getSQLTypeName`. typeName, Object[] the attributes that populate the returned object attributes) Implements java.sql.Connection.createStruct. Factory method for creating Struct objects.
public void	endRequest() Overrides default java.sql.Connection.endRequest. Hints to the driver that a request, an independent unit of work, has completed.
public boolean	getAutoCommit() Implements java.sql.Connection.getAutoCommit. Retrieves the current auto-commit mode for this `Connection` object.
public String	getCatalog() Implements java.sql.Connection.getCatalog. Retrieves this `Connection` object's current catalog name.
public String	getClientInfo(String The name of the client info property to retrieve name) Implements java.sql.Connection.getClientInfo. Returns the value of the client info property specified by name.
public Properties	getClientInfo() Implements java.sql.Connection.getClientInfo. Returns a list containing the name and current value of each client info property supported by the driver.
public Connection	getDelegate()
public int	getHoldability() Implements java.sql.Connection.getHoldability. Retrieves the current holdability of `ResultSet` objects created using this `Connection` object.
public DatabaseMetaData	getMetaData() Implements java.sql.Connection.getMetaData. Retrieves a `DatabaseMetaData` object that contains metadata about the database to which this `Connection` object represents a connection.
public int	getNetworkTimeout() Overrides org.jooq.tools.jdbc.JDBC41Connection.getNetworkTimeout. Implements java.sql.Connection.getNetworkTimeout. Retrieves the number of milliseconds the driver will wait for a database request to complete.
public String	getSchema() Overrides org.jooq.tools.jdbc.JDBC41Connection.getSchema. Implements java.sql.Connection.getSchema. Retrieves this `Connection` object's current schema name.
public int	getTransactionIsolation() Implements java.sql.Connection.getTransactionIsolation. Retrieves this `Connection` object's current transaction isolation level.
public Map<String, Class<?>>	getTypeMap() Implements java.sql.Connection.getTypeMap. Retrieves the `Map` object associated with this `Connection` object.
public SQLWarning	getWarnings() Implements java.sql.Connection.getWarnings. Retrieves the first warning reported by calls on this `Connection` object.
public boolean	isClosed() Implements java.sql.Connection.isClosed. Retrieves whether this `Connection` object has been closed.
public boolean	isReadOnly() Implements java.sql.Connection.isReadOnly. Retrieves whether this `Connection` object is in read-only mode.
public boolean	isValid(int The time in seconds to wait for the database operation used to validate the connection to complete. If the timeout period expires before the operationcompletes, this method returns false. A value of 0 indicates a timeout is not applied to the database operation. timeout) Implements java.sql.Connection.isValid. Returns true if the connection has not been closed and is still valid.
public boolean	isWrapperFor(Class<?> a Class defining an interface. iface) Implements java.sql.Wrapper.isWrapperFor. Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
public String	nativeSQL(String an SQL statement that may contain one or more '?' parameter placeholders sql) Implements java.sql.Connection.nativeSQL. Converts the given SQL statement into the system's native SQL grammar.
public CallableStatement	prepareCall(String an SQL statement that may contain one or more '?' parameter placeholders. Typically this statement is specified using JDBC call escape syntax. sql) Implements java.sql.Connection.prepareCall. Creates a `CallableStatement` object for calling database stored procedures.
public CallableStatement	prepareCall(String a `String` object that is the SQL statement to be sent to the database; may contain on or more '?' parameters sql, int a result set type; one of `ResultSet.TYPE_FORWARD_ONLY`, `ResultSet.TYPE_SCROLL_INSENSITIVE`, or `ResultSet.TYPE_SCROLL_SENSITIVE` resultSetType, int a concurrency type; one of `ResultSet.CONCUR_READ_ONLY` or `ResultSet.CONCUR_UPDATABLE` resultSetConcurrency) Implements java.sql.Connection.prepareCall. Creates a `CallableStatement` object that will generate `ResultSet` objects with the given type and concurrency.
public CallableStatement	prepareCall(String a `String` object that is the SQL statement to be sent to the database; may contain on or more '?' parameters sql, int one of the following `ResultSet` constants: `ResultSet.TYPE_FORWARD_ONLY`, `ResultSet.TYPE_SCROLL_INSENSITIVE`, or `ResultSet.TYPE_SCROLL_SENSITIVE` resultSetType, int one of the following `ResultSet` constants: `ResultSet.CONCUR_READ_ONLY` or `ResultSet.CONCUR_UPDATABLE` resultSetConcurrency, int one of the following `ResultSet` constants: `ResultSet.HOLD_CURSORS_OVER_COMMIT` or `ResultSet.CLOSE_CURSORS_AT_COMMIT` resultSetHoldability) Implements java.sql.Connection.prepareCall. Creates a `CallableStatement` object that will generate `ResultSet` objects with the given type and concurrency.
public PreparedStatement	prepareStatement(String an SQL statement that may contain one or more '?' IN parameter placeholders sql) Implements java.sql.Connection.prepareStatement. Creates a `PreparedStatement` object for sending parameterized SQL statements to the database.
public PreparedStatement	prepareStatement(String a `String` object that is the SQL statement to be sent to the database; may contain one or more '?' IN parameters sql, int a result set type; one of `ResultSet.TYPE_FORWARD_ONLY`, `ResultSet.TYPE_SCROLL_INSENSITIVE`, or `ResultSet.TYPE_SCROLL_SENSITIVE` resultSetType, int a concurrency type; one of `ResultSet.CONCUR_READ_ONLY` or `ResultSet.CONCUR_UPDATABLE` resultSetConcurrency) Implements java.sql.Connection.prepareStatement. Creates a `PreparedStatement` object that will generate `ResultSet` objects with the given type and concurrency.
public PreparedStatement	prepareStatement(String a `String` object that is the SQL statement to be sent to the database; may contain one or more '?' IN parameters sql, int one of the following `ResultSet` constants: `ResultSet.TYPE_FORWARD_ONLY`, `ResultSet.TYPE_SCROLL_INSENSITIVE`, or `ResultSet.TYPE_SCROLL_SENSITIVE` resultSetType, int one of the following `ResultSet` constants: `ResultSet.CONCUR_READ_ONLY` or `ResultSet.CONCUR_UPDATABLE` resultSetConcurrency, int one of the following `ResultSet` constants: `ResultSet.HOLD_CURSORS_OVER_COMMIT` or `ResultSet.CLOSE_CURSORS_AT_COMMIT` resultSetHoldability) Implements java.sql.Connection.prepareStatement. Creates a `PreparedStatement` object that will generate `ResultSet` objects with the given type, concurrency, and holdability.
public PreparedStatement	prepareStatement(String an SQL statement that may contain one or more '?' IN parameter placeholders sql, int a flag indicating whether auto-generated keys should be returned; one of `Statement.RETURN_GENERATED_KEYS` or `Statement.NO_GENERATED_KEYS` autoGeneratedKeys) Implements java.sql.Connection.prepareStatement. Creates a default `PreparedStatement` object that has the capability to retrieve auto-generated keys.
public PreparedStatement	prepareStatement(String an SQL statement that may contain one or more '?' IN parameter placeholders sql, int[] an array of column indexes indicating the columns that should be returned from the inserted row or rows columnIndexes) Implements java.sql.Connection.prepareStatement. Creates a default `PreparedStatement` object capable of returning the auto-generated keys designated by the given array.
public PreparedStatement	prepareStatement(String an SQL statement that may contain one or more '?' IN parameter placeholders sql, String[] an array of column names indicating the columns that should be returned from the inserted row or rows columnNames) Implements java.sql.Connection.prepareStatement. Creates a default `PreparedStatement` object capable of returning the auto-generated keys designated by the given array.
public void	releaseSavepoint(Savepoint the `Savepoint` object to be removed savepoint) Implements java.sql.Connection.releaseSavepoint. Removes the specified `Savepoint` and subsequent `Savepoint` objects from the current transaction.
public void	rollback() Implements java.sql.Connection.rollback. Undoes all changes made in the current transaction and releases any database locks currently held by this `Connection` object.
public void	rollback(Savepoint the `Savepoint` object to roll back to savepoint) Implements java.sql.Connection.rollback. Undoes all changes made after the given `Savepoint` object was set.
public void	setAutoCommit(boolean `true` to enable auto-commit mode; `false` to disable it autoCommit) Implements java.sql.Connection.setAutoCommit. Sets this connection's auto-commit mode to the given state.
public void	setCatalog(String the name of a catalog (subspace in this `Connection` object's database) in which to work catalog) Implements java.sql.Connection.setCatalog. Sets the given catalog name in order to select a subspace of this `Connection` object's database in which to work.
public void	setClientInfo(String The name of the client info property to set name, String The value to set the client info property to. If the value is null, the current value of the specified property is cleared. value) Implements java.sql.Connection.setClientInfo. Sets the value of the client info property specified by name to the value specified by value.
public void	setClientInfo(Properties the list of client info properties to set properties) Implements java.sql.Connection.setClientInfo. Sets the value of the connection's client info properties.
public void	setHoldability(int a `ResultSet` holdability constant; one of `ResultSet.HOLD_CURSORS_OVER_COMMIT` or `ResultSet.CLOSE_CURSORS_AT_COMMIT` holdability) Implements java.sql.Connection.setHoldability. Changes the default holdability of `ResultSet` objects created using this `Connection` object to the given holdability.
public void	setNetworkTimeout(Executor The `Executor` implementation which will be used by `setNetworkTimeout`. executor, int The time in milliseconds to wait for the database operation to complete. If the JDBC driver does not support milliseconds, the JDBC driver will round the value up to the nearest second. If the timeout period expires before the operation completes, a SQLException will be thrown. A value of 0 indicates that there is not timeout for database operations. milliseconds) Overrides org.jooq.tools.jdbc.JDBC41Connection.setNetworkTimeout. Implements java.sql.Connection.setNetworkTimeout. Sets the maximum period a `Connection` or objects created from the `Connection` will wait for the database to reply to any one request.
public void	setReadOnly(boolean `true` enables read-only mode; `false` disables it readOnly) Implements java.sql.Connection.setReadOnly. Puts this connection in read-only mode as a hint to the driver to enable database optimizations.
public Savepoint	setSavepoint() Implements java.sql.Connection.setSavepoint. Creates an unnamed savepoint in the current transaction and returns the new `Savepoint` object that represents it.
public Savepoint	setSavepoint(String a `String` containing the name of the savepoint name) Implements java.sql.Connection.setSavepoint. Creates a savepoint with the given name in the current transaction and returns the new `Savepoint` object that represents it.
public void	setSchema(String the name of a schema in which to work s) Overrides org.jooq.tools.jdbc.JDBC41Connection.setSchema. Implements java.sql.Connection.setSchema. Sets the given schema name to access.
public void	setShardingKey(ShardingKey the sharding key to set on this connection. The sharding key may be `null` shardingKey, ShardingKey the super sharding key to set on this connection. The super sharding key may be `null` superShardingKey) Overrides default java.sql.Connection.setShardingKey. Specifies a shardingKey and superShardingKey to use with this Connection
public void	setShardingKey(ShardingKey the sharding key to set on this connection. The sharding key may be `null` shardingKey) Overrides default java.sql.Connection.setShardingKey. Specifies a shardingKey to use with this Connection
public boolean	setShardingKeyIfValid(ShardingKey the sharding key to be validated against this connection. The sharding key may be `null` shardingKey, ShardingKey the super sharding key to be validated against this connection. The super sharding key may be `null`. superShardingKey, int time in seconds before which the validation process is expected to be completed, otherwise the validation process is aborted. A value of 0 indicates the validation process will not time out. timeout) Overrides default java.sql.Connection.setShardingKeyIfValid. Sets and validates the sharding keys for this connection.
public boolean	setShardingKeyIfValid(ShardingKey the sharding key to be validated against this connection. The sharding key may be `null` shardingKey, int time in seconds before which the validation process is expected to be completed,else the validation process is aborted. A value of 0 indicates the validation process will not time out. timeout) Overrides default java.sql.Connection.setShardingKeyIfValid. Sets and validates the sharding key for this connection.
public void	setTransactionIsolation(int one of the following `Connection` constants: `Connection.TRANSACTION_READ_UNCOMMITTED`, `Connection.TRANSACTION_READ_COMMITTED`, `Connection.TRANSACTION_REPEATABLE_READ`, or `Connection.TRANSACTION_SERIALIZABLE`. (Note that `Connection.TRANSACTION_NONE` cannot be used because it specifies that transactions are not supported.) level) Implements java.sql.Connection.setTransactionIsolation. Attempts to change the transaction isolation level for this `Connection` object to the one given.
public void	setTypeMap(Map<String, Class<?>> the `java.util.Map` object to install as the replacement for this `Connection` object's default type map map) Implements java.sql.Connection.setTypeMap. Installs the given `TypeMap` object as the type map for this `Connection` object.
public <T> T	unwrap(Class<T> A Class defining an interface that the result must implement. iface) Implements java.sql.Wrapper.unwrap. Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.

public Class DefaultConnection

Field Summary

Constructor Summary

Method Summary