Skip navigation.
Downloads | Product Documentation | Support

WebLogic Type 4 JDBC Drivers

# JDBC Support

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

- JDBC Compatibility
- Supported Functionality

- Array Object
- Blob Object
- CallableStatement Object
- Clob Object
- Connection Object
- DatabaseMetaData Object
- Driver Object
- ParameterMetaData Object
- PreparedStatement Object
- Ref Object
- ResultSet Object
- ResultSetMetaData Object
- SavePoint Object
- Statement Object
- Struct Object
- XAConnection Object
- XADataSource Object
- XAResource Object

# JDBC Compatibility

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

Table A-1 JDBC Compatibility

JDBC Version | Java 2 SDK | Drivers Compatible?
3.0 | 5.0 | Yes

Note: WebLogic Server 9.0 requires a Java 2 SDK version 5.0.

# Supported Functionality

The following tables list functionality supported for each JDBC object.

## Array Object

Table A-2 Array Object

Array Object Methods | Version Introduced | Supported | Comments
--- | --- | --- | ---
(all) | 2.0 Core | No | Array objects are not exposed or used as input.

## Blob Object

Table A-3 Blob Object

Blob Object Methods | Version Introduced | Supported | Comments
--- | --- | --- | ---
InputStream getBinaryStream () | 2.0 Core | Yes | The DB2 driver only supports with DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries. 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 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries. 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 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries. 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 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries. The Informix driver requires that the pattern parameter (which specifies the Blob object designating the BLOB value for which to search) be less than or equal to a maximum value of 4096 bytes. The SQL Server and Sybase drivers support using with LONGVARBINARY data types.
long position (byte[], long) | 2.0 Core | Yes | The DB2 driver only supports with DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries. The Informix driver requires that the pattern parameter (which specifies the byte array for which to search) be less than or equal to a maximum value of 4096 bytes. The SQL Server and Sybase drivers support using with LONGVARBINARY data types.
OutputStream setBinaryStream (long) | 3.0 | Yes | The DB2 driver only supports with DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries. 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 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries. 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 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries. 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 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries. The SQL Server and Sybase drivers support using with LONGVARBINARY data types.

## CallableStatement Object

Table A-4 CallableStatement Object

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

Table A-5 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 | 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.

## Connection Object

Table A-6 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 | 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 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries.
void rollback () | 1.0 | Yes |
void rollback (Savepoint) | 3.0 | Yes | The DB2 driver only supports with DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries.
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 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries. In addition, the DB2 driver only supports multiple nested savepoints for DB2 8.2 for Linux/UNIX/Windows.
Savepoint setSavepoint (String) | 3.0 | Yes | The DB2 driver only supports with DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries. In addition, the DB2 driver only supports multiple nested savepoints for DB2 v8.2 for Linux/UNIX/Windows.
void setTransactionIsolation (int) | 1.0 | Yes |
void setTypeMap (Map) | 2.0 Core | Yes | Ignored.

## DatabaseMetaData Object

Table A-7 DababaseMetaData 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 | 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 |

## Driver Object

Table A-8 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 Object

Table A-9 ParameterMetaData Object

ParameterMetaData Object Methods | Version Introduced | Supported | Comments
--- | --- | --- | ---
String getParameterClassName (int) | 3.0 | Yes | The DB2 driver supports parameter metadata for stored procedures for DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries.
int getParameterCount () | 3.0 | Yes |
int getParameterMode (int) | 3.0 | Yes | The DB2 driver supports parameter metadata for stored procedures for DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries.
int getParameterType (int) | 3.0 | Yes | The DB2 driver supports parameter metadata for stored procedures for DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries.
String getParameterTypeName (int) | 3.0 | Yes | The DB2 driver supports parameter metadata for stored procedures for DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries.
int getPrecision (int) | 3.0 | Yes | The DB2 driver supports parameter metadata for stored procedures for DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries.
int getScale (int) | 3.0 | Yes | The DB2 driver supports parameter metadata for stored procedures for DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries.
int isNullable (int) | 3.0 | Yes | The DB2 driver supports parameter metadata for stored procedures for DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries.
boolean isSigned (int) | 3.0 | Yes | The DB2 driver supports parameter metadata for stored procedures for DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries.
boolean jdbcCompliant () | 1.0 | Yes |

## PreparedStatement Object

Table A-10 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 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries.
void setBlob (int, Blob) | 2.0 Core | Yes | The DB2 driver only supports with DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries. 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 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries.
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.

## Ref Object

Table A-11 Ref Object

Ref Object Methods | Version Introduced | Supported | Comments
--- | --- | --- | ---
(all) | 2.0 Core | No |

## ResultSet Object

