DB2 Version 9.7 for Linux, UNIX, and Windows

Driver support for JDBC APIs

The JDBC drivers that are supported by DB2® and IBM® Informix® database systems have different levels of support for JDBC methods.

The following tables list the JDBC interfaces and indicate which drivers supports them. The drivers and their supported platforms are:
Table 1. JDBC drivers for DB2 and IBM Informix database systems
JDBC driver name Associated data source
IBM Data Server Driver for JDBC and SQLJ DB2 for Linux, UNIX, and Windows, DB2 for z/OS®, or IBM Informix
DB2 JDBC Type 2 Driver for Linux, UNIX and Windows (deprecated) DB2 for Linux, UNIX, and Windows
IBM Informix JDBC Driver (IBM Informix JDBC Driver) IBM Informix
If a method has JDBC 2.0 and JDBC 3.0 forms, the IBM Data Server Driver for JDBC and SQLJ supports all forms. The DB2 JDBC Type 2 Driver for Linux, UNIX and Windows supports only the JDBC 2.0 forms.
Table 2. Support for java.sql.Array methods
JDBC method IBM Data Server Driver for JDBC and SQLJ1 support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
free2 Yes No No
getArray Yes No Yes
getBaseType Yes No Yes
getBaseTypeName Yes No Yes
getResultSet Yes No Yes
Notes:
  1. Under the IBM Data Server Driver for JDBC and SQLJ, Array methods are supported for connections to DB2 for Linux, UNIX, and Windows data sources only.
  2. This is a JDBC 4.0 method.
Table 3. Support for java.sql.BatchUpdateException methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Exception Yes Yes Yes
getUpdateCounts Yes Yes Yes
Table 4. Support for java.sql.Blob methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
free1 Yes No No
getBinaryStream Yes2 Yes Yes
getBytes Yes Yes Yes
length Yes Yes Yes
position Yes Yes Yes
setBinaryStream3 Yes No No
setBytes3 Yes No No
truncate3 Yes No No
Notes:
  1. This is a JDBC 4.0 method.
  2. Supported forms of this method include the following JDBC 4.0 form:
    getBinaryStream(long pos, long length)
  3. For versions of the IBM Data Server Driver for JDBC and SQLJ before version 3.50, these methods cannot be used if a Blob is passed to a stored procedure as an IN or INOUT parameter, and the methods are used on the Blob in the stored procedure.
Table 5. Support for java.sql.CallableStatement methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.sql.Statement Yes Yes Yes
Methods inherited from java.sql.PreparedStatement Yes1 Yes Yes
getArray No No No
getBigDecimal Yes3 Yes Yes
getBlob Yes3 Yes Yes
getBoolean Yes3 Yes Yes
getByte Yes3 Yes Yes
getBytes Yes3 Yes Yes
getClob Yes3 Yes Yes
getDate Yes3,5 Yes5 Yes
getDouble Yes3 Yes Yes
getFloat Yes3 Yes Yes
getInt Yes3 Yes Yes
getLong Yes3 Yes Yes
getObject Yes3,4,6 Yes6 Yes
getRef No No No
getRowId2 Yes No No
getShort Yes3 Yes Yes
getString Yes3 Yes Yes
getTime Yes3,5 Yes5 Yes
getTimestamp Yes3,5 Yes5 Yes
getURL Yes No No
registerOutParameter Yes7 Yes7 Yes7
setAsciiStream Yes8 No Yes
setBigDecimal Yes8 No Yes
setBinaryStream Yes8 No Yes
setBoolean Yes8 No Yes
setByte Yes8 No Yes
setBytes Yes8 No Yes
setCharacterStream Yes8 No Yes
setDate Yes8 No Yes
setDouble Yes8 No Yes
setFloat Yes8 No Yes
setInt Yes8 No Yes
setLong Yes8 No Yes
setNull Yes8,,9 No Yes
setObject Yes8, No Yes
setShort Yes8 No Yes
setString Yes8 No Yes
setTime Yes8 No Yes
setTimestamp Yes8 No Yes
setURL Yes No No
wasNull Yes Yes Yes
Notes:
  1. The inherited getParameterMetaData method is not supported if the data source is DB2 for z/OS.
  2. This is a JDBC 4.0 method.
  3. The following forms of CallableStatement.getXXX methods are not supported if the data source is DB2 for z/OS: 
    getXXX(String parameterName)
  4. The following JDBC 4.1 forms of getObject are supported:
    getObject(int parameterIndex, java.lang.Class<T> type)
getObject(java.lang.String parameterName, java.lang.Class<T> type)
  5. The database server does no timezone adjustment for datetime values. The JDBC driver adjusts a value for the local timezone after retrieving the value from the server if you specify a form of the getDate, getTime, or getTimestamp method that includes a java.util.Calendar parameter.
  6. The following form of the getObject method is not supported: 
    getObject(int parameterIndex, java.util.Map  map)
  7. The following form of the registerOutParameter method is not supported: 
    registerOutParameter(int parameterIndex, int jdbcType, String typeName)
  8. The following forms of CallableStatement.setXXX methods are not supported if the data source is DB2 for z/OS: 
    setXXX(String parameterName,…)
  9. The following form of setNull is not supported: 
    setNull(int parameterIndex, int jdbcType, String typeName)
