JDBC Support

JDBC Support

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

JDBC Compatibility

Table A-1 shows compatibility among the JDBC specification versions, Java Virtual Machines, and the BEA WebLogic Type 4 JDBC drivers.

JDBC Version

Java 2 SDK

Drivers Compatible?
3.0 1.4 Yes

Note: WebLogic Server 8.1 requires a Java 2 SDK version 1.4.

Supported Functionality

The following tables list functionality supported for each JDBC object.

Array Object

Array Object
Methods

Version
Introduced

Supported

Comments
(all) 2.0 Core No Array objects are not exposed or used as input.

Blob Object

Blob Object
Methods

Version
Introduced

Supported

Comments
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.When using with the Oracle driver, the pattern parameter cannot be greater than 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.When using with the Oracle driver, the pattern parameter cannot be greater than 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.

CallableStatement Object

CallableStatement Object
Methods

Version
Introduced

Supported

Comments
Array getArray (int) 2.0 Core No Throws "unsupported method" exception.
Array getArray (String) 3.0 No Throws "unsupported method" exception.
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

Clob Object

Clob Object
Methods

Version
Introduced

Supported

Comments
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 When using with the Oracle driver, the searchStr parameter cannot be greater than 4096 bytes.The SQL Server and Sybase drivers support using with LONGVARCHAR data types.
long position (String, long) 2.0 Core Yes When using with the Oracle driver, the searchStr parameter cannot be greater than 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.

Connection Object

Connection Object
Methods

Version
Introduced

Supported

Comments
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 Support is driver-specific.
int getHoldability () 3.0 No Throws "unsupported method" exception.
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 Support is driver-specific.
void setHoldability (int) 3.0 No Throws "unsupported method" exception.
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.

DatabaseMetaData Object

DatabaseMetaData Object
Methods

Version
Introduced

Supported

Comments
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 No Throws "unsupported method" exception.
int getJDBCMinorVersion () 3.0 No Throws "unsupported method" exception.
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

Driver Object

Driver Object
Methods

Version
Introduced

Supported

Comments
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

ParameterMetaData

ParameterMetaData Object
Methods

Version
Introduced

Supported

Comments
String getParameterClassName (int) 3.0 Yes The DB2 driver only supports with DB2 UDB 8.1 and DB2 iSeries V5R2. "ParameterMetaData is not available" exception is thrown for all other DB2 UDB, DB2 iSeries, Oracle, and SQL Server.Availability for Informix and Sybase varies by statement type.
int getParameterCount () 3.0 Yes

int getParameterMode (int) 3.0 Yes The DB2 driver only supports with DB2 UDB 8.1 and DB2 iSeries V5R2. "ParameterMetaData is not available" exception is thrown for all other DB2 UDB, DB2 iSeries, Oracle, and SQL Server.Availability for Informix and Sybase varies by statement type.
int getParameterType (int) 3.0 Yes The DB2 driver only supports with DB2 UDB 8.1 and DB2 iSeries V5R2. "ParameterMetaData is not available" exception is thrown for all other DB2 UDB, DB2 iSeries, Oracle, and SQL Server.Availability for Informix and Sybase varies by statement type.
String getParameterTypeName (int) 3.0 Yes The DB2 driver only supports with DB2 UDB 8.1 and DB2 iSeries V5R2. "ParameterMetaData is not available" exception is thrown for all other DB2 UDB, DB2 iSeries, Oracle, and SQL Server.Availability for Informix and Sybase varies by statement type.
int getPrecision (int) 3.0 Yes The DB2 driver only supports with DB2 UDB 8.1 and DB2 iSeries V5R2. "ParameterMetaData is not available" exception is thrown for all other DB2 UDB, DB2 iSeries, Oracle, and SQL Server.Availability for Informix and Sybase varies by statement type.
int getScale (int) 3.0 Yes The DB2 driver only supports with DB2 UDB 8.1 and DB2 iSeries V5R2. "ParameterMetaData is not available" exception is thrown for all other DB2 UDB, DB2 iSeries, Oracle, and SQL Server.Availability for Informix and Sybase varies by statement type.
int isNullable (int) 3.0 Yes The DB2 driver only supports with DB2 UDB 8.1 and DB2 iSeries V5R2. "ParameterMetaData is not available" exception is thrown for all other DB2 UDB, DB2 iSeries, Oracle, and SQL Server.Availability for Informix and Sybase varies by statement type.
boolean isSigned (int) 3.0 Yes The DB2 driver only supports with DB2 UDB 8.1 and DB2 iSeries V5R2. "ParameterMetaData is not available" exception is thrown for all other DB2 UDB, DB2 iSeries, Oracle, and SQL Server.Availability for Informix and Sybase varies by statement type.
boolean jdbcCompliant () 1.0 Yes

PreparedStatement Object

PreparedStatement Object
Methods

