| Modifier and Type | Field and Description |
|---|---|
| protected Connection |
| Access | Constructor and Description |
|---|---|
| public | |
| public |
| Modifier and Type | Method and Description |
|---|---|
| private void | |
| public void | abort(Executor
The a)Executor implementation which will
be used by abort.Implements java. Terminates an open connection. |
| public void | clearWarnings()
Implements java. Clears all warnings reported for this |
| public void | close()
Implements java. Releases this |
| public void | commit()
Implements java. Makes all changes made since the previous
commit/rollback permanent and releases any database locks
currently held by this |
| 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 a, Object[] Array.getBaseTypeNamethe elements that populate the returned object b)Implements java. Factory method for creating Array objects. |
| public Blob | createBlob()
Implements java. Constructs an object that implements the |
| public Clob | createClob()
Implements java. Constructs an object that implements the |
| public NClob | createNClob()
Implements java. Constructs an object that implements the |
| public SQLXML | createSQLXML()
Implements java. Constructs an object that implements the |
| public Statement | createStatement(int
one of the following a, int ResultSet
constants:
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE, or
ResultSet.TYPE_SCROLL_SENSITIVEone of the following b, int ResultSet
constants:
ResultSet.CONCUR_READ_ONLY or
ResultSet.CONCUR_UPDATABLEone of the following c)ResultSet
constants:
ResultSet.HOLD_CURSORS_OVER_COMMIT or
ResultSet.CLOSE_CURSORS_AT_COMMITImplements java. Creates a |
| public Statement | createStatement(int
a result set type; one of
a, int ResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE, or
ResultSet.TYPE_SCROLL_SENSITIVEa concurrency type; one of
b)ResultSet.CONCUR_READ_ONLY or
ResultSet.CONCUR_UPDATABLEImplements java. Creates a |
| public Statement | createStatement()
Implements java. Creates a |
| public Struct | createStruct(String
the SQL type name of the SQL structured type that this a, Object[] 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.the attributes that populate the returned object b)Implements java. Factory method for creating Struct objects. |
| public boolean | getAutoCommit()
Implements java. Retrieves the current auto-commit mode for this |
| public String | getCatalog()
Implements java. Retrieves this |
| public String | getClientInfo(String
The name of the client info property to retrieve a)Implements java. Returns the value of the client info property specified by name. |
| public Properties | getClientInfo()
Implements java. Returns a list containing the name and current value of each client info property supported by the driver. |
| public int | getHoldability()
Implements java. Retrieves the current holdability of |
| public Connection | |
| public DatabaseMetaData | getMetaData()
Implements java. Retrieves a |
| public int | getNetworkTimeout()
Implements java. Retrieves the number of milliseconds the driver will wait for a database request to complete. |
| public String | getSchema()
Implements java. Retrieves this |
| public int | getTransactionIsolation()
Implements java. Retrieves this |
| public Map | getTypeMap()
Implements java. Retrieves the |
| public SQLWarning | getWarnings()
Implements java. Retrieves the first warning reported by calls on this
|
| public boolean | isClosed()
Implements java. Retrieves whether this |
| public boolean | isReadOnly()
Implements java. Retrieves whether this |
| 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. a)Implements java. Returns true if the connection has not been closed and is still valid. |
| public boolean | isWrapperFor(Class<T>
a Class defining an interface. a)Implements java. 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 a)Implements java. Converts the given SQL statement into the system's native SQL grammar. |
| public CallableStatement | prepareCall(String
a a, int String object that is the SQL statement to
be sent to the database; may contain on or more '?' parametersone of the following b, int ResultSet
constants:
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE, or
ResultSet.TYPE_SCROLL_SENSITIVEone of the following c, int ResultSet
constants:
ResultSet.CONCUR_READ_ONLY or
ResultSet.CONCUR_UPDATABLEone of the following d)ResultSet
constants:
ResultSet.HOLD_CURSORS_OVER_COMMIT or
ResultSet.CLOSE_CURSORS_AT_COMMITImplements java. Creates a |
| public CallableStatement | prepareCall(String
a a, int String object that is the SQL statement to
be sent to the database; may contain on or more '?' parametersa result set type; one of
b, int ResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE, or
ResultSet.TYPE_SCROLL_SENSITIVEa concurrency type; one of
c)ResultSet.CONCUR_READ_ONLY or
ResultSet.CONCUR_UPDATABLEImplements java. Creates a |
| 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. a)Implements java. Creates a |
| public PreparedStatement | prepareStatement(String
a a, int String object that is the SQL statement to
be sent to the database; may contain one or more '?' IN
parametersone of the following b, int ResultSet
constants:
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE, or
ResultSet.TYPE_SCROLL_SENSITIVEone of the following c, int ResultSet
constants:
ResultSet.CONCUR_READ_ONLY or
ResultSet.CONCUR_UPDATABLEone of the following d)ResultSet
constants:
ResultSet.HOLD_CURSORS_OVER_COMMIT or
ResultSet.CLOSE_CURSORS_AT_COMMITImplements java. Creates a |
| public PreparedStatement | prepareStatement(String
an SQL statement that may contain one or more '?' IN
parameter placeholders a, int a flag indicating whether auto-generated keys
should be returned; one of
b)Statement.RETURN_GENERATED_KEYS or
Statement.NO_GENERATED_KEYSImplements java. Creates a default |
| public PreparedStatement | prepareStatement(String
an SQL statement that may contain one or more '?' IN
parameter placeholders a, int[] an array of column indexes indicating the columns
that should be returned from the inserted row or rows b)Implements java. Creates a default |
| public PreparedStatement | prepareStatement(String
an SQL statement that may contain one or more '?' IN
parameter placeholders a, String[] an array of column names indicating the columns
that should be returned from the inserted row or rows b)Implements java. Creates a default |
| public PreparedStatement | prepareStatement(String
an SQL statement that may contain one or more '?' IN
parameter placeholders a)Implements java. Creates a |
| public PreparedStatement | prepareStatement(String
a a, int String object that is the SQL statement to
be sent to the database; may contain one or more '?' IN
parametersa result set type; one of
b, int ResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE, or
ResultSet.TYPE_SCROLL_SENSITIVEa concurrency type; one of
c)ResultSet.CONCUR_READ_ONLY or
ResultSet.CONCUR_UPDATABLEImplements java. Creates a |
| public void | releaseSavepoint(Savepoint
the a)Savepoint object to be removedImplements java. Removes the specified |
| public void | rollback()
Implements java. Undoes all changes made in the current transaction
and releases any database locks currently held
by this |
| public void | rollback(Savepoint
the a)Savepoint object to roll back toImplements java. Undoes all changes made after the given |
| public void | setAutoCommit(boolean
true to enable auto-commit mode;
false to disable itImplements java. Sets this connection's auto-commit mode to the given state. |
| public void | setCatalog(String
the name of a catalog (subspace in this
a)Connection object's database) in which to workImplements java. Sets the given catalog name in order to select
a subspace of this |
| public void | setClientInfo(String
The name of the client info property to set a, String The value to set the client info property to. If the
value is null, the current value of the specified
property is cleared. b)Implements java. 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 a)Implements java. Sets the value of the connection's client info properties. |
| public void | setHoldability(int
a a)ResultSet holdability constant; one of
ResultSet.HOLD_CURSORS_OVER_COMMIT or
ResultSet.CLOSE_CURSORS_AT_COMMITImplements java. Changes the default holdability of |
| public void | |
| public void | setNetworkTimeout(Executor
The a, int Executor implementation which will
be used by setNetworkTimeout.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. b)Implements java. Sets the maximum period a |
| public void | setReadOnly(boolean
true enables read-only mode;
false disables itImplements java. Puts this connection in read-only mode as a hint to the driver to enable database optimizations. |
| public Savepoint | setSavepoint()
Implements java. Creates an unnamed savepoint in the current transaction and
returns the new |
| public Savepoint | setSavepoint(String
a a)String containing the name of the savepointImplements java. Creates a savepoint with the given name in the current transaction
and returns the new |
| public void | setSchema(String
the name of a schema in which to work a)Implements java. Sets the given schema name to access. |
| public void | setTransactionIsolation(int
one of the following a)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.)Implements java. Attempts to change the transaction isolation level for this
|
| public void | setTypeMap(Map<K, V>
the a)java.util.Map object to install
as the replacement for this Connection
object's default type mapImplements java. Installs the given |
| public Object | unwrap(Class<T>
A Class defining an interface that the result must implement. a)Implements java. Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy. |