Table 6. Support for java.sql.Clob methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
free1 Yes No No
getAsciiStream Yes Yes Yes
getCharacterStream Yes2 Yes Yes
getSubString Yes Yes Yes
length Yes Yes Yes
position Yes Yes Yes
setAsciiStream3 Yes No Yes
setCharacterStream3 Yes No Yes
setString3 Yes No Yes
truncate3 Yes No Yes
Notes:
  1. This is a JDBC 4.0 method.
  2. Supported forms of this method include the following JDBC 4.0 form:
    getCharacterStream(long pos, long length)
  3. For versions of the IBM Data Server Driver for JDBC and SQLJ before version 3.50, these methods cannot be used if a Clob is passed to a stored procedure as an IN or INOUT parameter, and the methods are used on the Clob in the stored procedure.
Table 7. Support for javax.sql.CommonDataSource methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
getLoginTimeout Yes Yes Yes
getLogWriter Yes Yes Yes
getParentLogger1 Yes No No
setLoginTimeout Yes Yes Yes
setLogWriter Yes Yes Yes
Notes:
  1. This is a JDBC 4.1 method.
Table 8. Support for java.sql.Connection methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
abort1 Yes No No
clearWarnings Yes Yes Yes
close Yes Yes Yes
commit Yes Yes Yes
createArrayOf2 Yes No No
createBlob2 Yes No No
createClob2 Yes No No
createStatement Yes Yes3 Yes
createStruct2 Yes No No
getAutoCommit Yes Yes Yes
getCatalog Yes Yes Yes
getClientInfo2 Yes No No
getHoldability Yes No No
getMetaData Yes Yes Yes
getNetworkTimeout1 Yes No No
getSchema1 Yes No No
getTransactionIsolation Yes Yes Yes
getTypeMap No No Yes
getWarnings Yes Yes Yes
isClosed Yes Yes Yes
isReadOnly Yes Yes Yes
isValid2,4 Yes No No
nativeSQL Yes Yes Yes
prepareCall Yes5 Yes Yes
prepareStatement Yes Yes3 Yes
releaseSavepoint Yes No No
rollback Yes Yes3 Yes
setAutoCommit Yes Yes Yes
setCatalog Yes Yes No
setClientInfo2 Yes No No
setNetworkTimeout1 Yes No No
setReadOnly Yes6 Yes No
setSavepoint Yes No No
setSchema1 Yes No No
setTransactionIsolation Yes Yes Yes
setTypeMap No No Yes
Notes:
  1. This is a JDBC 4.1 method.
  2. This is a JDBC 4.0 method.
  3. The DB2 JDBC Type 2 Driver for Linux, UNIX and Windows does not support the JDBC 3.0 forms of this method.
  4. Under IBM Data Server Driver for JDBC and SQLJ type 4 connectivity, an SQLException is thrown if the timeout parameter value is less than 0. Under IBM Data Server Driver for JDBC and SQLJ type 2 connectivity, an SQLException is thrown if the if the timeout parameter value is not 0.
  5. If the stored procedure in the CALL statement is on DB2 for z/OS, the parameters of the CALL statement cannot be expressions.
  6. The driver does not use the setting. For the IBM Data Server Driver for JDBC and SQLJ, a connection can be set as read-only through the readOnly property for a Connection or DataSource object.
Table 9. Support for javax.sql.ConnectionEvent methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.util.EventObject Yes Yes Yes
getSQLException Yes Yes Yes
Table 10. Support for javax.sql.ConnectionEventListener methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
connectionClosed Yes Yes Yes
connectionErrorOccurred Yes Yes Yes
Table 11. Support for javax.sql.ConnectionPoolDataSource methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
getLoginTimeout Yes Yes Yes
getLogWriter Yes Yes Yes
getPooledConnection Yes Yes Yes
setLoginTimeout Yes1 Yes Yes
setLogWriter Yes Yes Yes
Note:
  1. This method is not supported for IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on DB2 for z/OS.
