A JDBC Support

(all)

2.0 Core

No

Array objects are not exposed or used as input.

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.

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

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.

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

void connectionClosed (event))

3.0

Yes

void connectionErrorOccurred (event)

3.0

Yes

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

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

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)

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

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

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

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.

(all)

2.0 Core

No

N/A

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

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

(all)

2.0 Optional

No

(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.

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

void statementClosed (event)

4.0

Yes

N/A

void statementErrorOccurred (event)

4.0

Yes

N/A

(all)

2.0

No

N/A

(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.

(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.

(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.