# java.sql.Connection

Table 1. JDBC 2.0 Connection Methods Supported
Returns | Signature
--- | ---
Statement | createStatement( int resultSetType, int resultSetConcurrency)
PreparedStatement | prepareStatement(String sql, int resultSetType, int resultSetConcurrency)
CallableStatement | prepareCall(String sql, int resultSetType, int resultSetConcurrency

#### Implementation notes

ResultSet.TYPE_FORWARD_ONLY and ResultSet.TYPE_SCROLL_INSENSITIVE are the only result set types supported. If you request TYPE_SCROLL_SENSITIVE, Derby issues an SQLWarning and returns a TYPE_SCROLL_INSENSITIVE ResultSet.

These methods support both ResultSet.CONCUR_READ_ONLY and ResultSet.CONCUR_UPDATABLE concurrencies.

Parent topic: JDBC Reference
Related concepts
Core JDBC java.sql Classes, Interfaces, and Methods
Related reference
java.sql.Driver
java.sql.DriverManager.getConnection
java.sql.Driver.getPropertyInfo
java.sql.Connection
java.sql.DatabaseMetaData
java.sql.Statement
java.sql.CallableStatement
java.sql.SQLException
java.sql.PreparedStatement
java.sql.ResultSet
java.sql.ResultSetMetaData
java.sql.SQLWarning
java.sql.SQLXML
Mapping of java.sql.Types to SQL types
java.sql.Blob and java.sql.Clob
java.sql.ResultSet
java.sql.Statement
java.sql.PreparedStatement
java.sql.CallableStatement
java.sql.DatabaseMetaData
java.sql.ResultSetMetaData
java.sql.BatchUpdateException
JDBC Package for Connected Device Configuration/Foundation Profile (JSR169)
JDBC 3.0-only features
JDBC 4.0-only features
JDBC escape syntax