Table 12. Support for java.sql.DatabaseMetaData methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
allProceduresAreCallable Yes Yes Yes
allTablesAreSelectable Yes1 Yes Yes1
dataDefinitionCausesTransactionCommit Yes Yes Yes
dataDefinitionIgnoredInTransactions Yes Yes Yes
deletesAreDetected Yes Yes Yes
doesMaxRowSizeIncludeBlobs Yes Yes Yes
generatedKeyAlwaysReturned2 Yes No No
getAttributes Yes3 No No
getBestRowIdentifier Yes Yes Yes
getCatalogs Yes Yes Yes
getCatalogSeparator Yes Yes Yes
getCatalogTerm Yes Yes Yes
getClientInfoProperties7 Yes No No
getColumnPrivileges Yes Yes Yes
getColumns Yes8 Yes11 Yes11
getConnection Yes Yes Yes
getCrossReference Yes Yes Yes
getDatabaseMajorVersion Yes No No
getDatabaseMinorVersion Yes No No
getDatabaseProductName Yes Yes Yes
getDatabaseProductVersion Yes Yes Yes
getDefaultTransactionIsolation Yes Yes Yes
getDriverMajorVersion Yes Yes Yes
getDriverMinorVersion Yes Yes Yes
getDriverName Yes9 Yes Yes
getDriverVersion Yes Yes Yes
getExportedKeys Yes Yes Yes
getFunctionColumns7 Yes No No
getFunctions7 Yes No No
getExtraNameCharacters Yes Yes Yes
getIdentifierQuoteString Yes Yes Yes
getImportedKeys Yes Yes Yes
getIndexInfo Yes Yes Yes
getJDBCMajorVersion Yes No No
getJDBCMinorVersion Yes No No
getMaxBinaryLiteralLength Yes Yes Yes
getMaxCatalogNameLength Yes Yes Yes
getMaxCharLiteralLength Yes Yes Yes
getMaxColumnNameLength Yes Yes Yes
getMaxColumnsInGroupBy Yes Yes Yes
getMaxColumnsInIndex Yes Yes Yes
getMaxColumnsInOrderBy Yes Yes Yes
getMaxColumnsInSelect Yes Yes Yes
getMaxColumnsInTable Yes Yes Yes
getMaxConnections Yes Yes Yes
getMaxCursorNameLength Yes Yes Yes
getMaxIndexLength Yes Yes Yes
getMaxProcedureNameLength Yes Yes Yes
getMaxRowSize Yes Yes Yes
getMaxSchemaNameLength Yes Yes Yes
getMaxStatementLength Yes Yes Yes
getMaxStatements Yes Yes Yes
getMaxTableNameLength Yes Yes Yes
getMaxTablesInSelect Yes Yes Yes
getMaxUserNameLength Yes Yes Yes
getNumericFunctions Yes Yes Yes
getPrimaryKeys Yes Yes Yes
getProcedureColumns Yes8 Yes Yes
getProcedures Yes8 Yes Yes
getProcedureTerm Yes Yes Yes
getPseudoColumns2 Yes No No
getResultSetHoldability Yes No No
getRowIdLifetime7 Yes No No
getSchemas Yes10 Yes11 Yes11
getSchemaTerm Yes Yes Yes
getSearchStringEscape Yes Yes Yes
getSQLKeywords Yes Yes Yes
getSQLStateType Yes No No
getStringFunctions Yes Yes Yes
getSuperTables Yes3 No No
getSuperTypes Yes3 No No
getSystemFunctions Yes Yes Yes
getTablePrivileges Yes Yes Yes
getTables Yes Yes11 Yes11
getTableTypes Yes Yes Yes
getTimeDateFunctions Yes Yes Yes
getTypeInfo Yes Yes Yes
getUDTs No Yes12 Yes12
getURL Yes Yes Yes
getUserName Yes Yes Yes
getVersionColumns Yes Yes Yes
insertsAreDetected Yes Yes Yes
isCatalogAtStart Yes Yes Yes
isReadOnly Yes Yes Yes
locatorsUpdateCopy Yes4 Yes Yes4
nullPlusNonNullIsNull Yes Yes Yes
nullsAreSortedAtEnd Yes5 Yes Yes5
nullsAreSortedAtStart Yes Yes Yes
nullsAreSortedHigh Yes6 Yes Yes6
nullsAreSortedLow Yes1 Yes Yes1
othersDeletesAreVisible Yes Yes Yes
othersInsertsAreVisible Yes Yes Yes
othersUpdatesAreVisible Yes Yes Yes
ownDeletesAreVisible Yes Yes Yes
ownInsertsAreVisible Yes Yes Yes
ownUpdatesAreVisible Yes Yes Yes
storesLowerCaseIdentifiers Yes1 Yes Yes1
storesLowerCaseQuotedIdentifiers Yes5 Yes Yes5
storesMixedCaseIdentifiers Yes Yes Yes
storesMixedCaseQuotedIdentifiers Yes Yes Yes
storesUpperCaseIdentifiers Yes6 Yes Yes6
storesUpperCaseQuotedIdentifiers Yes Yes Yes
supportsAlterTableWithAddColumn Yes Yes Yes
supportsAlterTableWithDropColumn Yes1 Yes Yes1
supportsANSI92EntryLevelSQL Yes Yes Yes
supportsANSI92FullSQL Yes Yes Yes
supportsANSI92IntermediateSQL Yes Yes Yes
supportsBatchUpdates Yes Yes Yes
supportsCatalogsInDataManipulation Yes1 Yes Yes1
supportsCatalogsInIndexDefinitions Yes Yes Yes
supportsCatalogsInPrivilegeDefinitions Yes Yes Yes
supportsCatalogsInProcedureCalls Yes1 Yes Yes1
supportsCatalogsInTableDefinitions Yes Yes Yes
SupportsColumnAliasing Yes Yes Yes
supportsConvert Yes Yes Yes
supportsCoreSQLGrammar Yes Yes Yes
supportsCorrelatedSubqueries Yes Yes Yes
supportsDataDefinitionAndDataManipulationTransactions Yes Yes Yes
supportsDataManipulationTransactionsOnly Yes Yes Yes
supportsDifferentTableCorrelationNames Yes5 Yes Yes5
supportsExpressionsInOrderBy Yes Yes Yes
supportsExtendedSQLGrammar Yes Yes Yes
supportsFullOuterJoins Yes4 Yes Yes4
supportsGetGeneratedKeys Yes No No
supportsGroupBy Yes Yes Yes
supportsGroupByBeyondSelect Yes Yes Yes
supportsGroupByUnrelated Yes Yes Yes
supportsIntegrityEnhancementFacility Yes Yes Yes
supportsLikeEscapeClause Yes Yes Yes
supportsLimitedOuterJoins Yes Yes Yes
supportsMinimumSQLGrammar Yes Yes Yes
supportsMixedCaseIdentifiers Yes Yes Yes
supportsMixedCaseQuotedIdentifiers Yes4 Yes Yes4
supportsMultipleOpenResults Yes6 No Yes6
supportsMultipleResultSets Yes6 Yes Yes6
supportsMultipleTransactions Yes Yes Yes
supportsNamedParameters Yes No No
supportsNonNullableColumns Yes Yes Yes
supportsOpenCursorsAcrossCommit Yes4 Yes Yes4
supportsOpenCursorsAcrossRollback Yes Yes Yes
supportsOpenStatementsAcrossCommit Yes4 Yes Yes4
supportsOpenStatementsAcrossRollback Yes4 Yes Yes4
supportsOrderByUnrelated Yes Yes Yes
supportsOuterJoins Yes Yes Yes
supportsPositionedDelete Yes Yes Yes
supportsPositionedUpdate Yes Yes Yes
supportsResultSetConcurrency Yes Yes Yes
supportsResultSetHoldability Yes No No
supportsResultSetType Yes Yes Yes
supportsSavepoints Yes No Yes
supportsSchemasInDataManipulation Yes Yes Yes
supportsSchemasInIndexDefinitions Yes Yes Yes
supportsSchemasInPrivilegeDefinitions Yes Yes Yes
supportsSchemasInProcedureCalls Yes Yes Yes
supportsSchemasInTableDefinitions Yes Yes Yes
supportsSelectForUpdate Yes Yes Yes
supportsStoredProcedures Yes Yes Yes
supportsSubqueriesInComparisons Yes Yes Yes
supportsSubqueriesInExists Yes Yes Yes
supportsSubqueriesInIns Yes Yes Yes
supportsSubqueriesInQuantifieds Yes Yes Yes
supportsSuperTables Yes No No
supportsSuperTypes Yes No No
supportsTableCorrelationNames Yes Yes Yes
supportsTransactionIsolationLevel Yes Yes Yes
supportsTransactions Yes Yes Yes
supportsUnion Yes Yes Yes
supportsUnionAll Yes Yes Yes
updatesAreDetected Yes Yes Yes
usesLocalFilePerTable Yes Yes Yes
usesLocalFiles Yes Yes Yes
Notes:
  1. DB2 data sources return false for this method. IBM Informix data sources return true.
  2. This is a JDBC 4.1 method.
  3. This method is supported for connections to DB2 for Linux, UNIX, and Windows and IBM Informix only.
  4. Under the IBM Data Server Driver for JDBC and SQLJ, DB2 data sources and IBM Informix data sources return true for this method. Under the IBM Informix JDBC Driver, IBM Informix data sources return false.
  5. Under the IBM Data Server Driver for JDBC and SQLJ, DB2 data sources and IBM Informix data sources return false for this method. Under the IBM Informix JDBC Driver, IBM Informix data sources return true.
  6. DB2 data sources return true for this method. IBM Informix data sources return false.
  7. This is a JDBC 4.0 method.
  8. This method returns the additional column that is described by the JDBC 4.0 specification.
  9. JDBC 3.0 and earlier implementations of the IBM Data Server Driver for JDBC and SQLJ return "IBM DB2 JDBC Universal Driver Architecture."

    The JDBC 4.0 implementation of the IBM Data Server Driver for JDBC and SQLJ returns "IBM Data Server Driver for JDBC and SQLJ."

  10. The JDBC 4.0 form and previous forms of this method are supported.
  11. The DB2 JDBC Type 2 Driver for Linux, UNIX and Windows does not support the JDBC 3.0 form of this method.
  12. The method can be executed, but it returns an empty ResultSet.
