JDBC Version

Java 2 SDK

Drivers Compatible?

3.0

5.0

Yes

(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 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The SQL Server and Sybase drivers support using with LONGVARBINARY data types.

byte[] getBytes (long, int)

2.0 Core

Yes

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The SQL Server and Sybase drivers support using with LONGVARBINARY data types.

long length ()

2.0 Core

Yes

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The SQL Server and Sybase drivers support using with LONGVARBINARY data types.

long position (Blob, long)

2.0 Core

Yes

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

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 LONGVARBINARY data types.

long position (byte[], long)

2.0 Core

Yes

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

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 LONGVARBINARY data types.

OutputStream setBinaryStream (long)

3.0

Yes

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The SQL Server and Sybase drivers support using with LONGVARBINARY data types.

int setBytes (long, byte[])

3.0

Yes

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The SQL Server and Sybase drivers support using with LONGVARBINARY data types.

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

3.0

Yes

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The SQL Server and Sybase drivers support using with LONGVARBINARY data types.

void truncate (long)

3.0

Yes

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The SQL Server and Sybase drivers support using with LONGVARBINARY data types.

Array getArray (int)

2.0 Core

No

Throws "unsupported method" exception.

Array getArray (String)

3.0

No

Throws "unsupported method" exception.

BigDecimal getBigDecimal (int)

2.0 Core

Yes

BigDecimal getBigDecimal (int, int)

1.0

Yes

BigDecimal getBigDecimal (String)

3.0

No

Throws "unsupported method" exception.

Blob getBlob (int)

2.0 Core

Yes

The SQL Server and Sybase drivers support using with LONGVARBINARY data types.

Blob getBlob (String)

3.0

No

The SQL Server and Sybase drivers support using with LONGVARBINARY data types.

boolean getBoolean (int)

1.0

Yes

boolean getBoolean (String)

3.0

No

Throws "unsupported method" exception.

byte getByte (int)

1.0

Yes

byte getByte (String)

3.0

No

Throws "unsupported method" exception.

byte [] getBytes (int)

1.0

Yes

byte [] getBytes (String)

3.0

No

Throws "unsupported method" exception.

Clob getClob (int)

2.0 Core

Yes

Clob getClob (String)

3.0

No

Throws "unsupported method" exception.

Date getDate (int)

1.0

Yes

Date getDate (int, Calendar)

2.0 Core

Yes

Date getDate (String)

3.0

No

Throws "unsupported method" exception.

Date getDate (String, Calendar)

3.0

No

Throws "unsupported method" exception.

double getDouble (int)

1.0

Yes

double getDouble (String)

3.0

No

Throws "unsupported method" exception.

float getFloat (int)

1.0

Yes

float getFloat (String)

3.0

No

Throws "unsupported method" exception.

int getInt (int)

1.0

Yes

int getInt (String)

3.0

No

Throws "unsupported method" exception.

long getLong (int)

1.0

Yes

long getLong (String)

3.0

No

Throws "unsupported method" exception.

Object getObject (int)

1.0

Yes

Object getObject (int, Map)

2.0 Core

Yes

Map ignored.

Object getObject (String)

3.0

No

Throws "unsupported method" exception.

Object getObject (String, Map)

3.0

No

Throws "unsupported method" exception.

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

short getShort (String)

3.0

No

Throws "unsupported method" exception.

String getString (int)

1.0

Yes

String getString (String)

3.0

No

Throws "unsupported method" exception.

Time getTime (int)

1.0

Yes

Time getTime (int, Calendar)

2.0 Core

Yes

Time getTime (String)

3.0

No

Throws "unsupported method" exception.

Time getTime (String, Calendar)

3.0

No

Throws "unsupported method" exception.

Timestamp getTimestamp (int)

1.0

Yes

Timestamp getTimestamp (int, Calendar)

2.0 Core

Yes

Timestamp getTimestamp (String)

3.0

No

Throws "unsupported method" exception.

Timestamp getTimestamp (String, Calendar)

3.0

No

Throws "unsupported method" exception.

URL getURL (int)

3.0

No

Throws "unsupported method" exception.

URL getURL (String)

3.0

No

Throws "unsupported method" exception.

void registerOutParameter (int, int)

1.0

Yes

void registerOutParameter (int, int, int)

1.0

Yes

void registerOutParameter (int, int, String)

2.0 Core

Yes

String/typename ignored.

void registerOutParameter (String, int)

3.0

No

Throws "unsupported method" exception.

void registerOutParameter (String, int, int)

3.0

No

Throws "unsupported method" exception.

void registerOutParameter (String, int, String)

3.0

No

Throws "unsupported method" exception.

void setArray (int, Array)

2.0 Core

No

Throws "unsupported method" exception.

void setAsciiStream (String, InputStream, int)

3.0

No

Throws "unsupported method" exception.

void setBigDecimal (String, BigDecimal)

3.0

No

Throws "unsupported method" exception.

void setBinaryStream (String, InputStream, int)

3.0

No

Throws "unsupported method" exception.

void setBoolean (String, boolean)

3.0

No

Throws "unsupported method" exception.

void setByte (String, byte)

3.0

No

Throws "unsupported method" exception.

void setBytes (String, byte [])

3.0

No

Throws "unsupported method" exception.

void setCharacterStream (String, Reader, int)

3.0

No

Throws "unsupported method" exception.

void setDate (String, Date)

3.0

No

Throws "unsupported method" exception.

void setDate (String, Date, Calendar)

3.0

No

Throws "unsupported method" exception.

void setDouble (String, double)

3.0

No

Throws "unsupported method" exception.

void setFloat (String, float)

3.0

No

Throws "unsupported method" exception.

void setInt (String, int)

3.0

No

Throws "unsupported method" exception.

void setLong (String, long)

3.0

No

Throws "unsupported method" exception.

void setNull (String, int)

3.0

No

Throws "unsupported method" exception.

void setNull (String, int, String)

3.0

No

Throws "unsupported method" exception.

void setObject (String, Object)

3.0

No

Throws "unsupported method" exception.

void setObject (String, Object, int)

3.0

No

Throws "unsupported method" exception.

void setObject (String, Object, int, int)

3.0

No

Throws "unsupported method" exception.

void setShort (String, short)

3.0

No

Throws "unsupported method" exception.

void setString (String, String)

3.0

No

Throws "unsupported method" exception.

void setTime (String, Time)

3.0

No

Throws "unsupported method" exception.

void setTime (String, Time, Calendar)

3.0

No

Throws "unsupported method" exception.

void setTimestamp (String, Timestamp)

3.0

No

Throws "unsupported method" exception.

void setTimestamp (String, Timestamp, Calendar)

3.0

No

Throws "unsupported method" exception.

void setURL (String, URL)

3.0

No

Throws "unsupported method" exception.

boolean wasNull ()

1.0

Yes

InputStream getAsciiStream ()

2.0 Core

Yes

The SQL Server and Sybase drivers support using with LONGVARCHAR data types.

Reader getCharacterStream ()

2.0 Core

Yes

The SQL Server and Sybase drivers support using with LONGVARCHAR data types.

String getSubString (long, int)

2.0 Core

Yes

The SQL Server and Sybase drivers support using with LONGVARCHAR data types.

long length ()

2.0 Core

Yes

The SQL Server and Sybase drivers support using with LONGVARCHAR data types.

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 LONGVARCHAR data types.

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 LONGVARCHAR data types.

OutputStream setAsciiStream (long)

3.0 Core

Yes

The SQL Server and Sybase drivers support using with LONGVARCHAR data types.

Writer setCharacterStream (long)

3.0 Core

Yes

The SQL Server and Sybase drivers support using with LONGVARCHAR data types.

int setString (long, String)

3.0 Core

Yes

The SQL Server and Sybase drivers support using with LONGVARCHAR data types.

int setString (long, String, int, int)

3.0 Core

Yes

The SQL Server and Sybase drivers support using with LONGVARCHAR data types.

void truncate (long)

3.0 Core

Yes

The SQL Server and Sybase drivers support using with LONGVARCHAR data types.

void clearWarnings ()

1.0

Yes

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

Statement createStatement ()

1.0

Yes

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

String getCatalog ()

1.0

Yes

Supported for all drivers except Oracle, which does not have the concept of a catalog. The Oracle driver returns an empty string.

int getHoldability ()

3.0

Yes

DatabaseMetaData getMetaData ()

1.0

Yes

int getTransactionIsolation ()

1.0

Yes

Map getTypeMap ()

2.0 Core

Yes

Always returns empty java.util.HashMap.

SQLWarning getWarnings ()

1.0

Yes

boolean isClosed ()

1.0

Yes

boolean isReadOnly ()

1.0

Yes

String nativeSQL (String)

1.0

Yes

Always returns same String as passed in.

CallableStatement prepareCall (String)

1.0

Yes

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

PreparedStatement prepareStatement (String, int)

3.0

Yes

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

No

Throws "unsupported method" exception.

PreparedStatement prepareStatement (String, String [])

3.0

No

Throws "unsupported method" exception.

void releaseSavepoint (Savepoint)

3.0

Yes

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

void rollback ()

1.0

Yes

void rollback (Savepoint)

3.0

Yes

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

void setAutoCommit (boolean)

1.0

Yes

void setCatalog (String)

1.0

Yes

Supported for all drivers except Oracle, which does not have the concept of a catalog. The Oracle driver ignores any value set by the catalog parameter.

void setHoldability (int)

3.0

Yes

Holdability parameter value is ignored.

void setReadOnly (boolean)

1.0

Yes

Savepoint setSavepoint ()

3.0

Yes

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

Savepoint setSavepoint (String)

3.0

Yes

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

void setTransactionIsolation (int)

1.0

Yes

void setTypeMap (Map)

2.0 Core

Yes

Ignored.

boolean allProceduresAreCallable ()

1.0

Yes

boolean allTablesAreSelectable ()

1.0

Yes

boolean dataDefinitionCausesTransaction
Commit ()

1.0

Yes

boolean dataDefinitionIgnoredInTransactions ()

1.0

Yes

boolean deletesAreDetected (int)

2.0 Core

Yes

boolean doesMaxRowSizeIncludeBlobs ()

1.0

Yes

Not supported by the SQL Server and Sybase drivers.

ResultSet getAttributes (String, String, String, String)

3.0

No

Throws "unsupported method" exception.

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

1.0

Yes

ResultSet getCatalogs ()

1.0

Yes

String getCatalogSeparator ()

1.0

Yes

String getCatalogTerm ()

1.0

Yes

ResultSet getColumnPrivileges (String, String, String, String)

1.0

Yes

ResultSet getColumns (String, String, String, String)

1.0

Yes

Connection getConnection ()

2.0 Core

Yes

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

1.0

Yes

int getDatabaseMajorVersion ()

3.0

Yes

int getDatabaseMinorVersion ()

3.0

Yes

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

int getDefaultTransactionIsolation ()

1.0

Yes

int getDriverMajorVersion ()

1.0

Yes

int getDriverMinorVersion ()

1.0

Yes

String getDriverName ()

1.0

Yes

String getDriverVersion ()

1.0

Yes

ResultSet getExportedKeys (String, String, String)

1.0

Yes

String getExtraNameCharacters ()

1.0

Yes

String getIdentifierQuoteString ()

1.0

Yes

ResultSet getImportedKeys (String, String, String)

1.0

Yes

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

1.0

Yes

int getJDBCMajorVersion ()

3.0

Yes

int getJDBCMinorVersion ()

3.0

Yes

int getMaxBinaryLiteralLength ()

1.0

Yes

int getMaxCatalogNameLength ()

1.0

Yes

int getMaxCharLiteralLength ()

1.0

Yes

int getMaxColumnNameLength ()

1.0

Yes

int getMaxColumnsInGroupBy ()

1.0

Yes

int getMaxColumnsInIndex ()

1.0

Yes

int getMaxColumnsInOrderBy ()

1.0

Yes

int getMaxColumnsInSelect ()

1.0

Yes

int getMaxColumnsInTable ()

1.0

Yes

int getMaxConnections ()

1.0

Yes

int getMaxCursorNameLength ()

1.0

Yes

int getMaxIndexLength ()

1.0

Yes

int getMaxProcedureNameLength ()

1.0

Yes

int getMaxRowSize ()

1.0

Yes

int getMaxSchemaNameLength ()

1.0

Yes

int getMaxStatementLength ()

1.0

Yes

int getMaxStatements ()

1.0

Yes

int getMaxTableNameLength ()

1.0

Yes

int getMaxTablesInSelect ()

1.0

Yes

int getMaxUserNameLength ()

1.0

Yes

String getNumericFunctions ()

1.0

Yes

ResultSet getPrimaryKeys (String, String, String)

1.0

Yes

ResultSet getProcedureColumns (String, String, String, String)

1.0

Yes

ResultSet getProcedures (String, String, String)

1.0

Yes

String getProcedureTerm ()

1.0

Yes

int getResultSetHoldability ()

3.0

Yes

ResultSet getSchemas ()

1.0

Yes

String getSchemaTerm ()

1.0

Yes

String getSearchStringEscape ()

1.0

Yes

String getSQLKeywords ()

1.0

Yes

int getSQLStateType ()

3.0

Yes

String getStringFunctions ()

1.0

Yes

ResultSet getSuperTables (String, String, String)

3.0

No

Throws "unsupported method" exception.

ResultSet getSuperTypes (String, String, String)

3.0

No

Throws "unsupported method" exception.

String getSystemFunctions ()

1.0

Yes

ResultSet getTablePrivileges (String, String, String)

1.0

Yes

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

1.0

Yes

ResultSet getTableTypes ()

1.0

Yes

String getTimeDateFunctions ()

1.0

Yes

ResultSet getTypeInfo ()

1.0

Yes

ResultSet getUDTs (String, String, String,
int [])

2.0 Core

No

Always returns empty ResultSet.

String getURL ()

1.0

Yes

String getUserName ()

1.0

Yes

ResultSet getVersionColumns (String, String, String)

1.0

Yes

boolean insertsAreDetected (int)

2.0 Core

Yes

boolean isCatalogAtStart ()

1.0

Yes

boolean isReadOnly ()

1.0

Yes

boolean locatorsUpdateCopy ()

3.0

Yes

boolean nullPlusNonNullIsNull ()

1.0

Yes

boolean nullsAreSortedAtEnd ()

1.0

Yes

boolean nullsAreSortedAtStart ()

1.0

Yes

boolean nullsAreSortedHigh ()

1.0

Yes

boolean nullsAreSortedLow ()

1.0

Yes

boolean othersDeletesAreVisible (int)

2.0 Core

Yes

boolean othersInsertsAreVisible (int)

2.0 Core

Yes

boolean othersUpdatesAreVisible (int)

2.0 Core

Yes

boolean ownDeletesAreVisible (int)

2.0 Core

Yes

boolean ownInsertsAreVisible (int)

2.0 Core

Yes

boolean ownUpdatesAreVisible (int)

2.0 Core

Yes

boolean storesLowerCaseIdentifiers ()

1.0

Yes

boolean storesLowerCaseQuoted
Identifiers ()

1.0

Yes

boolean storesMixedCaseIdentifiers ()

1.0

Yes

boolean storesMixedCaseQuoted
Identifiers ()

1.0

Yes

boolean storesUpperCaseIdentifiers ()

1.0

Yes

boolean storesUpperCaseQuoted
Identifiers ()

1.0

Yes

boolean supportsAlterTableWith
AddColumn ()

1.0

Yes

boolean supportsAlterTableWith
DropColumn ()

1.0

Yes

boolean supportsANSI92EntryLevelSQL ()

1.0

Yes

boolean supportsANSI92FullSQL ()

1.0

Yes

boolean supportsANSI92Intermediate
SQL ()

1.0

Yes

boolean supportsBatchUpdates ()

2.0 Core

Yes

boolean supportsCatalogsInData
Manipulation ()

1.0

Yes

boolean supportsCatalogsInIndex
Definitions ()

1.0

Yes

boolean supportsCatalogsInPrivilege
Definitions ()

1.0

Yes

boolean supportsCatalogsInProcedure
Calls ()

1.0

Yes

boolean supportsCatalogsInTable
Definitions ()

1.0

Yes

boolean supportsColumnAliasing ()

1.0

Yes

boolean supportsConvert ()

1.0

Yes

boolean supportsConvert (int, int)

1.0

Yes

boolean supportsCoreSQLGrammar ()

1.0

Yes

boolean supportsCorrelatedSubqueries ()

1.0

Yes

boolean supportsDataDefinitionAndData
ManipulationTransactions ()

1.0

Yes

boolean supportsDataManipulation
TransactionsOnly ()

1.0

Yes

boolean supportsDifferentTableCorrelation
Names ()

1.0

Yes

boolean supportsExpressionsIn
OrderBy ()

1.0

Yes

boolean supportsExtendedSQLGrammar ()

1.0

Yes

boolean supportsFullOuterJoins ()

1.0

Yes

boolean supportsGetGeneratedKeys ()

3.0

Yes

boolean supportsGroupBy ()

1.0

Yes

boolean supportsGroupByBeyondSelect ()

1.0

Yes

boolean supportsGroupByUnrelated ()

1.0

Yes

boolean supportsIntegrityEnhancement
Facility ()

1.0

Yes

boolean supportsLikeEscapeClause ()

1.0

Yes

boolean supportsLimitedOuterJoins ()

1.0

Yes

boolean supportsMinimumSQLGrammar ()

1.0

Yes

boolean supportsMixedCaseIdentifiers ()

1.0

Yes

boolean supportsMixedCaseQuoted
Identifiers ()

1.0

Yes

boolean supportsMultipleOpenResults ()

3.0

Yes

boolean supportsMultipleResultSets ()

1.0

Yes

boolean supportsMultipleTransactions ()

1.0

Yes

boolean supportsNamedParameters ()

3.0

Yes

boolean supportsNonNullableColumns ()

1.0

Yes

boolean supportsOpenCursorsAcross
Commit ()

1.0

Yes

boolean supportsOpenCursorsAcross
Rollback ()

1.0

Yes

boolean supportsOpenStatementsAcross
Commit ()

1.0

Yes

boolean supportsOpenStatementsAcross
Rollback ()

1.0

Yes

boolean supportsOrderByUnrelated ()

1.0

Yes

boolean supportsOuterJoins ()

1.0

Yes

boolean supportsPositionedDelete ()

1.0

Yes

boolean supportsPositionedUpdate ()

1.0

Yes

boolean supportsResultSetConcurrency (int, int)

2.0 Core

Yes

boolean supportsResultSetHoldability (int)

3.0

Yes

boolean supportsResultSetType (int)

2.0 Core

Yes

boolean supportsSavePoints ()

3.0

Yes

boolean supportsSchemasInData
Manipulation ()

1.0

Yes

boolean supportsSchemasInIndex
Definitions ()

1.0

Yes

boolean supportsSchemasIn
PrivilegeDefinitions ()

1.0

Yes

boolean supportsSchemasInProcedure
Calls ()

1.0

Yes

boolean supportsSchemasInTable
Definitions ()

1.0

Yes

boolean supportsSelectForUpdate ()

1.0

Yes

boolean supportsStoredProcedures ()

1.0

Yes

boolean supportsSubqueriesIn
Comparisons ()

1.0

Yes

boolean supportsSubqueriesInExists ()

1.0

Yes

boolean supportsSubqueriesInIns ()

1.0

Yes

boolean supportsSubqueriesIn
Quantifieds ()

1.0

Yes

boolean supportsTableCorrelationNames ()

1.0

Yes

boolean supportsTransactionIsolationLevel (int)

1.0

Yes

boolean supportsTransactions ()

1.0

Yes

boolean supportsUnion ()

1.0

Yes

boolean supportsUnionAll ()

1.0

Yes

boolean updatesAreDetected (int)

2.0 Core

Yes

boolean usesLocalFilePerTable ()

1.0

Yes

boolean usesLocalFiles ()

1.0

Yes

boolean acceptsURL (String)

1.0

Yes

Connection connect (String, Properties)

1.0

Yes

int getMajorVersion ()

1.0

Yes

int getMinorVersion ()

1.0

Yes

DriverPropertyInfo [] getPropertyInfo (String, Properties)

1.0

Yes

String getParameterClassName (int)

3.0

Yes

The DB2 driver only supports for all types of SQL statements with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The Informix driver does not support for Select statements or stored procedures.

The Sybase driver supports for all types of SQL statements.

All other drivers support for simple Insert and Update SQL statements only. See the appropriate driver chapter for more information.

int getParameterCount ()

3.0

Yes

int getParameterMode (int)

3.0

Yes

The DB2 driver only supports for all types of SQL statements with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The Informix driver does not support for Select statements or stored procedures.

The Sybase driver supports for all types of SQL statements.

All other drivers support for simple Insert and Update SQL statements only. See the appropriate driver chapter for more information.

int getParameterType (int)

3.0

Yes

The DB2 driver only supports for all types of SQL statements with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The Informix driver does not support for Select statements or stored procedures.

The Sybase driver supports for all types of SQL statements.

All other drivers support for simple Insert and Update SQL statements only. See the appropriate driver chapter for more information.

String getParameterTypeName (int)

3.0

Yes

The DB2 driver only supports for all types of SQL statements with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The Informix driver does not support for Select statements or stored procedures.

The Sybase driver supports for all types of SQL statements.

All other drivers support for simple Insert and Update SQL statements only. See the appropriate driver chapter for more information.

int getPrecision (int)

3.0

Yes

The DB2 driver only supports for all types of SQL statements with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The Informix driver does not support for Select statements or stored procedures.

The Sybase driver supports for all types of SQL statements.

All other drivers support for simple Insert and Update SQL statements only. See the appropriate driver chapter for more information.

int getScale (int)

3.0

Yes

The DB2 driver only supports for all types of SQL statements with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The Informix driver does not support for Select statements or stored procedures.

The Sybase driver supports for all types of SQL statements.

All other drivers support for simple Insert and Update SQL statements only. See the appropriate driver chapter for more information.

int isNullable (int)

3.0

Yes

The DB2 driver only supports for all types of SQL statements with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The Informix driver does not support for Select statements or stored procedures.

The Sybase driver supports for all types of SQL statements.

All other drivers support for simple Insert and Update SQL statements only. See the appropriate driver chapter for more information.

boolean isSigned (int)

3.0

Yes

The DB2 driver only supports for all types of SQL statements with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The Informix driver does not support for Select statements or stored procedures.

The Sybase driver supports for all types of SQL statements.

All other drivers support for simple Insert and Update SQL statements only. See the appropriate driver chapter for more information.

boolean jdbcCompliant ()

1.0

Yes

void addBatch ()

2.0 Core

Yes

void clearParameters ()

1.0

Yes

boolean execute ()

1.0

Yes

ResultSet executeQuery ()

1.0

Yes

int executeUpdate ()

1.0

Yes

ResultSetMetaData getMetaData ()

2.0 Core

Yes

ParameterMetaData getParameterMetaData ()

3.0

Yes

void setArray (int, Array)

2.0 Core

No

Throws "unsupported method" exception.

void setAsciiStream (int, InputStream, int)

1.0

Yes

void setBigDecimal (int, BigDecimal)

1.0

Yes

void setBinaryStream (int, InputStream, int)

1.0

Yes

When used with Blobs, the DB2 driver only supports with DB2 UDB 8.1,
DB2 OS/390, and DB2 iSeries V5R2.

void setBlob (int, Blob)

2.0 Core

Yes

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The SQL Server and Sybase drivers support using with LONGVARBINARY data types.

void setBoolean (int, boolean)

1.0

Yes

void setByte (int, byte)

1.0

Yes

void setBytes (int, byte [])

1.0

Yes

When used with Blobs, the DB2 driver only supports with DB2 UDB 8.1,
DB2 OS/390, and DB2 iSeries V5R2.

void setCharacterStream (int, Reader, int)

2.0 Core

Yes

void setClob (int, Clob)

2.0 Core

Yes

The SQL Server and Sybase drivers support using with LONGVARCHAR data types.

void setDate (int, Date)

1.0

Yes

void setDate (int, Date, Calendar)

2.0 Core

Yes

void setDouble (int, double)

1.0

Yes

void setFloat (int, float)

1.0

Yes

void setInt (int, int)

1.0

Yes

void setLong (int, long)

1.0

Yes

void setNull (int, int)

1.0

Yes

void setNull (int, int, String)

2.0 Core

Yes

void setObject (int, Object)

1.0

Yes

void setObject (int, Object, int)

1.0

Yes

void setObject (int, Object, int, int)

1.0

Yes

void setQueryTimeout (int)

1.0

Yes

Throws "unsupported method" exception for DB2 and Informix.

void setRef (int, Ref)

2.0 Core

No

Throws "unsupported method" exception.

void setShort (int, short)

1.0

Yes

void setString (int, String)

1.0

Yes

void setTime (int, Time)

1.0

Yes

void setTime (int, Time, Calendar)

2.0 Core

Yes

void setTimestamp (int, Timestamp)

1.0

Yes

void setTimestamp (int, Timestamp, Calendar)

2.0 Core

Yes

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

boolean absolute (int)

2.0 Core

Yes

void afterLast ()

2.0 Core

Yes

void beforeFirst ()

2.0 Core

Yes

void cancelRowUpdates ()

2.0 Core

Yes

void clearWarnings ()

1.0

Yes

void close ()

1.0

Yes

void deleteRow ()

2.0 Core

Yes

int findColumn (String)

1.0

Yes

boolean first ()

2.0 Core

Yes

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

InputStream getAsciiStream (String)

1.0

Yes

BigDecimal getBigDecimal (int)

2.0 Core

Yes

BigDecimal getBigDecimal (int, int)

1.0

Yes

BigDecimal getBigDecimal (String)

2.0 Core

Yes

BigDecimal getBigDecimal (String, int)

1.0

Yes

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 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2 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 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2 when retrieving BLOB data.

Blob getBlob (int)

2.0 Core

Yes

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The SQL Server and Sybase drivers support using with LONGVARBINARY data types.

Blob getBlob (String)

2.0 Core

Yes

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The SQL Server and Sybase drivers support using with LONGVARBINARY data types.

boolean getBoolean (int)

1.0

Yes

boolean getBoolean (String)

1.0

Yes

byte getByte (int)

1.0

Yes

byte getByte (String)

1.0

Yes

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 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2 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 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2 when retrieving BLOB data.

Reader getCharacterStream (int)

2.0 Core

Yes

Reader getCharacterStream (String)

2.0 Core

Yes

Clob getClob (int)

2.0 Core

Yes

The SQL Server and Sybase drivers support using with LONGVARCHAR data types.

Clob getClob (String)

2.0 Core

Yes

The SQL Server and Sybase drivers support using with LONGVARCHAR data types.

int getConcurrency ()

2.0 Core

Yes

String getCursorName ()

1.0

No

Throws "unsupported method" exception.

Date getDate (int)

1.0

Yes

Date getDate (int, Calendar)

2.0 Core

Yes

Date getDate (String)

1.0

Yes

Date getDate (String, Calendar)

2.0 Core

Yes

double getDouble (int)

1.0

Yes

double getDouble (String)

1.0

Yes

int getFetchDirection ()

2.0 Core

Yes

int getFetchSize ()

2.0 Core

Yes

float getFloat (int)

1.0

Yes

float getFloat (String)

1.0

Yes

int getInt (int)

1.0

Yes

int getInt (String)

1.0

Yes

long getLong (int)

1.0

Yes

long getLong (String)

1.0

Yes

ResultSetMetaData getMetaData ()

1.0

Yes

Object getObject (int)

1.0

Yes

Object getObject (int, Map)

2.0 Core

Yes

Map ignored.

Object getObject (String)

1.0

Yes

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

short getShort (int)

1.0

Yes

short getShort (String)

1.0

Yes

Statement getStatement ()

2.0 Core

Yes

String getString (int)

1.0

Yes

String getString (String)

1.0

Yes

Time getTime (int)

1.0

Yes

Time getTime (int, Calendar)

2.0 Core

Yes

Time getTime (String)

1.0

Yes

Time getTime (String, Calendar)

2.0 Core

Yes

Timestamp getTimestamp (int)

1.0

Yes

Timestamp getTimestamp (int, Calendar)

2.0 Core

Yes

Timestamp getTimestamp (String)

1.0

Yes

Timestamp getTimestamp (String, Calendar)

2.0 Core

Yes

int getType ()

2.0 Core

Yes

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

void insertRow ()

2.0 Core

Yes

boolean isAfterLast ()

2.0 Core

Yes

boolean isBeforeFirst ()

2.0 Core

Yes

boolean isFirst ()

2.0 Core

Yes

boolean isLast ()

2.0 Core

Yes

boolean last ()

2.0 Core

Yes

void moveToCurrentRow ()

2.0 Core

Yes

void moveToInsertRow ()

2.0 Core

Yes

boolean next ()

1.0

Yes

boolean previous ()

2.0 Core

Yes

void refreshRow ()

2.0 Core

Yes

boolean relative (int)

2.0 Core

Yes

boolean rowDeleted ()

2.0 Core

Yes

boolean rowInserted ()

2.0 Core

Yes

boolean rowUpdated ()

2.0 Core

Yes

void setFetchDirection (int)

2.0 Core

Yes

void setFetchSize (int)

2.0 Core

Yes

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

void updateAsciiStream (String, InputStream, int)

2.0 Core

Yes

void updateBigDecimal (int, BigDecimal)

2.0 Core

Yes

void updateBigDecimal (String, BigDecimal)

2.0 Core

Yes

void updateBinaryStream (int, InputStream, int)

2.0 Core

Yes

void updateBinaryStream (String, InputStream, int)

2.0 Core

Yes

void updateBlob (int, Blob)

3.0

No

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The SQL Server and Sybase drivers support using with LONGVARBINARY data types.

void updateBlob (String, Blob)

3.0

No

The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.

The SQL Server and Sybase drivers support using with LONGVARBINARY data types.

void updateBoolean (int, boolean)

2.0 Core

Yes

void updateBoolean (String, boolean)

2.0 Core

Yes

void updateByte (int, byte)

2.0 Core

Yes

void updateByte (String, byte)

2.0 Core

Yes

void updateBytes (int, byte [])

2.0 Core

Yes

void updateBytes (String, byte [])

2.0 Core

Yes

void updateCharacterStream (int, Reader, int)

2.0 Core

Yes

void updateCharacterStream (String, Reader, int)

2.0 Core

Yes

void updateClob (int, Clob)

3.0

Yes

void updateClob (String, Clob)

3.0

Yes

void updateDate (int, Date)

2.0 Core

Yes

void updateDate (String, Date)

2.0 Core

Yes

void updateDouble (int, double)

2.0 Core

Yes

void updateDouble (String, double)

2.0 Core

Yes

void updateFloat (int, float)

2.0 Core

Yes

void updateFloat (String, float)

2.0 Core

Yes

void updateInt (int, int)

2.0 Core

Yes

void updateInt (String, int)

2.0 Core

Yes

void updateLong (int, long)

2.0 Core

Yes

void updateLong (String, long)

2.0 Core

Yes

void updateNull (int)

2.0 Core

Yes

void updateNull (String)

2.0 Core

Yes

void updateObject (int, Object)

2.0 Core

Yes

void updateObject (int, Object, int)

2.0 Core

Yes

void updateObject (String, Object)

2.0 Core

Yes

void updateObject (String, Object, int)

2.0 Core

Yes

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

void updateShort (int, short)

2.0 Core

Yes

void updateShort (String, short)

2.0 Core

Yes

void updateString (int, String)

2.0 Core

Yes

void updateString (String, String)

2.0 Core

Yes

void updateTime (int, Time)

2.0 Core

Yes

void updateTime (String, Time)

2.0 Core

Yes

void updateTimestamp (int, Timestamp)

2.0 Core

Yes

void updateTimestamp (String, Timestamp)

2.0 Core

Yes

boolean wasNull ()

1.0

Yes

String getCatalogName (int)

1.0

Yes

String getColumnClassName (int)

2.0 Core

Yes

int getColumnCount ()

1.0

Yes

int getColumnDisplaySize (int)

1.0

Yes

String getColumnLabel (int)

1.0

Yes

String getColumnName (int)

1.0

Yes

int getColumnType (int)

1.0

Yes

String getColumnTypeName (int)

1.0

Yes

int getPrecision (int)

1.0

Yes

int getScale (int)

1.0

Yes

String getSchemaName (int)

1.0

Yes

String getTableName (int)

1.0

Yes

For versions 3.4 and higher:

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

• To return a table name for the Oracle, 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".

boolean isAutoIncrement (int)

1.0

Yes

boolean isCaseSensitive (int)

1.0

Yes

boolean isCurrency (int)

1.0

Yes

boolean isDefinitelyWritable (int)

1.0

Yes

int isNullable (int)

1.0

Yes

boolean isReadOnly (int)

1.0

Yes

boolean isSearchable (int)

1.0

Yes

boolean isSigned (int)

1.0

Yes

boolean isWritable (int)

1.0

Yes

(all)

3.0

Yes

The DB2 driver only supports with DB2 UDB 8.1,
DB2 OS/390, and DB2 iSeries V5R2.

void addBatch (String)

2.0 Core

Yes

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

void cancel ()

1.0

Yes

Throws "unsupported method" exception for DB2 (except for DB2 UDB 8.1) and Informix.

void clearBatch ()

2.0 Core

Yes

void clearWarnings ()

1.0

Yes

void close ()

1.0

Yes

boolean execute (String)

1.0

Yes

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

boolean execute (String, int)

3.0

Yes

boolean execute (String, int [])

3.0

No

Throws "unsupported method" exception.

boolean execute (String, String [])

3.0

No

Throws "unsupported method" exception.

int [] executeBatch ()

2.0 Core

Yes

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

int executeUpdate (String, int [])

3.0

No

Throws "unsupported method" exception.

int executeUpdate (String, String [])

3.0

No

Throws "unsupported method" exception.

Connection getConnection ()

2.0 Core

Yes

int getFetchDirection ()

2.0 Core

Yes

int getFetchSize ()

2.0 Core

Yes