A JDBC Support

This appendix provides information about JDBC compatibility and developing JDBC applications using Oracle Type 4 JDBC drivers.

JDBC Compatibility

Table A-1 shows compatibility among the JDBC specification versions, JVMs, and the Oracle Type 4 JDBC drivers.

Table A-1 JDBC Compatibility

JDBC Version Java 2 SDK Drivers Compatible?

3.0

5.0

Yes

4.0

6.0

Yes

Supported Functionality

The following tables list functionality supported for each JDBC object.

Array Object

The following table lists functionality supported for each Array object.

Table A-2 Array Object

Array Object Methods Version Introduced Supported Comments

(all)

2.0 Core

No

Array objects are not exposed or used as input.

Blob Object

The following table lists functionality supported for each Blob object.

Table A-3 Blob Object

Blob Object Methods Version Introduced Supported Comments

InputStream getBinaryStream ()

2.0 Core

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

The SQL Server and Sybase drivers support using with data types that map to the JDBCLONGVARBINARY data type.

byte[] getBytes (long, int)

2.0 Core

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

The SQL Server and Sybase drivers support using with data types that map to the LONGVARBINARY data type.

long length ()

2.0 Core

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

The SQL Server and Sybase drivers support using with data types that map to the LONGVARBINARY data type.

long position (Blob, long)

2.0 Core

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

The Informix driver requires that the pattern parameter (which specifies the Blob object designating the BLOB value for which to search) be less than or equal to a maximum value of 4096 bytes.

The SQL Server and Sybase drivers support using with data types that map to the LONGVARBINARY data type.

long position (byte[], long)

2.0 Core

Yes

The DB2 driver only supports with DB2v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

The Informix driver requires that the pattern parameter (which specifies the byte array for which to search) be less than or equal to a maximum value of 4096 bytes.

The SQL Server and Sybase drivers support using with data types that map to the LONGVARBINARY data type.

OutputStream setBinaryStream (long)

3.0

Yes

The DB2 driver only supports with DB2v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

The SQL Server and Sybase drivers support using with data types that map to the LONGVARBINARY data type.

int setBytes (long, byte[])

3.0

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

The SQL Server and Sybase drivers support using with data types that map to the LONGVARBINARY data type.

int setBytes (long, byte[], int, int)

3.0

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

The SQL Server and Sybase drivers support using with data types that map to the LONGVARBINARY data type.

void truncate (long)

3.0

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

The SQL Server and Sybase drivers support using with data types that map to the LONGVARBINARY data type.

CallableStatement Object

The following table lists functionality supported for each CallableStatement object.

Table A-4 CallableStatement Object

CallableStatement Object Methods Version Introduced Supported Comments

Array getArray (int)

2.0 Core

No

Throws "unsupported method" exception.

Array getArray (String)

3.0

No

Throws "unsupported method" exception.

Reader getCharacterStream (int)

4.0

Yes

  

Reader getCharacterStream (String)

4.0

Yes

  

BigDecimal getBigDecimal (int)

2.0 Core

Yes

N/A

BigDecimal getBigDecimal (int, int)

1.0

Yes

N/A