Table 13. Support for java.sql.DataSource methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
getConnection Yes Yes Yes
getLoginTimeout Yes Yes1 Yes
getLogWriter Yes Yes Yes
setLoginTimeout Yes2 Yes1 Yes
setLogWriter Yes Yes Yes
Notes:
  1. The DB2 JDBC Type 2 Driver does not use this setting.
  2. This method is not supported for IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on DB2 for z/OS.
Table 14. Support for java.sql.DataTruncation methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Throwable Yes Yes Yes
Methods inherited from java.sql.SQLException Yes Yes Yes
Methods inherited from java.sql.SQLWarning Yes Yes Yes
getDataSize Yes Yes Yes
getIndex Yes Yes Yes
getParameter Yes Yes Yes
getRead Yes Yes Yes
getTransferSize Yes Yes Yes
Table 15. Support for java.sql.Driver methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
acceptsURL Yes Yes Yes
connect Yes Yes Yes
getMajorVersion Yes Yes Yes
getMinorVersion Yes Yes Yes
getParentLogger Yes No No
getPropertyInfo Yes Yes Yes
jdbcCompliant Yes Yes Yes
Table 16. Support for java.sql.DriverManager methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
deregisterDriver Yes Yes Yes
getConnection Yes Yes Yes
getDriver Yes Yes Yes
getDrivers Yes Yes Yes
getLoginTimeout Yes Yes1 Yes
getLogStream Yes Yes Yes
getLogWriter Yes Yes Yes
println Yes Yes Yes
registerDriver Yes Yes Yes
setLoginTimeout Yes2 Yes1 Yes
setLogStream Yes Yes Yes
setLogWriter Yes Yes Yes
Notes:
  1. The DB2 JDBC Type 2 Driver does not use this setting.
  2. This method is not supported for IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on DB2 for z/OS.