Version
Introduced

Supported

Comments
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 has been deprecated in the JDBC 3.0 specification.
void setURL (int, URL) 3.0 No Throws "unsupported method" exception.

Ref Object

Ref Object
Methods

Version
Introduced

Supported

Comments
(all) 2.0 Core No

ResultSet Object

ResultSet Object
Methods

Version
Introduced

Supported

Comments
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 only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.
InputStream getBinaryStream (String) 1.0 Yes The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.
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 only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.
byte [] getBytes (String) 1.0 Yes The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.
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.
InputStream getUnicodeStream (String) 1.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.
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 SQL Server and Sybase drivers support using with LONGVARBINARY data types.
void updateBlob (String, Blob) 3.0 No 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 No The SQL Server and Sybase drivers support using with LONGVARCHAR data types.
void updateClob (String, Clob) 3.0 No The SQL Server and Sybase drivers support using with LONGVARCHAR data types.
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

ResultSetMetaData Object

ResultSetMetaData Object
Methods

Version
Introduced

Supported

Comments
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

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

SavePoint Object

SavePoint Object
Methods

Version
Introduced

Supported

Comments
(all) 3.0 Yes The DB2 driver only supports with DB2 UDB 8.1,
DB2 OS/390, and DB2 iSeries V5R2.

Statement Object

Statement Object
Methods

Version
Introduced

Supported

Comments
void addBatch (String) 2.0 Core Yes Throws "invalid method call" exception for PreparedStatement and CallableStatement.
void cancel () 1.0 Yes 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

ResultSet getGeneratedKeys () 3.0 Yes The DB2, SQL Server, Sybase, and Informix drivers return the last value inserted into an identity column. If no identity column exists in the table, these drivers return an empty resultset. The Oracle driver returns the ROWID of the last row inserted.
int getMaxFieldSize () 1.0 Yes

int getMaxRows () 1.0 Yes

boolean getMoreResults () 1.0 Yes

boolean getMoreResults (int) 3.0 Yes

int getQueryTimeout () 1.0 Yes Returns 0 for DB2 (except for DB2 UDB 8.1) and Informix.
ResultSet getResultSet () 1.0 Yes

int getResultSetConcurrency () 2.0 Core Yes

int getResultSetHoldability () 3.0 No Throws "unsupported method" exception.
int getResultSetType () 2.0 Core Yes

int getUpdateCount () 1.0 Yes

SQLWarning getWarnings () 1.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

void setFetchSize (int) 2.0 Core Yes

void setMaxFieldSize (int) 1.0 Yes

void setMaxRows (int) 1.0 Yes

void setQueryTimeout (int) 1.0 Yes Throws "unsupported method" exception for DB2 (except for DB2 UDB 8.1) and Informix.

Struct Object

Struct Object
Methods

Version
Introduced

Supported

Comments
(all) 2.0 No

XAConnection Object

XAConnection Object
Methods

Version
Introduced

Supported

Comments
(all) 2.0 Optional Yes

XADataSource Object

XADataSource Object
Methods

Version
Introduced

Supported

Comments
(all) 2.0 Optional Yes

Blob Object Methods	Version Introduced	Supported	Comments
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.When using with the Oracle driver, the pattern parameter cannot be greater than 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.When using with the Oracle driver, the pattern parameter cannot be greater than 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.

CallableStatement Object Methods	Version Introduced	Supported	Comments
Array getArray (int)	2.0 Core	No	Throws "unsupported method" exception.
Array getArray (String)	3.0	No	Throws "unsupported method" exception.
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

Clob Object Methods	Version Introduced	Supported	Comments
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	When using with the Oracle driver, the searchStr parameter cannot be greater than 4096 bytes.The SQL Server and Sybase drivers support using with LONGVARCHAR data types.
long position (String, long)	2.0 Core	Yes	When using with the Oracle driver, the searchStr parameter cannot be greater than 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.

Connection Object Methods	Version Introduced	Supported	Comments
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	Support is driver-specific.
int getHoldability ()	3.0	No	Throws "unsupported method" exception.
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	Support is driver-specific.
void setHoldability (int)	3.0	No	Throws "unsupported method" exception.
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.

DatabaseMetaData Object Methods	Version Introduced	Supported	Comments
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	No	Throws "unsupported method" exception.
int getJDBCMinorVersion ()	3.0	No	Throws "unsupported method" exception.
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

Driver Object Methods	Version Introduced	Supported
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

