Version: 7.0.0

java.sql.Connection ​

java.sql.Connection is a database connection interface.

Table 1 Support for the java.sql.Connection interface

Method Name

Return Value Type

JDBC 4 Supported

close()

void

Yes

commit()

void

Yes

createStatement()

Statement

Yes

createStatement​(int resultSetType, int resultSetConcurrency)

Statement

Yes

createStatement​(int resultSetType, int resultSetConcurrency, int resultSetHoldability)

Statement

Yes

getAutoCommit()

Boolean

Yes

getCatalog()

String

Yes

getClientInfo()

Properties

Yes

getClientInfo(String name)

String

Yes

getHoldability()

int

Yes

getNetworkTimeout()

int

Yes

getTransactionIsolation()

int

Yes

isClosed()

Boolean

Yes

isReadOnly()

Boolean

Yes

isValid​(int timeout)

boolean

Yes

prepareCall​(String sql)

CallableStatement

Yes

prepareCall​(String sql, int resultSetType, int resultSetConcurrency)

CallableStatement

Yes

prepareCall​(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)

CallableStatement

Yes

prepareStatement(String sql)

PreparedStatement

Yes

prepareStatement​(String sql, int autoGeneratedKeys)

PreparedStatement

Yes

prepareStatement(String sql, int[] columnIndexes)

PreparedStatement

Yes

prepareStatement​(String sql, int resultSetType, int resultSetConcurrency)

PreparedStatement

Yes

prepareStatement​(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)

PreparedStatement

Yes

prepareStatement​(String sql, String[] columnNames)

PreparedStatement

Yes

rollback()

void

Yes

setAutoCommit(boolean autoCommit)

void

Yes

setReadOnly​(boolean readOnly)

void

Yes

TIP

The interface uses auto-commit mode by default. If auto-commit is disabled using setAutoCommit(false), all subsequently executed statements will be wrapped in an explicit transaction. Statements that are not supported within transactions in the database cannot be executed in this mode.