Table 17. Support for java.sql.ParameterMetaData methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
getParameterClassName No No No
getParameterCount Yes No No
getParameterMode Yes No No
getParameterType Yes No No
getParameterTypeName Yes No No
getPrecision Yes No No
getScale Yes No No
isNullable Yes No No
isSigned Yes No No
Table 18. Support for javax.sql.PooledConnection methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
addConnectionEventListener Yes Yes Yes
addStatementEventListener1 Yes No No
close Yes Yes Yes
getConnection Yes Yes Yes
removeConnectionEventListener Yes Yes Yes
removeStatementEventListener1 Yes No No
Notes:
  1. This is a JDBC 4.0 method.
Table 19. Support for java.sql.PreparedStatement methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.sql.Statement Yes Yes Yes
addBatch Yes Yes Yes
clearParameters Yes Yes Yes
execute Yes Yes Yes
executeQuery Yes Yes Yes
executeUpdate Yes Yes Yes
getMetaData Yes Yes Yes
getParameterMetaData Yes Yes Yes
setArray No No No
setAsciiStream Yes1,2 Yes Yes
setBigDecimal Yes Yes Yes
setBinaryStream Yes1,3 Yes Yes
setBlob Yes4 Yes Yes
setBoolean Yes Yes Yes
setByte Yes Yes Yes
setBytes Yes Yes Yes
setCharacterStream Yes1,5 Yes Yes
setClob Yes6 Yes Yes
setDate Yes8 Yes8 Yes8
setDouble Yes Yes Yes
setFloat Yes Yes Yes
setInt Yes Yes Yes
setLong Yes Yes Yes
setNull Yes9 Yes9 Yes9
setObject Yes Yes Yes
setRef No No No
setRowId7 Yes No No
setShort Yes Yes Yes
setString Yes10 Yes10 Yes10
setTime Yes8 Yes8 Yes8
setTimestamp Yes8 Yes8 Yes8
setUnicodeStream Yes Yes Yes
setURL Yes Yes Yes
Notes:
  1. If the value of the length parameter is -1, all of the data from the InputStream or Reader is read and sent to the data source.
  2. Supported forms of this method include the following JDBC 4.0 forms:
    setAsciiStream(int parameterIndex, InputStream x, long length)
setAsciiStream(int parameterIndex, InputStream x)
  3. Supported forms of this method include the following JDBC 4.0 forms:
    setBinaryStream(int parameterIndex, InputStream x, long length)
setBinaryStream(int parameterIndex, InputStream x)
  4. Supported forms of this method include the following JDBC 4.0 form:
    setBlob(int parameterIndex, InputStream inputStream, long length)
  5. Supported forms of this method include the following JDBC 4.0 forms:
    setCharacterStream(int parameterIndex, Reader reader, long length)
setCharacterStream(int parameterIndex, Reader reader)
  6. Supported forms of this method include the following JDBC 4.0 form:
    setClob(int parameterIndex, Reader reader, long length)
  7. This is a JDBC 4.0 method.
  8. The database server does no timezone adjustment for datetime values. The JDBC driver adjusts a value for the local timezone before sending the value to the server if you specify a form of the setDate, setTime, or setTimestamp method that includes a java.util.Calendar parameter.
  9. The following form of setNull is not supported: 
    setNull(int parameterIndex, int jdbcType, String typeName)
  10. setString is not supported if the column has the FOR BIT DATA attribute or the data type is BLOB.
Table 20. Support for java.sql.Ref methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
get BaseTypeName No No No
Table 21. Support for java.sql.ResultSet methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
absolute Yes Yes Yes
afterLast Yes Yes Yes
beforeFirst Yes Yes Yes
cancelRowUpdates Yes No No
clearWarnings Yes Yes Yes
close Yes Yes Yes
deleteRow Yes No No
findColumn Yes Yes Yes
first Yes Yes Yes
getArray No No No
getAsciiStream Yes Yes Yes
getBigDecimal Yes Yes Yes
getBinaryStream Yes1 Yes Yes
getBlob Yes Yes Yes
getBoolean Yes Yes Yes
getByte Yes Yes Yes
getBytes Yes Yes Yes
getCharacterStream Yes Yes Yes
getClob Yes Yes Yes
getConcurrency Yes Yes Yes
getCursorName Yes Yes Yes
getDate Yes3 Yes3 Yes3
getDouble Yes Yes Yes
getFetchDirection Yes Yes Yes
getFetchSize Yes Yes Yes
getFloat Yes Yes Yes
getInt Yes Yes Yes
getLong Yes Yes Yes
getMetaData Yes Yes Yes
getObject Yes4 Yes4 Yes4
getRef No No No
getRow Yes Yes Yes
getRowId10 Yes No No
getShort Yes Yes Yes
getStatement Yes Yes Yes
getString Yes Yes Yes
getTime Yes3 Yes3 Yes3
getTimestamp Yes3 Yes3 Yes3
getType Yes Yes Yes
getUnicodeStream Yes Yes Yes
getURL Yes Yes Yes
getWarnings Yes Yes Yes
insertRow Yes No No
isAfterLast Yes Yes Yes
isBeforeFirst Yes Yes Yes
isFirst Yes Yes Yes
isLast Yes Yes Yes
last Yes Yes Yes
moveToCurrentRow Yes No No
moveToInsertRow Yes No No
next Yes Yes Yes
previous Yes Yes Yes
refreshRow Yes No No
relative Yes Yes Yes
rowDeleted Yes No No
rowInserted Yes No No
rowUpdated Yes No No
setFetchDirection Yes Yes Yes
setFetchSize Yes Yes Yes
updateArray No No No
updateAsciiStream Yes5 No No
updateBigDecimal Yes No No
updateBinaryStream Yes6 No No
updateBlob Yes7 No No
updateBoolean Yes No No
updateByte Yes No No
updateBytes Yes No No
updateCharacterStream Yes8 No No
updateClob Yes9 No No
updateDate Yes No No
updateDouble Yes No No
updateFloat Yes No No
updateInt Yes No No
updateLong Yes No No
updateNull Yes No No
updateObject Yes No No
updateRef No No No
updateRow Yes No No
updateRowId10 Yes No No
updateShort Yes No No
updateString Yes No No
updateTime Yes No No
updateTimestamp Yes No No
wasNull Yes Yes Yes
Notes:
  1. getBinaryStream is not supported for CLOB columns.
  2. getMetaData pads the schema name, if the returned schema name is less than 8 characters, to fill 8 characters.
  3. The database server does no timezone adjustment for datetime values. The JDBC driver adjusts a value for the local timezone after retrieving the value from the server if you specify a form of the getDate, getTime, or getTimestamp method that includes a java.util.Calendar parameter.
  4. The following form of the getObject method is not supported: 
    getObject(int parameterIndex, java.util.Map  map)
  5. Supported forms of this method include the following JDBC 4.0 forms:
    updateAsciiStream(int columnIndex, InputStream x)