ParameterMetaData Object Methods	Version Introduced	Supported	Comments
String getParameterClassName (int)	3.0	Yes	The DB2 driver only supports with DB2 UDB 8.1 and DB2 iSeries V5R2. "ParameterMetaData is not available" exception is thrown for all other DB2 UDB, DB2 iSeries, Oracle, and SQL Server.Availability for Informix and Sybase varies by statement type.
int getParameterCount ()	3.0	Yes
int getParameterMode (int)	3.0	Yes	The DB2 driver only supports with DB2 UDB 8.1 and DB2 iSeries V5R2. "ParameterMetaData is not available" exception is thrown for all other DB2 UDB, DB2 iSeries, Oracle, and SQL Server.Availability for Informix and Sybase varies by statement type.
int getParameterType (int)	3.0	Yes	The DB2 driver only supports with DB2 UDB 8.1 and DB2 iSeries V5R2. "ParameterMetaData is not available" exception is thrown for all other DB2 UDB, DB2 iSeries, Oracle, and SQL Server.Availability for Informix and Sybase varies by statement type.
String getParameterTypeName (int)	3.0	Yes	The DB2 driver only supports with DB2 UDB 8.1 and DB2 iSeries V5R2. "ParameterMetaData is not available" exception is thrown for all other DB2 UDB, DB2 iSeries, Oracle, and SQL Server.Availability for Informix and Sybase varies by statement type.
int getPrecision (int)	3.0	Yes	The DB2 driver only supports with DB2 UDB 8.1 and DB2 iSeries V5R2. "ParameterMetaData is not available" exception is thrown for all other DB2 UDB, DB2 iSeries, Oracle, and SQL Server.Availability for Informix and Sybase varies by statement type.
int getScale (int)	3.0	Yes	The DB2 driver only supports with DB2 UDB 8.1 and DB2 iSeries V5R2. "ParameterMetaData is not available" exception is thrown for all other DB2 UDB, DB2 iSeries, Oracle, and SQL Server.Availability for Informix and Sybase varies by statement type.
int isNullable (int)	3.0	Yes	The DB2 driver only supports with DB2 UDB 8.1 and DB2 iSeries V5R2. "ParameterMetaData is not available" exception is thrown for all other DB2 UDB, DB2 iSeries, Oracle, and SQL Server.Availability for Informix and Sybase varies by statement type.
boolean isSigned (int)	3.0	Yes	The DB2 driver only supports with DB2 UDB 8.1 and DB2 iSeries V5R2. "ParameterMetaData is not available" exception is thrown for all other DB2 UDB, DB2 iSeries, Oracle, and SQL Server.Availability for Informix and Sybase varies by statement type.
boolean jdbcCompliant ()	1.0	Yes

PreparedStatement Object Methods	Version Introduced	Supported	Comments
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 has been deprecated in the JDBC 3.0 specification.
void setURL (int, URL)	3.0	No	Throws "unsupported method" exception.

ResultSet Object Methods	Version Introduced	Supported	Comments
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 only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.
InputStream getBinaryStream (String)	1.0	Yes	The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.
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 only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.
byte [] getBytes (String)	1.0	Yes	The DB2 driver only supports with DB2 UDB 8.1, DB2 OS/390, and DB2 iSeries V5R2.
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.
InputStream getUnicodeStream (String)	1.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.
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 SQL Server and Sybase drivers support using with LONGVARBINARY data types.
void updateBlob (String, Blob)	3.0	No	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	No	The SQL Server and Sybase drivers support using with LONGVARCHAR data types.
void updateClob (String, Clob)	3.0	No	The SQL Server and Sybase drivers support using with LONGVARCHAR data types.
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

ResultSetMetaData Object Methods	Version Introduced	Supported
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
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

Statement Object Methods	Version Introduced	Supported	Comments
void addBatch (String)	2.0 Core	Yes	Throws "invalid method call" exception for PreparedStatement and CallableStatement.
void cancel ()	1.0	Yes	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
ResultSet getGeneratedKeys ()	3.0	Yes	The DB2, SQL Server, Sybase, and Informix drivers return the last value inserted into an identity column. If no identity column exists in the table, these drivers return an empty resultset. The Oracle driver returns the ROWID of the last row inserted.
int getMaxFieldSize ()	1.0	Yes
int getMaxRows ()	1.0	Yes
boolean getMoreResults ()	1.0	Yes
boolean getMoreResults (int)	3.0	Yes
int getQueryTimeout ()	1.0	Yes	Returns 0 for DB2 (except for DB2 UDB 8.1) and Informix.
ResultSet getResultSet ()	1.0	Yes
int getResultSetConcurrency ()	2.0 Core	Yes
int getResultSetHoldability ()	3.0	No	Throws "unsupported method" exception.
int getResultSetType ()	2.0 Core	Yes
int getUpdateCount ()	1.0	Yes
SQLWarning getWarnings ()	1.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
void setFetchSize (int)	2.0 Core	Yes
void setMaxFieldSize (int)	1.0	Yes
void setMaxRows (int)	1.0	Yes
void setQueryTimeout (int)	1.0	Yes	Throws "unsupported method" exception for DB2 (except for DB2 UDB 8.1) and Informix.