The Connection
interface represents a connection with the database. SQL statements may be run in a connection session by using a Statement
object. A Connection
object is in auto-commit
mode, by default. In the auto-commit
mode, changes are committed to the database after an SQL statement is executed. The auto-commit
mode can be modified by calling the setAutoCommit(boolean autoCommit)
method. For example, auto-commit
may be set to false
:
If auto-commit
is set to false
, it would be required to commit changes by calling the commit()
method:
connection.commit();
A Connection
object can be set to read-only by calling the setReadOnly()
method:
connection.setReadOnly(true);
If a Connection
object is not required, close the connection by calling the close()
method:
connection.close();
The following table discusses the methods in JDBC 4.0 that have been added to the Connection
interface.
Method |
Description |
---|---|
|
Creates a java.sql.Array object. java.sql.Array is the Java mapping for the SQL data type, ARRAY. The SQL3 data type ARRAY stores an array in a column. |
|
Creates a Blob object. |
|
Creates a Clob object. |
|
Creates an NClob object. |
|
Creates a SQLXML object. |
|
Creates a Struct object. |
|
Tests the validity of a connection. |
|
Overloaded method returns a client info property, or a list of client info properties. Client info represents information, such as user name and application name about the client. |
|
Overloaded method sets client info. |