updateAsciiStream(String columnLabel, InputStream x)
updateAsciiStream(int columnIndex, InputStream x, long length)
updateAsciiStream(String columnLabel, InputStream x, long length)
  6. Supported forms of this method include the following JDBC 4.0 forms:
    updateBinaryStream(int columnIndex, InputStream x)
updateBinaryStream(String columnLabel, InputStream x)
updateBinaryStream(int columnIndex, InputStream x, long length)
updateBinaryStream(String columnLabel, InputStream x, long length)
  7. Supported forms of this method include the following JDBC 4.0 forms:
    updateBlob(int columnIndex, InputStream x)
updateBlob(String columnLabel, InputStream x)
updateBlob(int columnIndex, InputStream x, long length)
updateBlob(String columnLabel, InputStream x, long length)
  8. Supported forms of this method include the following JDBC 4.0 forms:
    updateCharacterStream(int columnIndex, Reader reader)
updateCharacterStream(String columnLabel, Reader reader)
updateCharacterStream(int columnIndex, Reader reader, long length)
updateCharacterStream(String columnLabel, Reader reader, long length)
  9. Supported forms of this method include the following JDBC 4.0 forms:
    updateClob(int columnIndex, Reader reader)
updateClob(String columnLabel, Reader reader)
updateClob(int columnIndex, Reader reader, long length)
updateClob(String columnLabel, Reader reader, long length)
  10. This is a JDBC 4.0 method.
Table 22. Support for java.sql.ResultSetMetaData methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
getCatalogName Yes Yes Yes
getColumnClassName No Yes Yes
getColumnCount Yes Yes Yes
getColumnDisplaySize Yes Yes Yes
getColumnLabel Yes Yes Yes
getColumnName Yes Yes Yes
getColumnType Yes Yes Yes
getColumnTypeName Yes Yes Yes
getPrecision Yes Yes Yes
getScale Yes Yes Yes
getSchemaName Yes Yes Yes
getTableName Yes1 Yes Yes
isAutoIncrement Yes Yes Yes
isCaseSensitive Yes Yes Yes
isCurrency Yes Yes Yes
isDefinitelyWritable Yes Yes Yes
isNullable Yes Yes Yes
isReadOnly Yes Yes Yes
isSearchable Yes Yes Yes
isSigned Yes Yes Yes
isWritable Yes Yes Yes
Notes:
  1. For IBM Informix data sources, getTableName does not return a value.
  2. getSchemaName pads the schema name, if the returned schema name is less than 8 characters, to fill 8 characters.
Table 23. Support for java.sql.RowId methods1
JDBC method IBM Data Server Driver for JDBC and SQLJ support2 DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
equals Yes No No
getBytes Yes No No
hashCode No No No
toString Yes No No
Notes:
  1. These methods are JDBC 4.0 methods.
  2. These methods are supported for connections to DB2 for z/OS, DB2 for i, and IBM Informix data sources.
Table 24. Support for java.sql.SQLClientInfoException methods1
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Exception Yes No No
Methods inherited from java.lang.Throwable Yes No No
Methods inherited from java.lang.Object Yes No No
getFailedProperties Yes No No
Note:
  1. This is a JDBC 4.0 class.
Table 25. Support for java.sql.SQLData methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
getSQLTypeName No No No
readSQL No No No
writeSQL No No No
Table 26. Support for java.sql.SQLDataException methods1
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Exception Yes No No
Methods inherited from java.lang.Throwable Yes No No
Methods inherited from java.lang.Object Yes No No
Note:
  1. This is a JDBC 4.0 class.
Table 27. Support for java.sql.SQLDataException methods1
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Exception Yes No No
Methods inherited from java.lang.Throwable Yes No No
Methods inherited from java.lang.Object Yes No No
Note:
  1. This is a JDBC 4.0 class.
