> Type 4 JDBC Drivers > JDBC Support

Type 4 JDBC Drivers

     Previous  Next    Open TOC in new window  Open Index in new window  View as PDF - New Window  Get Adobe Reader - New Window
Content starts here

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.

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.


  Back to Top       Previous  Next