Table A-12 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 supports for all DB2 versions when retrieving BINARY, VARBINARY, and LONGVARBINARY data. The DB2 driver only supports with DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries when retrieving BLOB data.
InputStream getBinaryStream (String) | 1.0 | Yes | The DB2 driver supports for all DB2 versions when retrieving BINARY, VARBINARY, and LONGVARBINARY data. The DB2 driver only supports with DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries when retrieving BLOB data.
Blob getBlob (int) | 2.0 Core | Yes | The DB2 driver only supports with DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries. 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 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries. 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 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries when retrieving BLOB data.
byte [] getBytes (String) | 1.0 | Yes | The DB2 driver supports for all DB2 versions when retrieving BINARY, VARBINARY, and LONGVARBINARY data. The DB2 driver only supports with DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries 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 | Returns a Long object when called on DB2 Bigint columns.
Object getObject (int, Map) | 2.0 Core | Yes |
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 | Yes | The DB2 driver only supports with DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries. The SQL Server and Sybase drivers support using with LONGVARBINARY data types.
void updateBlob (String, Blob) | 3.0 | Yes | The DB2 driver only supports with DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries. 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 |

## ResultSetMetaData Object

Table A-13 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 | 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 |

## SavePoint Object

Table A-14 SavePoint Object

SavePoint Object Methods | Version Introduced | Supported | Comments
--- | --- | --- | ---
(all) | 3.0 | Yes | The DB2 driver only supports with DB2 v8.1 and v8.2 for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and V5R3 for iSeries.

## Statement Object

Table A-15 Statement Object

Statement Object Methods | Version Introduced | Supported | Comments
--- | --- | --- | ---
void addBatch (String) | 2.0 Core | Yes | Throws "invalid method call" exception for PreparedStatement and CallableStatement.
void cancel () | 1.0 | Yes | The DB2 driver cancels the execution of the statement with DB2 v8.1 and v8.2 for Linux/UNIX/Windows and DB2 v8.1 for z/OS. If the statement is cancelled by the database server, the driver throws an exception indicating that it was cancelled. The DB2 driver throws an "unsupported method" exception with other DB2 versions. The Informix driver throws an "unsupported method" exception. The Oracle, SQL Server, and Sybase drivers cancel the execution of the statement. If the statement is cancelled by the database server, the driver throws an exception indicating that it was cancelled.
void clearBatch () | 2.0 Core | Yes |
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, and Sybase drivers return the last value inserted into an identity column. If an identity column does not exist in the table, the drivers return an empty result set. The Informix driver returns the last value inserted into a Serial or Serial8 column. If a Serial or Serial8 column does not exist in the table, the driver returns an empty result set. 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 | The DB2 driver returns the timeout value, in seconds, set for the statement with DB2 v8.1 and v8.2 for Linux/UNIX/Windows and DB2 v8.1 for z/OS. The DB2 driver returns 0 with other DB2 versions. The Informix driver returns 0. The Oracle, SQL Server, and Sybase drivers return the timeout value, in seconds, set for the statement.
ResultSet getResultSet () | 1.0 | Yes |
int getResultSetConcurrency () | 2.0 Core | Yes |
int getResultSetHoldability () | 3.0 | Yes |
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 | The DB2 driver supports setting a timeout value, in seconds, for a statement with DB2 v8.1 and v8.2 for Linux/UNIX/Windows and DB2 v8.1 for z/OS. If the execution of the statement exceeds the timeout value, the statement is timed out by the database server, and the driver throws an exception indicating that the statement was timed out. The DB2 driver throws an "unsupported method" exception with other DB2 versions. The Informix driver throws an "unsupported method" exception. The Oracle, SQL Server, and Sybase driver supports setting a timeout value, in seconds, for a statement. If the execution of the statement exceeds the timeout value, the statement is timed out by the database server, and the driver throws an exception indicating that the statement was timed out.

## Struct Object

Table A-16 Struct Object

Statement Object Methods | Version Introduced | Supported | Comments
--- | --- | --- | ---
(all) | 2.0 | No |

## XAConnection Object

Table A-17 XAConnection Object

XAConnection Object Methods | Version Introduced | Supported | Comments
--- | --- | --- | ---
(all) | 2.0 Optional | Yes | Supported for all drivers, except for DB2 v7.x for Linux/UNIX/Windows, DB2 v7.x and v8.1 for z/OS, and DB2 for iSeries.

## XADataSource Object

Table A-18 XADataSource Object

XADataSource Object Methods | Version Introduced | Supported | Comments
--- | --- | --- | ---
(all) | 2.0 Optional | Yes | Supported for all drivers, except for DB2 v7.x for Linux/UNIX/Windows, DB2 v7.x and v8.1for z/OS, and DB2 for iSeries.

## XAResource Object

Table A-19 XAResource Object

XAResource Object Methods | Version Introduced | Supported | Comments
--- | --- | --- | ---
(all) | 2.0 Optional | Yes | Support for all drivers except for DB2 UDB 7.x, DB2 OS/390 7.x and z/OS, and DB2 iSeries.