Table 28. Support for java.sql.SQLException methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Exception Yes Yes Yes
getSQLState Yes Yes Yes
getErrorCode Yes Yes Yes
getNextException Yes Yes Yes
setNextException Yes Yes Yes
Table 29. Support for java.sql.SQLFeatureNotSupported methods1
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Exception Yes No No
Methods inherited from java.lang.Throwable Yes No No
Methods inherited from java.lang.Object Yes No No
Note:
  1. This is a JDBC 4.0 class.
Table 30. Support for java.sql.SQLInput methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
readArray No No No
readAsciiStream No No No
readBigDecimal No No No
readBinaryStream No No No
readBlob No No No
readBoolean No No No
readByte No No No
readBytes No No No
readCharacterStream No No No
readClob No No No
readDate No No No
readDouble No No No
readFloat No No No
readInt No No No
readLong No No No
readObject No No No
readRef No No No
readShort No No No
readString No No No
readTime No No No
readTimestamp No No No
wasNull No No No
Table 31. Support for java.sql.SQLIntegrityConstraintViolationException methods1
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Exception Yes No No
Methods inherited from java.lang.Throwable Yes No No
Methods inherited from java.lang.Object Yes No No
Note:
  1. This is a JDBC 4.0 class.
Table 32. Support for java.sql.SQLInvalidAuthorizationSpecException methods1
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Exception Yes No No
Methods inherited from java.lang.Throwable Yes No No
Methods inherited from java.lang.Object Yes No No
Note:
  1. This is a JDBC 4.0 class.
Table 33. Support for java.sql.SQLNonTransientConnectionException methods1
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Exception Yes No No
Methods inherited from java.lang.Throwable Yes No No
Methods inherited from java.lang.Object Yes No No
Note:
  1. This is a JDBC 4.0 class.
Table 34. Support for java.sql.SQLNonTransientException methods1
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Exception Yes No No
Methods inherited from java.lang.Throwable Yes No No
Methods inherited from java.lang.Object Yes No No
Note:
  1. This is a JDBC 4.0 class.
Table 35. Support for java.sql.SQLOutput methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
writeArray No No No
writeAsciiStream No No No
writeBigDecimal No No No
writeBinaryStream No No No
writeBlob No No No
writeBoolean No No No
writeByte No No No
writeBytes No No No
writeCharacterStream No No No
writeClob No No No
writeDate No No No
writeDouble No No No
writeFloat No No No
writeInt No No No
writeLong No No No
writeObject No No No
writeRef No No No
writeShort No No No
writeString No No No
writeStruct No No No
writeTime No No No
writeTimestamp No No No
Table 36. Support for java.sql.SQLRecoverableException methods1
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Exception Yes No No
Methods inherited from java.lang.Throwable Yes No No
Methods inherited from java.lang.Object Yes No No
Note:
  1. This is a JDBC 4.0 class.
Table 37. Support for java.sql.SQLSyntaxErrorException methods1
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Exception Yes No No
Methods inherited from java.lang.Throwable Yes No No
Methods inherited from java.lang.Object Yes No No
Note:
  1. This is a JDBC 4.0 class.
Table 38. Support for java.sql.SQLTimeoutException methods1
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Exception Yes No No
Methods inherited from java.lang.Throwable Yes No No
Methods inherited from java.lang.Object Yes No No
Note:
  1. This is a JDBC 4.0 class.
Table 39. Support for java.sql.SQLTransientConnectionException methods1
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Exception Yes No No
Methods inherited from java.lang.Throwable Yes No No
Methods inherited from java.lang.Object Yes No No
Note:
  1. This is a JDBC 4.0 class.
Table 40. Support for java.sql.SQLTransientException methods1
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Exception Yes No No
Methods inherited from java.lang.Throwable Yes No No
Methods inherited from java.lang.Object Yes No No
Note:
  1. This is a JDBC 4.0 class.
Table 41. Support for java.sql.SQLTransientRollbackException methods1
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from java.lang.Exception Yes No No
Methods inherited from java.lang.Throwable Yes No No
Methods inherited from java.lang.Object Yes No No
Note:
  1. This is a JDBC 4.0 class.
Table 42. Support for java.sql.SQLXML methods1
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
free Yes No No
getBinaryStream Yes No No
getCharacterStream Yes No No
getSource Yes No No
getString Yes No No
setBinaryStream Yes No No
setCharacterStream Yes No No
setResult Yes No No
setString Yes No No
Notes:
  1. These are JDBC 4.0 methods. These methods are not supported for connections to IBM Informix servers.