BigDecimal getBigDecimal (String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

Blob getBlob (int)

2.0 Core

Yes

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.

Blob getBlob (String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

boolean getBoolean (int)

1.0

Yes

N/A

boolean getBoolean (String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

byte getByte (int)

1.0

Yes

N/A

byte getByte (String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

byte [] getBytes (int)

1.0

Yes

N/A

byte [] getBytes (String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

byte getByte (int)

1.0

Yes

  

byte getByte (String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

Clob getClob (int)

2.0 Core

Yes

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARCHAR data type.

Clob getClob (String)

3.0

Yes

Supported for the SQL Server driver only using with data types that map to the JDBC LONGVARCHAR data type.

All other drivers throw "unsupported method" exception.

Date getDate (int)

1.0

Yes

N/A

Date getDate (int, Calendar)

2.0 Core

Yes

N/A

Date getDate (String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

Date getDate (String, Calendar)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

double getDouble (int)

1.0

Yes

N/A

double getDouble (String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

float getFloat (int)

1.0

Yes

N/A

float getFloat (String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

int getInt (int)

1.0

Yes

N/A

int getInt (String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

long getLong (int)

1.0

Yes

N/A

long getLong (String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

Reader getNCharacterStream (int)

4.0

Yes

  

Reader getNCharacterStream (String)

4.0

Yes

  

NClob getNClob (int)

4.0

Yes

  

NClob getNClob (String)

4.0

Yes

  

String getNString (int)

4.0

Yes

  

String getNString (String)

4.0

Yes

  

Object getObject (int)

1.0

Yes

N/A

Object getObject (int, Map)

2.0 Core

Yes

Map ignored.

Object getObject (String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

Object getObject (String, Map)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

Map ignored.

Ref getRef (int)

2.0 Core

No

Throws "unsupported method" exception.

Ref getRef (String)

3.0

No

Throws "unsupported method" exception.

short getShort (int)

1.0

Yes

N/A

short getShort (String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

SQLXML getSQLXML (int)

4.0

Yes

  

SQLXML getSQLXML (String)

4.0

Yes

  

String getString (int)

1.0

Yes

  

String getString (String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

Time getTime (int)

1.0

Yes

N/A

Time getTime (int, Calendar)

2.0 Core

Yes

N/A

Time getTime (String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

Time getTime (String, Calendar)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

Timestamp getTimestamp (int)

1.0

Yes

N/A

Timestamp getTimestamp (int, Calendar)

2.0 Core

Yes

N/A

Timestamp getTimestamp (String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

Timestamp getTimestamp (String, Calendar)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

URL getURL (int)

3.0

No

Throws "unsupported method" exception.

URL getURL (String)

3.0

No

Throws "unsupported method" exception.

boolean isWrapperFor (Class<?> iface)

4.0

Yes

  

void registerOutParameter (int, int)

1.0

Yes

N/A

void registerOutParameter (int, int, int)

1.0

Yes

N/A

void registerOutParameter (int, int, String)

2.0 Core

Yes

String/typename ignored.

void registerOutParameter (String, int)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void registerOutParameter (String, int, int)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void registerOutParameter (String, int, String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

String/typename ignored.

void setArray (int, Array)

2.0 Core

No

Throws "unsupported method" exception.

void setAsciiStream (String, InputStream)

4.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setAsciiStream (String, InputStream, int)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setAsciiStream (String, InputStream, long)

4.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setBigDecimal (String, BigDecimal)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setBinaryStream (String, InputStream)

4.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setBinaryStream (String, InputStream, int)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setBinaryStream (String, InputStream, long)

4.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setBlob (String, Blob)

4.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setBlob (String, InputStream)

4.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setBlob (String, InputStream, long)

4.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setBoolean (String, boolean)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setByte (String, byte)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setBytes (String, byte [])

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setCharacterStream (String, Reader, int)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setCharacterStream (String, InputStream, long)

4.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setClob (String, Clob)

4.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setClob (String, Reader)

4.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setClob (String, Reader, long)

4.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setDate (String, Date)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setDate (String, Date, Calendar)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setDouble (String, double)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setFloat (String, float)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setInt (String, int)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setLong (String, long)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setNCharacterStream (String, Reader, long)

4.0

Yes

  

void setNClob (String, NClob)

4.0

Yes

  

void setNClob (String, Reader)

4.0

Yes

  

void setNClob (String, Reader, long)

4.0

Yes

  

void setNString (String, String)

4.0

Yes

  

void setNull (String, int)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception

void setNull (String, int, String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setObject (String, Object)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setObject (String, Object, int)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setObject (String, Object, int, int)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setShort (String, short)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setSQLXML (String, SQLXML)

4.0

Yes

  

void setString (String, String)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setTime (String, Time)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setTime (String, Time, Calendar)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setTimestamp (String, Timestamp)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setTimestamp (String, Timestamp, Calendar)

3.0

Yes

Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.

void setURL (String, URL)

3.0

No

Throws "unsupported method" exception.

boolean wasNull ()

1.0

Yes

N/A

Clob Object

The following table lists functionality supported for each Clob object.

Table A-5 Clob Object

Clob Object Methods Version Introduced Supported Comments

void free ()

4.0

Yes

  

InputStream getAsciiStream ()

2.0 Core

Yes

The SQL Server and Sybase drivers support using with data types that map to the LONGVARCHAR data type.

Reader getCharacterStream ()

2.0 Core

Yes

The SQL Server and Sybase drivers support using with data types that map to the LONGVARCHAR data type.

Reader getCharacterStream (long, long)

4.0

yes

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARCHAR data type.

String getSubString (long, int)

2.0 Core

Yes

The SQL Server and Sybase drivers support using with data types that map to the LONGVARCHAR data type.

long length ()

2.0 Core

Yes

The SQL Server and Sybase drivers support using with data types that map to the LONGVARCHAR data type.

long position (Clob, long)

2.0 Core

Yes

The Informix driver requires that the searchStr parameter be less than or equal to a maximum value of 4096 bytes.

The SQL Server and Sybase drivers support using with data types that map to the LONGVARCHAR data type.

long position (String, long)

2.0 Core

Yes

The Informix driver requires that the searchStr parameter be less than or equal to a maximum value of 4096 bytes.

The SQL Server and Sybase drivers support using with data types that map to the LONGVARCHAR data type.

OutputStream setAsciiStream (long)

3.0 Core

Yes

The SQL Server and Sybase drivers support using with data types that map to the LONGVARCHAR data type.

Writer setCharacterStream (long)

3.0 Core

Yes

The SQL Server and Sybase drivers support using with data types that map to the LONGVARCHAR data type.

int setString (long, String)

3.0 Core

Yes

The SQL Server and Sybase drivers support using with data types that map to the LONGVARCHAR data type.

int setString (long, String, int, int)

3.0 Core

Yes

The SQL Server and Sybase drivers support using with data types that map to the LONGVARCHAR data type.

void truncate (long)

3.0 Core

Yes

The SQL Server and Sybase drivers support using with data types that map to the LONGVARCHAR data type.

Connection Object

The following table lists functionality supported for each Connection object.

Table A-6 Connection Object

Connection Object Methods Version Introduced Supported Comments

void clearWarnings ()

1.0

Yes

N/A

void close ()

1.0

Yes

When a connection is closed while a transaction is still active, that transaction is rolled back.

void commit ()

1.0

Yes

N/A

Blob createBlob ()

4.0

Yes

  

Clob createClob ()

4.0

Yes

  

NClob createNClob ()

4.0

Yes

  

SQLXML createSQLXML ()

4.0

Yes

  

Statement createStatement ()

1.0

Yes

N/A

Statement createStatement (int, int)

2.0 Core

Yes

ResultSet.TYPE_SCROLL_

SENSITIVE downgraded to TYPE_SCROLL_INSENSITIVE for the DB2 driver.

Statement createStatement (int, int, int)

3.0

No

Throws "unsupported method" exception.

boolean getAutoCommit ()

1.0

Yes

N/A

String getCatalog ()

1.0

Yes

Supported for all drivers.

String getClientInfo ()

4.0

Yes

N/A

String getClientInfo (String)

4.0

Yes

N/A

int getHoldability ()

3.0

Yes

N/A

DatabaseMetaData getMetaData ()

1.0

Yes

N/A

int getTransactionIsolation ()

1.0

Yes

N/A

Map getTypeMap ()

2.0 Core

Yes

Always returns empty java.util.HashMap.

SQLWarning getWarnings ()

1.0

Yes

N/A

boolean isClosed ()

1.0

Yes

N/A

boolean isReadOnly ()

1.0

Yes

N/A

boolean isValid ()

4.0

Yes

N/A

boolean isWrapperFor (Class<?> iface)

4.0

Yes

N/A

String nativeSQL (String)

1.0

Yes

Always returns same String as passed in.

CallableStatement prepareCall (String)

1.0

Yes

N/A

CallableStatement prepareCall (String, int, int)

2.0 Core

Yes

ResultSet.TYPE_SCROLL_

SENSITIVE downgraded to TYPE_SCROLL_INSENSITIVE for the DB2 driver.

CallableStatement prepareCall (String, int, int, int)

3.0

No

Throws "unsupported method" exception.

PreparedStatement prepareStatement (String)

1.0

Yes

N/A

PreparedStatement prepareStatement (String, int)

3.0

Yes

N/A

PreparedStatement prepareStatement (String, int, int)

2.0 Core

Yes

ResultSet.TYPE_SCROLL_

SENSITIVE downgraded to TYPE_SCROLL_INSENSITIVE for the DB2 driver.

PreparedStatement prepareStatement (String, int, int, int)

3.0

No

Throws "unsupported method" exception.

PreparedStatement prepareStatement (String, int[])

3.0

Yes

Supported for the SQL Server driver. For all other drivers, throws "unsupported method" exception.

PreparedStatement prepareStatement (String, String [])

3.0

Yes

Supported for the SQL Server driver. For all other drivers, throws "unsupported method" exception.

void releaseSavepoint (Savepoint)

3.0

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

void rollback ()

1.0

Yes

N/A

void rollback (Savepoint)

3.0

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

void setAutoCommit (boolean)

1.0

Yes

N/A

void setCatalog (String)

1.0

Yes

Supported for all drivers

String setClientInfo (Properties)

4.0

Yes

N/A

String setClientInfo (String, String)

4.0

Yes

N/A

void setHoldability (int)

3.0

Yes

Holdability parameter value is ignored.

void setReadOnly (boolean)

1.0

Yes

N/A

Savepoint setSavepoint ()

3.0

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

In addition, the DB2 driver only supports multiple nested savepoints for DB2 8.2 for Linux/UNIX/Windows.

Savepoint setSavepoint (String)

3.0

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

In addition, the DB2 driver only supports multiple nested savepoints for DB2 v8.2 for Linux/UNIX/Windows.

void setTransactionIsolation (int)

1.0

Yes

N/A

void setTypeMap (Map)

2.0 Core

Yes

Ignored.

<T> T unwrap(Class<T> iface)

4.0

Yes

  

ConnectionEventListener Object

The following table lists functionality supported for each ConnectionEventListener object.

Table A-7 ConnectionEventListener Object

ConnectionEventListener Object Methods Version Introduced Supported Comments

void connectionClosed (event))

3.0

Yes

  

void connectionErrorOccurred (event)

3.0

Yes

  

ConnectionPoolDataSource Object

The following table lists functionality supported for each ConnectionPoolDataSource object.

Table A-8 ConnectionPoolDataSource Object

ConnectionPoolDataSource Object Methods Version Introduced Supported Comments

int getLoginTimeout ()

2.0 Optional

Yes

  

PrintWriter getLogWriter ()

2.0 Optional

Yes

  

PooledConnection getPooledConnection ()

2.0 Optional

Yes

  

PooledConnection getPooledConnection (String, String)

2.0 Optional

Yes

  

void setLoginTimeout (int)

2.0 Optional

Yes

  

void setLogWriter (PrintWriter)

2.0 Optional

Yes

  

DatabaseMetaData Object

The following table lists functionality supported for each DatabaseMetaData object.

Table A-9 DababaseMetaData Object

DatabaseMetaData Object Methods Version Introduced Supported Comments

boolean autoCommitFailureClosesAllResultSets ()

4.0

Yew

  

boolean allProceduresAreCallable ()

1.0

Yes

N/A

boolean allTablesAreSelectable ()

1.0

Yes

N/A

boolean dataDefinitionCausesTransaction

Commit ()

1.0

Yes

N/A

boolean dataDefinitionIgnoredInTransactions ()

1.0

Yes

N/A

boolean deletesAreDetected (int)

2.0 Core

Yes

N/A

boolean doesMaxRowSizeIncludeBlobs ()

1.0

Yes

Not supported by the SQL Server and Sybase drivers.

getAttributes (String, String, String, String)

3.0

Yes

Empty result set is returned.

ResultSet getBestRowIdentifier (String, String, String, int, boolean)

1.0

Yes

N/A

ResultSet getCatalogs ()

1.0

Yes

N/A

String getCatalogSeparator ()

1.0

Yes

N/A

String getCatalogTerm ()

1.0

Yes

N/A

String getClientInfoProperties ()

4.0

Yes

N/A

ResultSet getColumnPrivileges (String, String, String, String)

1.0

Yes

N/A

ResultSet getColumns (String, String, String, String)

1.0

Yes

N/A

Connection getConnection ()

2.0 Core

Yes

N/A

ResultSet getCrossReference (String, String, String, String, String, String)

1.0

Yes

N/A

ResultSet getFunctions ()

4.0

Yes

  

ResultSet getFunctionColumns ()

4.0

Yes

  

int getDatabaseMajorVersion ()

3.0

Yes

N/A

int getDatabaseMinorVersion ()

3.0

Yes

N/A

String getDatabaseProductName ()

1.0

Yes

For Sybase, returns "SQL Server," which is the string returned internally by the Sybase database server. This value may not be the same return as seen with other JDBC drivers, including the Sybase JConnect JDBC drivers.

String getDatabaseProductVersion ()

1.0

Yes

N/A

int getDefaultTransactionIsolation ()

1.0

Yes

N/A

int getDriverMajorVersion ()

1.0

Yes

N/A

int getDriverMinorVersion ()

1.0

Yes

N/A

String getDriverName ()

1.0

Yes

N/A

String getDriverVersion ()

1.0

Yes

N/A

ResultSet getExportedKeys (String, String, String)

1.0

Yes

N/A

String getExtraNameCharacters ()

1.0

Yes

N/A

String getIdentifierQuoteString ()

1.0

Yes

N/A

ResultSet getImportedKeys (String, String, String)

1.0

Yes

N/A

ResultSet getIndexInfo (String, String, String, boolean, boolean)

1.0

Yes

N/A

int getJDBCMajorVersion ()

3.0

Yes

N/A

int getJDBCMinorVersion ()

3.0

Yes

N/A

int getMaxBinaryLiteralLength ()

1.0

Yes

N/A

int getMaxCatalogNameLength ()

1.0

Yes

N/A

int getMaxCharLiteralLength ()

1.0

Yes

N/A

int getMaxColumnNameLength ()

1.0

Yes

N/A

int getMaxColumnsInGroupBy ()

1.0

Yes

N/A

int getMaxColumnsInIndex ()

1.0

Yes

N/A

int getMaxColumnsInOrderBy ()

1.0

Yes

N/A

int getMaxColumnsInSelect ()

1.0

Yes

N/A

int getMaxColumnsInTable ()

1.0

Yes

N/A

int getMaxConnections ()

1.0

Yes

N/A

int getMaxCursorNameLength ()

1.0

Yes

N/A

int getMaxIndexLength ()

1.0

Yes

N/A

int getMaxProcedureNameLength ()

1.0

Yes

N/A

int getMaxRowSize ()

1.0

Yes

N/A

int getMaxSchemaNameLength ()

1.0

Yes

N/A

int getMaxStatementLength ()

1.0

Yes

N/A

int getMaxStatements ()

1.0

Yes

N/A

int getMaxTableNameLength ()

1.0

Yes

N/A

int getMaxTablesInSelect ()

1.0

Yes

N/A

int getMaxUserNameLength ()

1.0

Yes

N/A

String getNumericFunctions ()

1.0

Yes

N/A

ResultSet getPrimaryKeys (String, String, String)

1.0

Yes

N/A

ResultSet getProcedureColumns (String, String, String, String)

1.0

Yes

N/A

ResultSet getProcedures (String, String, String)

1.0

Yes

N/A

String getProcedureTerm ()

1.0

Yes

N/A

int getResultSetHoldability ()

3.0

Yes

N/A

ResultSet getSchemas ()

1.0

Yes

N/A

ResultSet getSchemas (catalog, pattern)

4.0

Yes

  

String getSchemaTerm ()

1.0

Yes

N/A

String getSearchStringEscape ()

1.0

Yes

N/A

String getSQLKeywords ()

1.0

Yes

N/A

int getSQLStateType ()

3.0

Yes

N/A

String getStringFunctions ()

1.0

Yes

N/A

ResultSet getSuperTables (String, String, String)

3.0

Yes

Empty result set is returned.

ResultSet getSuperTypes (String, String, String)

3.0

Yes

Empty result set is returned.

String getSystemFunctions ()

1.0

Yes

N/A

ResultSet getTablePrivileges (String, String, String)

1.0

Yes

N/A

ResultSet getTables (String, String, String, String [])

1.0

Yes

N/A

ResultSet getTableTypes ()

1.0

Yes

N/A

String getTimeDateFunctions ()

1.0

Yes

N/A

ResultSet getTypeInfo ()

1.0

Yes

N/A

ResultSet getUDTs (String, String, String,

int [])

2.0 Core

No

Always returns empty ResultSet.

String getURL ()

1.0

Yes

N/A

String getUserName ()

1.0

Yes

N/A

ResultSet getVersionColumns (String, String, String)

1.0

Yes

N/A

boolean insertsAreDetected (int)

2.0 Core

Yes

N/A

boolean isCatalogAtStart ()

1.0

Yes

N/A

boolean isReadOnly ()

1.0

Yes

N/A

boolean locatorsUpdateCopy ()

3.0

Yes

N/A

boolean nullPlusNonNullIsNull ()

1.0

Yes

N/A

boolean nullsAreSortedAtEnd ()

1.0

Yes

N/A

boolean nullsAreSortedAtStart ()

1.0

Yes

N/A

boolean nullsAreSortedHigh ()

1.0

Yes

N/A

boolean nullsAreSortedLow ()

1.0

Yes

N/A

boolean othersDeletesAreVisible (int)

2.0 Core

Yes

N/A

boolean othersInsertsAreVisible (int)

2.0 Core

Yes

N/A

boolean othersUpdatesAreVisible (int)

2.0 Core

Yes

N/A

boolean ownDeletesAreVisible (int)

2.0 Core

Yes

N/A

boolean ownInsertsAreVisible (int)

2.0 Core

Yes

N/A

boolean ownUpdatesAreVisible (int)

2.0 Core

Yes

N/A

boolean storesLowerCaseIdentifiers ()

1.0

Yes

N/A

boolean storesLowerCaseQuoted

Identifiers ()

1.0

Yes

N/A

boolean storesMixedCaseIdentifiers ()

1.0

Yes

N/A

boolean storesMixedCaseQuoted

Identifiers ()

1.0

Yes

N/A

boolean storesUpperCaseIdentifiers ()

1.0

Yes

N/A

boolean storesUpperCaseQuoted

Identifiers ()

1.0

Yes

N/A

boolean supportsAlterTableWith

AddColumn ()

1.0

Yes

N/A

boolean supportsAlterTableWith

DropColumn ()

1.0

Yes

N/A

boolean supportsANSI92EntryLevelSQL ()

1.0

Yes

N/A

boolean supportsANSI92FullSQL ()

1.0

Yes

N/A

boolean supportsANSI92Intermediate

SQL ()

1.0

Yes

N/A

boolean supportsBatchUpdates ()

2.0 Core

Yes

N/A

boolean supportsCatalogsInData

Manipulation ()

1.0

Yes

N/A

boolean supportsCatalogsInIndex

Definitions ()

1.0

Yes

N/A

boolean supportsCatalogsInPrivilege

Definitions ()

1.0

Yes

N/A

boolean supportsCatalogsInProcedure

Calls ()

1.0

Yes

N/A

boolean supportsCatalogsInTable

Definitions ()

1.0

Yes

N/A

boolean supportsColumnAliasing ()

1.0

Yes

N/A

boolean supportsConvert ()

1.0

Yes

N/A

boolean supportsConvert (int, int)

1.0

Yes

N/A

boolean supportsCoreSQLGrammar ()

1.0

Yes

N/A

boolean supportsCorrelatedSubqueries ()

1.0

Yes

N/A

boolean supportsDataDefinitionAndData

ManipulationTransactions ()

1.0

Yes

N/A

boolean supportsDataManipulation

TransactionsOnly ()

1.0

Yes

N/A

boolean supportsDifferentTableCorrelation

Names ()

1.0

Yes

N/A

boolean supportsExpressionsIn

OrderBy ()

1.0

Yes

N/A

boolean supportsExtendedSQLGrammar ()

1.0

Yes

N/A

boolean supportsFullOuterJoins ()

1.0

Yes

N/A

boolean supportsGetGeneratedKeys ()

3.0

Yes

N/A

boolean supportsGroupBy ()

1.0

Yes

N/A

boolean supportsGroupByBeyondSelect ()

1.0

Yes

N/A

boolean supportsGroupByUnrelated ()

1.0

Yes

N/A

boolean supportsIntegrityEnhancement

Facility ()

1.0

Yes

N/A

boolean supportsLikeEscapeClause ()

1.0

Yes

N/A

boolean supportsLimitedOuterJoins ()

1.0

Yes

N/A

boolean supportsMinimumSQLGrammar ()

1.0

Yes

N/A

boolean supportsMixedCaseIdentifiers ()

1.0

Yes

N/A

boolean supportsMixedCaseQuoted

Identifiers ()

1.0

Yes

N/A

boolean supportsMultipleOpenResults ()

3.0

Yes

N/A

boolean supportsMultipleResultSets ()

1.0

Yes

N/A

boolean supportsMultipleTransactions ()

1.0

Yes

N/A

boolean supportsNamedParameters ()

3.0

Yes

N/A

boolean supportsNonNullableColumns ()

1.0

Yes

N/A

boolean supportsOpenCursorsAcross

Commit ()

1.0

Yes

N/A

boolean supportsOpenCursorsAcross

Rollback ()

1.0

Yes

N/A

boolean supportsOpenStatementsAcross

Commit ()

1.0

Yes

N/A

boolean supportsOpenStatementsAcross

Rollback ()

1.0

Yes

N/A

boolean supportsOrderByUnrelated ()

1.0

Yes

N/A

boolean supportsOuterJoins ()

1.0

Yes

N/A

boolean supportsPositionedDelete ()

1.0

Yes

N/A

boolean supportsPositionedUpdate ()

1.0

Yes

N/A

boolean supportsResultSetConcurrency (int, int)

2.0 Core

Yes

N/A

boolean supportsResultSetHoldability (int)

3.0

Yes

N/A

boolean supportsResultSetType (int)

2.0 Core

Yes

N/A

boolean supportsSavePoints ()

3.0

Yes

N/A

boolean supportsSchemasInData

Manipulation ()

1.0

Yes

N/A

boolean supportsSchemasInIndex

Definitions ()

1.0

Yes

N/A

boolean supportsSchemasIn

PrivilegeDefinitions ()

1.0

Yes

N/A

boolean supportsSchemasInProcedure

Calls ()

1.0

Yes

N/A

boolean supportsSchemasInTable

Definitions ()

1.0

Yes

N/A

boolean supportsSelectForUpdate ()

1.0

Yes

N/A

boolean supportsStoredFunctionsUsingCallSyntax ()

4.0

Yes

  

boolean supportsStoredProcedures ()

1.0

Yes

N/A

boolean supportsSubqueriesIn

Comparisons ()

1.0

Yes

N/A

boolean supportsSubqueriesInExists ()

1.0

Yes

N/A

boolean supportsSubqueriesInIns ()

1.0

Yes

N/A

boolean supportsSubqueriesIn

Quantifieds ()

1.0

Yes

N/A

boolean supportsTableCorrelationNames ()

1.0

Yes

N/A

boolean supportsTransactionIsolationLevel (int)

1.0

Yes

N/A

boolean supportsTransactions ()

1.0

Yes

N/A

boolean supportsUnion ()

1.0

Yes

N/A

boolean supportsUnionAll ()

1.0

Yes

N/A

boolean updatesAreDetected (int)

2.0 Core

Yes

N/A

boolean usesLocalFilePerTable ()

1.0

Yes

N/A

boolean usesLocalFiles ()

1.0

Yes

N/A

Data Source Object

The following table lists functionality supported for each data source object.

Note:

The DataSource object implements the javax.naming.Referenceable and java.io.Serializable interfaces.

Table A-10 Data Source Object

Data Source Object Methods Version Introduced Supported Comments

Connection getConnection ()

2.0 Optional

Yes

N/A

Connection getConnection (String, String)

1.0

Yes

N/A

int getLoginTimeout ()

1.0

Yes

N/A

PrintWriter getLogWriter ()

1.0

Yes

N/A

boolean isWrapperFor (Class<?> iface)

1.0

Yes

N/A

void setLoginTimeout (int)

      

void setLogWriter (PrintWriter)

      

<T> T unwrap(Class<T> iface)

      

Driver Object

The following table lists functionality supported for each Driver object.

Table A-11 Driver Object

Driver Object Methods Version Introduced Supported Comments

boolean acceptsURL (String)

1.0

Yes

N/A

Connection connect (String, Properties)

1.0

Yes

N/A

int getMajorVersion

()

1.0

Yes

N/A

int getMinorVersion ()

1.0

Yes

N/A

DriverPropertyInfo [] getPropertyInfo (String, Properties)

1.0

Yes

N/A

ParameterMetaData Object

The following table lists functionality supported for each ParameterMetaData object.

Table A-12 ParameterMetaData Object

ParameterMetaData Object Methods Version Introduced Supported Comments

String getParameterClassName (int)

3.0

Yes

The DB2 driver supports parameter metadata for stored procedures for DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

int getParameterCount ()

3.0

Yes

N/A

int getParameterMode (int)

3.0

Yes

The DB2 driver supports parameter metadata for stored procedures for DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

int getParameterType (int)

3.0

Yes

The DB2 driver supports parameter metadata for stored procedures for DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

String getParameterTypeName (int)

3.0

Yes

The DB2 driver supports parameter metadata for stored procedures for DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

int getPrecision (int)

3.0

Yes

The DB2 driver supports parameter metadata for stored procedures for DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

int getScale (int)

3.0

Yes

The DB2 driver supports parameter metadata for stored procedures for DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

int isNullable (int)

3.0

Yes

The DB2 driver supports parameter metadata for stored procedures for DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

boolean isSigned (int)

3.0

Yes

The DB2 driver supports parameter metadata for stored procedures for DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

boolean isWrapperFor (Class<?> iface)

4.0

Yes

  

boolean jdbcCompliant ()

1.0

Yes

N/A

<T> T unwrap(Class<T> iface)

4.0

Yes

  

PooledConnection Object

The following table lists functionality supported for each PooledConnection object.

Table A-13 PooledConnection Object

PooledConnection Object Methods Version Introduced Supported Comments

void addConnectionEventListener (ConnectionEventListener)

2.0 Optional

Yes

N/A

void addStatementEventListener (listener)

4.0

Yes

N/A

void close()

2.0 Optional

Yes

N/A

Connection getConnection()

2.0 Optional

Yes

A pooled connection object can have only one Connection object open (the one most recently created). The purpose of allowing the server (PoolManager implementation) to invoke this a second time is to give an application server a way to take a connection away from an application and give it to another user (a rare occurrence). The drivers do not support the "reclaiming" of connections and will throw an exception.

void removeConnectionEvent Listener (ConnectionEventListener)

2.0 Optional

Yes

N/A

void removeStatementEventListener (listener)

4.0

Yes

  

PreparedStatement Object

The following table lists functionality supported for each PreparedStatement object.

Table A-14 PreparedStatement Object

PreparedStatement Object Methods Version Introduced Supported Comments

void addBatch ()

2.0 Core

Yes

N/A

void clearParameters ()

1.0

Yes

N/A

boolean execute ()

1.0

Yes

N/A

ResultSet executeQuery ()

1.0

Yes

N/A

int executeUpdate ()

1.0

Yes

N/A

ResultSetMetaData getMetaData ()

2.0 Core

Yes

N/A

ParameterMetaData getParameterMetaData ()

3.0

Yes

N/A

boolean isWrapperFor (Class<?> iface)

4.0

Yes

  

void setArray (int, Array)

2.0 Core

No

Throws "unsupported method" exception.

void setAsciiStream (int, InputStream)

4.0

Yes

  

void setAsciiStream (int, InputStream, int)

1.0

Yes

N/A

void setAsciiStream (int, InputStream, long)

4.0

Yes

  

void setBigDecimal (int, BigDecimal)

1.0

Yes

N/A

void setBinaryStream (int, InputStream)

4.0

Yes

When used with Blobs, the DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

void setBinaryStream (int, InputStream, int)

1.0

Yes

When used with Blobs, the DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

void setBinaryStream (int, InputStream, long)

4.0

Yes

When used with Blobs, the DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

void setBlob (int, Blob)

2.0 Core

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.

void setBlob (int, InputStream)

4.0

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.

void setBlob (int, InputStream, long)

4.0

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.

void setBoolean (int, boolean)

1.0

Yes

N/A

void setByte (int, byte)

1.0

Yes

N/A

void setBytes (int, byte [])

1.0

Yes

When used with Blobs, the DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows,

DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

void setCharacterStream (int, Reader)

4.0

Yes

  

void setCharacterStream (int, Reader, int)

2.0 Core

Yes

N/A

void setCharacterStream (int, Reader, long)

4.0

Yes

  

void setClob (int, Clob)

2.0 Core

Yes

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARCHAR data type.

void setDate (int, Date)

1.0

Yes

N/A

void setDate (int, Date, Calendar)

2.0 Core

Yes

N/A

void setClob (int, Reader)

4.0

Yes

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARCHAR data type.

void setClob (int, Reader, long)

4.0

Yes

  

void setDouble (int, double)

1.0

Yes

N/A

void setDate (int, Date)

4.0

Yes

  

void setFloat (int, float)

1.0

Yes

N/A

void setInt (int, int)

1.0

Yes

N/A

void setDate (int, Date, Calendar)

2.0 Core

Yes

  

void setLong (int, long)

1.0

Yes

N/A

void setNull (int, int)

1.0

Yes

N/A

void setNull (int, int, String)

2.0 Core

Yes

N/A

void setObject (int, Object)

1.0

Yes

N/A

void setObject (int, Object, int)

1.0

Yes

N/A

void setObject (int, Object, int, int)

1.0

Yes

N/A

void setQueryTimeout (int)

1.0

Yes

The DB2 driver supports setting a timeout value, in seconds, for a statement with DB2 v8.x and higher for Linux/UNIX/Windows and DB2 v8.1 for z/OS. If the execution of the statement exceeds the timeout value, the statement is timed out by the database server, and the driver throws an exception indicating that the statement was timed out. The DB2 driver throws an "unsupported method" exception with other DB2 versions.

The Informix driver throws an "unsupported method" exception.

The SQL Server and Sybase drivers support setting a timeout value, in seconds, for a statement. If the execution of the statement exceeds the timeout value, the statement is timed out by the database server, and the driver throws an exception indicating that the statement was timed out.

void setRef (int, Ref)

2.0 Core

No

Throws "unsupported method" exception.

void setShort (int, short)

1.0

Yes

N/A

)

1.0

Yes

N/A

void setSCLXML

      

void setTime (int, Time)

1.0

Yes

N/A

void setTime (int, Time, Calendar)

2.0 Core

Yes

N/A

void setTimestamp (int, Timestamp)

1.0

Yes

N/A

void setTimestamp (int, Timestamp, Calendar)

2.0 Core

Yes

N/A

void setUnicodeStream (int, InputStream, int)

1.0

No

Throws "unsupported method" exception. This method was deprecated in JDBC 2.0.

void setURL (int, URL)

3.0

No

Throws "unsupported method" exception.

Ref Object

The following table lists functionality supported for each Ref object.

Table A-15 Ref Object

Ref Object Methods Version Introduced Supported Comments

(all)

2.0 Core

No

N/A

ResultSet Object

The following table lists functionality supported for each ResultSet object.

Table A-16 ResultSet Object

ResultSet Object Methods Version Introduced Supported Comments

boolean absolute (int)

2.0 Core

Yes

N/A

void afterLast ()

2.0 Core

Yes

N/A

void beforeFirst ()

2.0 Core

Yes

N/A

void cancelRowUpdates ()

2.0 Core

Yes

N/A

void clearWarnings ()

1.0

Yes

N/A

void close ()

1.0

Yes

N/A

void deleteRow ()

2.0 Core

Yes

N/A

int findColumn (String)

1.0

Yes

N/A

boolean first ()

2.0 Core

Yes

N/A

Array getArray (int)

2.0 Core

No

Throws "unsupported method" exception.

Array getArray (String)

2.0 Core

No

Throws "unsupported method" exception.

InputStream getAsciiStream (int)

1.0

Yes

N/A

InputStream getAsciiStream (String)

1.0

Yes

N/A

BigDecimal getBigDecimal (int)

2.0 Core

Yes

N/A

BigDecimal getBigDecimal (int, int)

1.0

Yes

N/A

BigDecimal getBigDecimal (String)

2.0 Core

Yes

N/A

BigDecimal getBigDecimal (String, int)

1.0

Yes

N/A

InputStream getBinaryStream (int)

1.0

Yes

The DB2 driver supports for all DB2 versions when retrieving BINARY, VARBINARY, and LONGVARBINARY data. The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries when retrieving BLOB data.

InputStream getBinaryStream (String)

1.0

Yes

The DB2 driver supports for all DB2 versions when retrieving BINARY, VARBINARY, and LONGVARBINARY data. The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries when retrieving BLOB data.

Blob getBlob (int)

2.0 Core

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.

Blob getBlob (String)

2.0 Core

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.

boolean getBoolean (int)

1.0

Yes

N/A

boolean getBoolean (String)

1.0

Yes

N/A

byte getByte (int)

1.0

Yes

N/A

byte getByte (String)

1.0

Yes

N/A

byte [] getBytes (int)

1.0

Yes

The DB2 driver supports for all DB2 versions when retrieving BINARY, VARBINARY, and LONGVARBINARY data. The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries when retrieving BLOB data.

byte [] getBytes (String)

1.0

Yes

The DB2 driver supports for all DB2 versions when retrieving BINARY, VARBINARY, and LONGVARBINARY data. The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries when retrieving BLOB data.

Reader getCharacterStream (int)

2.0 Core

Yes

N/A

Reader getCharacterStream (String)

2.0 Core

Yes

N/A

Clob getClob (int)

2.0 Core

Yes

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARCHAR data type.

Clob getClob (String)

2.0 Core

Yes

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARCHAR data type.

int getConcurrency ()

2.0 Core

Yes

N/A

String getCursorName ()

1.0

No

Throws "unsupported method" exception.

Date getDate (int)

1.0

Yes

N/A

Date getDate (int, Calendar)

2.0 Core

Yes

N/A

Date getDate (String)

1.0

Yes

N/A

Date getDate (String, Calendar)

2.0 Core

Yes

N/A

double getDouble (int)

1.0

Yes

N/A

double getDouble (String)

1.0

Yes

N/A

int getFetchDirection ()

2.0 Core

Yes

N/A

int getFetchSize ()

2.0 Core

Yes

N/A

float getFloat (int)

1.0

Yes

N/A

float getFloat (String)

1.0

Yes

N/A

int getHoldability ()

1

Yes

  

int getInt (int)

1.0

Yes

N/A

int getInt (String)

1.0

Yes

N/A

long getLong (int)

1.0

Yes

N/A

long getLong (String)

1.0

Yes

N/A

ResultSetMetaData getMetaData ()

1.0

Yes

N/A

Reader getNCharacterStream (int)

4.0

Yes

  

Reader getNCharacterStream (String)

4.0

Yes

  

NClob getNClob (int)4

4.0

Yes

  

NClob getNClob (String)

4.0

Yes

  

String getNString (int)

4.0

Yes

  

String getNString (String)

4.0

Yes

  

Object getObject (int)

1.0

Yes

Returns a Long object when called on DB2 Bigint columns.

Object getObject (int, Map)

2.0 Core

Yes

N/A

Object getObject (String)

1.0

Yes

N/A

Object getObject (String, Map)

2.0 Core

Yes

Map ignored.

Ref getRef (int)

2.0 Core

No

Throws "unsupported method" exception.

Ref getRef (String)

2.0 Core

No

Throws "unsupported method" exception.

int getRow ()

2.0 Core

Yes

N/A

short getShort (int)

1.0

Yes

N/A

short getShort (String)

1.0

Yes

N/A

SQLXML getSQLXML (int)

4.0

Yes

  

SQLXML getSQLXML (String)

4.0

Yes

  

Statement getStatement ()

2.0 Core

Yes

N/A

String getString (int)

1.0

Yes

N/A

String getString (String)

1.0

Yes

N/A

Time getTime (int)

1.0

Yes

N/A

Time getTime (int, Calendar)

2.0 Core

Yes

N/A

Time getTime (String)

1.0

Yes

N/A

Time getTime (String, Calendar)

2.0 Core

Yes

N/A

Timestamp getTimestamp (int)

1.0

Yes

N/A

Timestamp getTimestamp (int, Calendar)

2.0 Core

Yes

N/A

Timestamp getTimestamp (String)

1.0

Yes

N/A

Timestamp getTimestamp (String, Calendar)

2.0 Core

Yes

N/A

int getType ()

2.0 Core

Yes

N/A

InputStream getUnicodeStream (int)

1.0

No

Throws "unsupported method" exception. This method was deprecated in JDBC 2.0.

InputStream getUnicodeStream (String)

1.0

No

Throws "unsupported method" exception. This method was deprecated in JDBC 2.0.

URL getURL (int)

3.0

No

Throws "unsupported method" exception.

URL getURL (String)

3.0

No

Throws "unsupported method" exception.

SQLWarning getWarnings ()

1.0

Yes

N/A

void insertRow ()

2.0 Core

Yes

N/A

boolean isAfterLast ()

2.0 Core

Yes

N/A

boolean isBeforeFirst ()

2.0 Core

Yes

N/A

boolean isClosed ()

4.0

Yes

  

boolean isFirst ()

2.0 Core

Yes

N/A

boolean isLast ()

2.0 Core

Yes

N/A

boolean isWrapperFor (Class<?> iface)

4.0

Yes

  

boolean last ()

2.0 Core

Yes

N/A

void moveToCurrentRow ()

2.0 Core

Yes

N/A

void moveToInsertRow ()

2.0 Core

Yes

N/A

boolean next ()

1.0

Yes

N/A

boolean previous ()

2.0 Core

Yes

N/A

void refreshRow ()

2.0 Core

Yes

N/A

boolean relative (int)

2.0 Core

Yes

N/A

boolean rowDeleted ()

2.0 Core

Yes

N/A

boolean rowInserted ()

2.0 Core

Yes

N/A

boolean rowUpdated ()

2.0 Core

Yes

N/A

void setFetchDirection (int)

2.0 Core

Yes

N/A

void setFetchSize (int)

2.0 Core

Yes

N/A

void updateArray (int, Array)

3.0

No

Throws "unsupported method" exception.

void updateArray (String, Array)

3.0

No

Throws "unsupported method" exception.

void updateAsciiStream (int, InputStream, int)

2.0 Core

Yes

N/A

void updateAsciiStream (int, InputStream, long)

4.0

Yes

  

void updateAsciiStream (String, InputStream)

4.0

Yes

  

void updateAsciiStream (String, InputStream, int)

2.0 Core

Yes

N/A

void updateAsciiStream (String, InputStream, long)

4.0

Yes

  

void updateBigDecimal (int, BigDecimal)

2.0 Core

Yes

N/A

void updateBigDecimal (String, BigDecimal)

2.0 Core

Yes

N/A

void updateBinaryStream (int, InputStream)

4.0

Yes

  

void updateBinaryStream (int, InputStream, int)

2.0 Core

Yes

N/A

void updateBinaryStream (int, InputStream, long)

4.0

Yes

  

void updateBinaryStream (String, InputStream)

4.0

Yes

  

void updateBinaryStream (String, InputStream, int)

2.0 Core

Yes

N/A

void updateBinaryStream (String, InputStream, long)

4.0

Yes

  

void updateBlob (int, Blob)

3.0

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.

void updateBlob (int, InputStream)

4.0

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.

void updateBlob (int, InputStream)

4.0

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.

void updateBlob (String, Blob)

3.0

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.

void updateBlob (String, InputStream)

4.0

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.

void updateBlob (String, InputStream, long)

4.0

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.

void updateBoolean (int, boolean)

2.0 Core

Yes

N/A

void updateBoolean (String, boolean)

2.0 Core

Yes

N/A

void updateByte (int, byte)

2.0 Core

Yes

N/A

void updateByte (String, byte)

2.0 Core

Yes

N/A

void updateBytes (int, byte [])

2.0 Core

Yes

N/A

void updateBytes (String, byte [])

2.0 Core

Yes

N/A

void updateCharacterStream (int, Reader)

4.0

Yes

  

void updateCharacterStream (int, Reader, int)

2.0 Core

Yes

N/A

void updateCharacterStream (int, Reader, long)

4.0

Yes

  

void updateCharacterStream (String, Reader)

4.0

Yes

  

void updateCharacterStream (String, Reader, int)

2.0 Core

Yes

N/A

void updateCharacterStream (String, Reader, long)

4.0

Yes

  

void updateClob (int, Clob)

3.0

Yes

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARCHAR data type

void updateClob (int, Reader)

4.0

Yes

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARCHAR data type.

void updateClob (int, Reader, long)

4.0

Yes

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARCHAR data type.

void updateClob (String, Clob)

3.0

Yes

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARCHAR data type

void updateClob (String, Reader)

4.0

Yes

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARCHAR data type.

void updateClob (String, Reader, long)

4.0

Yes

The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARCHAR data type.

void updateDate (int, Date)

2.0 Core

Yes

N/A

void updateDate (String, Date)

2.0 Core

Yes

N/A

void updateDouble (int, double)

2.0 Core

Yes

N/A

void updateDouble (String, double)

2.0 Core

Yes

N/A

void updateFloat (int, float)

2.0 Core

Yes

N/A

void updateFloat (String, float)

2.0 Core

Yes

N/A

void updateInt (int, int)

2.0 Core

Yes

N/A

void updateInt (String, int)

2.0 Core

Yes

N/A

void updateLong (int, long)

2.0 Core

Yes

N/A

void updateLong (String, long)

2.0 Core

Yes

N/A

void updateNCharacterStream (int, Reader)

4.0

Yes

  

void updateNCharacterStream (int, Reader, long)

4.0

Yes

  

void updateNCharacterStream (String, Reader)

4.0

Yes

  

void updateNCharacterStream (String, Reader, long)

4.0

Yes

  

void updateNClob (int, NClob)

4.0

Yes

  

void updateNClob (int, Reader)

4.0

Yes

  

void updateNClob (int, Reader, long)

4.0

Yes

  

void updateNClob (String, NClob)

4.0

Yes

  

void updateNClob (String, Reader)

4.0

Yes

  

void updateNClob (String, Reader, long)

4.0

Yes

  

void updateNString (int, String)

4.0

Yes

  

void updateNString (String, String)

4.0

Yes

  

void updateNull (int)

2.0 Core

Yes

N/A

void updateNull (String)

2.0 Core

Yes

N/A

void updateObject (int, Object)

2.0 Core

Yes

N/A

void updateObject (int, Object, int)

2.0 Core

Yes

N/A

void updateObject (String, Object)

2.0 Core

Yes

N/A

void updateObject (String, Object, int)

2.0 Core

Yes

N/A

void updateRef (int, Ref)

3.0

No

Throws "unsupported method" exception.

void updateRef (String, Ref)

3.0

No

Throws "unsupported method" exception.

void updateRow ()

2.0 Core

Yes

N/A

void updateShort (int, short)

2.0 Core

Yes

N/A

void updateShort (String, short)

2.0 Core

Yes

N/A

void updateSQLXML (int, SQLXML)

4.0

Yes

  

void updateSQLXML (String, SQLXML)

4.0

Yes

  

void updateString (int, String)

2.0 Core

Yes

N/A

void updateString (String, String)

2.0 Core

Yes

N/A

void updateTime (int, Time)

2.0 Core

Yes

N/A

void updateTime (String, Time)

2.0 Core

Yes

N/A

void updateTimestamp (int, Timestamp)

2.0 Core

Yes

N/A

void updateTimestamp (String, Timestamp)

2.0 Core

Yes

N/A

boolean wasNull ()

1.0

Yes

N/A

ResultSetMetaData Object

The following table lists functionality supported for each ResultSetMetaData object.

Table A-17 ResultSetMetaData Object

ResultSetMetaData Object Methods Version Introduced Supported Comments

String getCatalogName (int)

1.0

Yes

N/A

String getColumnClassName (int)

2.0 Core

Yes

N/A

int getColumnCount ()

1.0

Yes

N/A

int getColumnDisplaySize (int)

1.0

Yes

N/A

String getColumnLabel (int)

1.0

Yes

N/A

String getColumnName (int)

1.0

Yes

N/A

int getColumnType (int)

1.0

Yes

N/A

String getColumnTypeName (int)

1.0

Yes

N/A

int getPrecision (int)

1.0

Yes

N/A

int getScale (int)

1.0

Yes

N/A

String getSchemaName (int)

1.0

Yes

N/A

String getTableName (int)

1.0

Yes

For versions 3.4 and higher:

  • By default, getTableName returns an empty string for Informix, and SQL Server Type 4 drivers.

  • To return a table name for the Informix, and SQL Server Type 4 drivers, add the following property to the connection pool Properties field: ResultsetMetaDataOptions=1

See "JDBC Data Source: Configuration: Connection Pool" in the Administration Console Online Help.

boolean isAutoIncrement (int)

1.0

Yes

N/A

boolean isCaseSensitive (int)

1.0

Yes

N/A

boolean isCurrency (int)

1.0

Yes

N/A

boolean isDefinitelyWritable (int)

1.0

Yes

N/A

int isNullable (int)

1.0

Yes

N/A

boolean isReadOnly (int)

1.0

Yes

N/A

boolean isSearchable (int)

1.0

Yes

N/A

boolean isSigned (int)

1.0

Yes

N/A

boolean isWrapperFor (Class<?> iface)

4.0

Yes

  

boolean isWritable (int)

1.0

Yes

N/A

<T> T unwrap(Class<T> iface)

4.0

Yes

  

RowSet Object

The following table lists functionality supported for each RowSet object.

Table A-18 RowSet Object

RowSet Object Methods Version Introduced Supported Comments

(all)

2.0 Optional

No

  

SavePoint Object

The following table lists functionality supported for each SavePoint object.

Table A-19 SavePoint Object

SavePoint Object Methods Version Introduced Supported Comments

(all)

3.0

Yes

The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.

Statement Object

The following table lists functionality supported for each Statement object.

Table A-20 Statement Object

Statement Object Methods Version Introduced Supported Comments

void addBatch (String)

2.0 Core

Yes

Throws "invalid method call" exception for PreparedStatement and CallableStatement.

void cancel ()

1.0

Yes

The DB2 driver cancels the execution of the statement with DB2 v8.1 and v8.2 for Linux/UNIX/Windows and DB2 v8.1 for z/OS. If the statement is cancelled by the database server, the driver throws an exception indicating that it was cancelled. The DB2 driver throws an "unsupported method" exception with other DB2 versions.

The Informix driver throws an "unsupported method" exception.

The SQL Server, and Sybase drivers cancel the execution of the statement. If the statement is cancelled by the database server, the driver throws an exception indicating that it was cancelled.

void clearBatch ()

2.0 Core

Yes

N/A

void clearWarnings ()

1.0

Yes

N/A

void close ()

1.0

Yes

N/A

boolean execute (String)

1.0

Yes

Throws "invalid method call" exception for PreparedStatement and CallableStatement.

boolean execute (String, int)

3.0

Yes

N/A

boolean execute (String, int [])

3.0

Yes

Supported for the SQL Server drivers. For all other drivers, throws "unsupported method" exception.

boolean execute (String, String [])

3.0

Yes

Supported for the SQL Server drivers. For all other drivers, throws "unsupported method" exception.

int [] executeBatch ()

2.0 Core

Yes

N/A

ResultSet executeQuery (String)

1.0

Yes

Throws "invalid method call" exception for PreparedStatement and CallableStatement.

int executeUpdate (String)

1.0

Yes

Throws "invalid method call" exception for PreparedStatement and CallableStatement.

int executeUpdate (String, int)

3.0

Yes

N/A

int executeUpdate (String, int [])

3.0

Yes

Supported for the SQL Server drivers. For all other drivers, throws "unsupported method" exception.

int executeUpdate (String, String [])

3.0

Yes

Supported for the SQL Server drivers. For all other drivers, throws "unsupported method" exception.

Connection getConnection ()

2.0 Core

Yes

N/A

int getFetchDirection ()

2.0 Core

Yes

N/A

int getFetchSize ()

2.0 Core

Yes

N/A

ResultSet getGeneratedKeys ()

3.0

Yes

The DB2, SQL Server, and Sybase drivers return the last value inserted into an identity column. If an identity column does not exist in the table, the drivers return an empty result set.

The Informix driver returns the last value inserted into a Serial or Serial8 column. If a Serial or Serial8 column does not exist in the table, the driver returns an empty result set.

int getMaxFieldSize ()

1.0

Yes

N/A

int getMaxRows ()

1.0

Yes

N/A

boolean getMoreResults ()

1.0

Yes

N/A

boolean getMoreResults (int)

3.0

Yes

N/A

int getQueryTimeout ()

1.0

Yes

The DB2 driver returns the timeout value, in seconds, set for the statement with DB2 v8.x and higher for Linux/UNIX/Windows and DB2 v8.1 for z/OS. The DB2 driver returns 0 with other DB2 versions.

The Informix driver returns 0.

The SQL Server and Sybase drivers return the timeout value, in seconds, set for the statement.

ResultSet getResultSet ()

1.0

Yes

N/A

int getResultSetConcurrency ()

2.0 Core

Yes

N/A

int getResultSetHoldability ()

3.0

Yes

N/A

int getResultSetType ()

2.0 Core

Yes

N/A

int getUpdateCount ()

1.0

Yes

N/A

SQLWarning getWarnings ()

1.0

Yes

N/A

boolean isClosed ()

4.0

Yes

  

boolean isPoolable ()

4.0

Yes

  

boolean isWrapperFor (Class<?> iface)

4.0

Yes

  

void setCursorName (String)

1.0

No

Throws "unsupported method" exception.

void setEscapeProcessing (boolean)

1.0

Yes

Ignored.

void setFetchDirection (int)

2.0 Core

Yes

N/A

void setFetchSize (int)

2.0 Core

Yes

N/A

void setMaxFieldSize (int)

1.0

Yes

N/A

void setMaxRows (int)

1.0

Yes

N/A

void setQueryTimeout (int)

1.0

Yes

The DB2 driver supports setting a timeout value, in seconds, for a statement with DB2 v8.x and higher for Linux/UNIX/Windows and DB2 v8.1 for z/OS. If the execution of the statement exceeds the timeout value, the statement is timed out by the database server, and the driver throws an exception indicating that the statement was timed out. The DB2 driver throws an "unsupported method" exception with other DB2 versions.

The Informix driver throws an "unsupported method" exception.

The SQL Server and Sybase driver supports setting a timeout value, in seconds, for a statement. If the execution of the statement exceeds the timeout value, the statement is timed out by the database server, and the driver throws an exception indicating that the statement was timed out.

void setPoolable (boolean)4

4.0

Yes

  

void setQueryTimeout (int)

1.0

Yes

The DB2 driver supports setting a timeout value, in seconds, for a statement with DB2 v8.x and higher for Linux/UNIX/Windows and DB2 v8.1 for z/OS. If the execution of the statement exceeds the timeout value, the statement is timed out by the database server, and the driver throws an exception indicating that the statement was timed out. The DB2 driver throws an "unsupported method" exception with other DB2 versions.The Informix driver throw an "unsupported method" exception. The SQL Server and Sybase drivers support setting a timeout value, in seconds, for a statement. If the execution of the statement exceeds the timeout value, the statement is timed out by the database server, and the driver throws an

<T> T unwrap(Class<T> iface)

4.0

Yes

  

StatementEventListener Object

The following table lists functionality supported for each StatementEventListener object.

Table A-21 StatementEventListener Object Object

StatementEventListener Object Methods Version Introduced Supported Comments

void statementClosed (event)

4.0

Yes

N/A

void statementErrorOccurred (event)

4.0

Yes

N/A

Struct Object

The following table lists functionality supported for each Struct object.

Table A-22 Struct Object

Statement Object Methods Version Introduced Supported Comments

(all)

2.0

No

N/A

XAConnection Object

The following table lists functionality supported for each XAConnection object.

Table A-23 XAConnection Object

XAConnection Object Methods Version Introduced Supported Comments

(all)

2.0 Optional

Yes

Supported for all drivers, except for DB2 v7.x for Linux/UNIX/Windows and DB2 v7.x and v8.1 for z/OS.

XADataSource Object

The following table lists functionality supported for each XADataSource object.

Table A-24 XADataSource Object

XADataSource Object Methods Version Introduced Supported Comments

(all)

2.0 Optional

Yes

Supported for all drivers, except for DB2 v7.x for Linux/UNIX/Windows and DB2 v7.x and v8.1for z/OS.

XAResource Object

The following table lists functionality supported for each XAResource object.

Table A-25 XAResource Object

XAResource Object Methods Version Introduced Supported Comments

(all)

2.0 Optional

Yes

Supported for all drivers, except for DB2 v7.x for Linux/UNIX/Windows and DB2 v7.x and v8.1 for z/OS.