This appendix provides information about JDBC compatibility and developing JDBC applications using WebLogic Type 4 JDBC drivers.
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
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| Blob getBlob (int)
| 2.0 Core
| Yes
| The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
| Blob getBlob (String)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| boolean getBoolean (int)
| 1.0
| Yes
|
|
| boolean getBoolean (String)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| byte getByte (int)
| 1.0
| Yes
|
|
| byte getByte (String)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| byte [] getBytes (int)
| 1.0
| Yes
|
|
| byte [] getBytes (String)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| Clob getClob (int)
| 2.0 Core
| Yes
|
|
| Clob getClob (String)
| 3.0
| Yes
| Supported for the SQL Server driver only using with data types that map to the JDBC LONGVARCHAR data type.
All other drivers throw "unsupported method" exception.
|
| Date getDate (int)
| 1.0
| Yes
|
|
| Date getDate (int, Calendar)
| 2.0 Core
| Yes
|
|
| Date getDate (String)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| Date getDate (String, Calendar)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| double getDouble (int)
| 1.0
| Yes
|
|
| double getDouble (String)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| float getFloat (int)
| 1.0
| Yes
|
|
| float getFloat (String)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| int getInt (int)
| 1.0
| Yes
|
|
| int getInt (String)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| long getLong (int)
| 1.0
| Yes
|
|
| long getLong (String)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| Object getObject (int)
| 1.0
| Yes
|
|
| Object getObject (int, Map)
| 2.0 Core
| Yes
| Map ignored.
|
| Object getObject (String)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| Object getObject (String, Map)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
Map ignored.
|
| 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
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| String getString (int)
| 1.0
| Yes
|
|
| String getString (String)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| Time getTime (int)
| 1.0
| Yes
|
|
| Time getTime (int, Calendar)
| 2.0 Core
| Yes
|
|
| Time getTime (String)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| Time getTime (String, Calendar)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| Timestamp getTimestamp (int)
| 1.0
| Yes
|
|
| Timestamp getTimestamp (int, Calendar)
| 2.0 Core
| Yes
|
|
| Timestamp getTimestamp (String)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| Timestamp getTimestamp (String, Calendar)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "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
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| void registerOutParameter (String, int, int)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| void registerOutParameter (String, int, String)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
String/typename ignored.
|
| void setArray (int, Array)
| 2.0 Core
| No
| Throws “unsupported method” exception.
|
| void setAsciiStream (String, InputStream, int)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| void setBigDecimal (String, BigDecimal)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| void setBinaryStream (String, InputStream, int)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| void setBoolean (String, boolean)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| void setByte (String, byte)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| void setBytes (String, byte [])
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| void setCharacterStream (String, Reader, int)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| void setDate (String, Date)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| void setDate (String, Date, Calendar)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| void setDouble (String, double)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| void setFloat (String, float)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| void setInt (String, int)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
|
| void setLong (String, long)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw “unsupported method” exception.
|
| void setNull (String, int)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw “unsupported method” exception
|
| void setNull (String, int, String)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw “unsupported method” exception.
|
| void setObject (String, Object)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw “unsupported method” exception.
|
| void setObject (String, Object, int)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw “unsupported method” exception.
|
| void setObject (String, Object, int, int)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw “unsupported method” exception.
|
| void setShort (String, short)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw “unsupported method” exception.
|
| void setString (String, String)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw “unsupported method” exception.
|
| void setTime (String, Time)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw “unsupported method” exception.
|
| void setTime (String, Time, Calendar)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw “unsupported method” exception.
|
| void setTimestamp (String, Timestamp)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw “unsupported method” exception.
|
| void setTimestamp (String, Timestamp, Calendar)
| 3.0
| Yes
| Supported for the SQL Server driver only. All other drivers throw “unsupported method” exception.
|
| void setURL (String, URL)
| 3.0
| No
| Throws “unsupported method” exception.
|
| boolean wasNull ()
| 1.0
| Yes
|
|
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.
|
| String getClientInfo ()
| 4.0
| Yes
|
|
| String getClientInfo (String)
| 4.0
| Yes
|
|
| 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
|
|
| boolean isValid ()
| 4.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
| Yes
| Supported for the Oracle and SQL Server drivers. For all other drivers, throws “unsupported method” exception.
|
| PreparedStatement prepareStatement (String, String [])
| 3.0
| Yes
| Supported for the Oracle and SQL Server drivers. For all other drivers, throws “unsupported method” exception.
|
| void releaseSavepoint (Savepoint)
| 3.0
| Yes
| The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.
|
| void rollback ()
| 1.0
| Yes
|
|
| void rollback (Savepoint)
| 3.0
| Yes
| The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher 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.
|
| String setClientInfo (Properties)
| 4.0
| Yes
|
|
| String setClientInfo (String, String)
| 4.0
| Yes
|
|
| 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.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher 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.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher 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.
|
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.
|
| getAttributes (String, String, String, String)
| 3.0
| Yes
| Empty result set is returned.
|
| 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
|
|
| String getClientInfoProperties ()
| 4.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
| Yes
| Empty result set is returned.
|
| ResultSet getSuperTypes (String, String, String)
| 3.0
| Yes
| Empty result set is returned.
|
| 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
Name ofs ()
| 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
|
|
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.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.
|
| void setBlob (int, Blob)
| 2.0 Core
| Yes
| The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.
The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
| 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.x and higher for Linux/UNIX/Windows,
DB2 for z/OS, and DB2 V5R2 and higher 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 data types that map to the JDBC LONGVARCHAR data type.
|
| 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
| The DB2 driver supports setting a timeout value, in seconds, for a statement with DB2 v8.x and higher 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 drivers support 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.
|
| 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.
|
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.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher 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.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries when retrieving BLOB data.
|
| Blob getBlob (int)
| 2.0 Core
| Yes
| The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.
The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
| Blob getBlob (String)
| 2.0 Core
| Yes
| The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.
The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
| 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.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher 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.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher 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 data types that map to the JDBC LONGVARCHAR data type.
|
| Clob getClob (String)
| 2.0 Core
| Yes
| The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARCHAR data type.
|
| 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.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.
The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
| void updateBlob (String, Blob)
| 3.0
| Yes
| The DB2 driver only supports with DB2 v8.x and higher for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 and higher for iSeries.
The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
| 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
| The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARCHAR data type
|
| void updateClob (String, Clob)
| 3.0
| Yes
| The SQL Server and Sybase drivers support using with data types that map to the JDBC LONGVARCHAR data type
|
| 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
|
|
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
| Yes
| Supported for the Oracle and SQL Server drivers. For all other drivers, throws "unsupported method" exception.
|
| boolean execute (String, String [])
| 3.0
| Yes
| Supported for the Oracle and SQL Server drivers. For all other drivers, 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
| Yes
| Supported for the Oracle and SQL Server drivers. For all other drivers, throws "unsupported method" exception.
|
| int executeUpdate (String, String [])
| 3.0
| Yes
| Supported for the Oracle and SQL Server drivers. For all other drivers, 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.x and higher 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.x and higher 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.
|