Table 43. Support for java.sql.Statement methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
abort1 Yes No No
addBatch Yes Yes Yes
cancel Yes2 Yes3 Yes
clearBatch Yes Yes Yes
clearWarnings Yes Yes Yes
close Yes Yes Yes
closeOnCompletion1 Yes No No
execute Yes Yes4 Yes
executeBatch Yes Yes Yes
executeQuery Yes Yes Yes
executeUpdate Yes Yes4 Yes
getConnection Yes Yes Yes
getFetchDirection Yes Yes Yes
getFetchSize Yes Yes Yes
getGeneratedKeys Yes No No
getMaxFieldSize Yes Yes Yes
getMaxRows Yes Yes Yes
getMoreResults Yes Yes4 Yes
getQueryTimeout Yes9,7 Yes Yes
getResultSet Yes Yes Yes
getResultSetConcurrency Yes Yes Yes
getResultSetHoldability Yes No No
getResultSetType Yes Yes Yes
getUpdateCount5 Yes Yes Yes
getWarnings Yes Yes Yes
isCloseOnCompletion1 Yes No No
isClosed10 Yes No No
isPoolable10 Yes No No
setCursorName Yes Yes Yes
setEscapeProcessing Yes Yes Yes
setFetchDirection Yes Yes Yes
setFetchSize Yes Yes Yes
setMaxFieldSize Yes Yes Yes
setMaxRows Yes Yes Yes
setPoolable10 Yes No No
setQueryTimeout Yes6,7,8,9 Yes Yes
Notes:
  1. This is a JDBC 4.1 method.
  2. For the IBM Data Server Driver for JDBC and SQLJ, Statement.cancel is supported only in the following environments:
    • Type 2 and type 4 connectivity from a Linux, UNIX, or Windows client to a DB2 for Linux, UNIX, and Windows server, Version 8 or later
    • Type 2 and type 4 connectivity from a Linux, UNIX, or Windows client to a DB2 for z/OS server, Version 9 or later
    • Type 4 connectivity from a z/OS client to a DB2 for Linux, UNIX, and Windows server, Version 8 or later
    • Type 4 connectivity from a z/OS client to a DB2 for z/OS server, Version 8 or later

    The action that the IBM Data Server Driver for JDBC and SQLJ takes when the application executes Statement.cancel is also dependent on the setting of the DB2BaseDataSource.interruptProcessingMode property.

  3. For the DB2 JDBC Type 2 Driver for Linux, UNIX and Windows, Statement.cancel is supported only in the following environments:
    • Connections to a DB2 for Linux, UNIX, and Windows server, Version 8 or later
    • Connections to a DB2 for z/OS server, Version 9 or later
  4. The DB2 JDBC Type 2 Driver for Linux, UNIX and Windows does not support the JDBC 3.0 form of this method.
  5. Not supported for stored procedure ResultSets.
  6. For DB2 for i, this method is supported only for a seconds value of 0.
  7. For IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on DB2 for z/OS, Statement.setQueryTimeout is supported only if Connection or DataSource property queryTimeoutInterruptProcessingMode is set to INTERRUPT_PROCESSING_MODE_CLOSE_SOCKET.
  8. For IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on DB2 for Linux, UNIX, and Windows, Statement.setQueryTimeout is supported only if Connection or DataSource property queryTimeoutInterruptProcessingMode is set to INTERRUPT_PROCESSING_MODE_STATEMENT_CANCEL.
  9. For the IBM Data Server Driver for JDBC and SQLJ Version 4.0 and later, Statement.setQueryTimeout is supported for the following methods:
    • Statement.execute
    • Statement.executeUpdate
    • Statement.executeQuery

    Statement.setQueryTimeout is not supported for the Statement.executeBatch method.

  10. This is a JDBC 4.0 method.
Table 44. Support for java.sql.Struct methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
getSQLTypeName No No No
getAttributes No No No
Table 45. Support for java.sql.Wrapper methods
JDBC method1 IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
isWrapperFor Yes No No
unWrap Yes No No
Notes:
  1. These are JDBC 4.0 methods.
Table 46. Support for javax.sql.XAConnection methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support1 DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
Methods inherited from javax.sql.PooledConnection Yes Yes Yes
getXAResource Yes Yes Yes
Notes:
  1. These methods are supported for IBM Data Server Driver for JDBC and SQLJ type 2 connectivity to a DB2 for Linux, UNIX, and Windows server or IBM Data Server Driver for JDBC and SQLJ type 4 connectivity.
Table 47. Support for javax.sql.XADataSource methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
getLoginTimeout Yes Yes Yes
getLogWriter Yes Yes Yes
getXAConnection Yes Yes Yes
setLoginTimeout Yes Yes Yes
setLogWriter Yes Yes Yes
Table 48. Support for javax.transaction.xa.XAResource methods
JDBC method IBM Data Server Driver for JDBC and SQLJ support DB2 JDBC Type 2 Driver for Linux, UNIX and Windows support IBM Informix JDBC Driver support
commit Yes1 Yes Yes
end Yes1,2 Yes Yes
forget Yes1 Yes Yes
getTransactionTimeout Yes3 Yes Yes
isSameRM Yes1 Yes Yes
prepare Yes1 Yes Yes
recover Yes1 Yes Yes
rollback Yes1 Yes Yes
setTransactionTimeout Yes3 Yes Yes
start Yes1 Yes Yes
Notes:
  1. This method is supported for IBM Data Server Driver for JDBC and SQLJ type 2 connectivity to a DB2 for Linux, UNIX, and Windows server or IBM Data Server Driver for JDBC and SQLJ type 4 connectivity.
  2. When the end method is called, the IBM Data Server Driver for JDBC and SQLJ closes the underlying cursor, even if the TMSUSPEND flag is specified.
  3. This method is supported for IBM Data Server Driver for JDBC and SQLJ type 4 connectivity to DB2 for Linux, UNIX, and Windows Version 9.1 or later.
Parent topic: JDBC and SQLJ reference information
Related reference:
JDBC differences between the current IBM Data Server Driver for JDBC and SQLJ and earlier DB2 JDBC drivers