> # Supported Functionality

> The following tables list functionality supported for each JDBC object.

> ### Array Object

> Array Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> (all) | 2.0 Core | No | Array objects are neither exposed, nor taken as input.

> ### Blob Object

> Blob Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> InputStream getBinaryStream () | 2.0 Core | Yes |
> byte[] getBytes (long, int) | 2.0 Core | Yes |
> long length () | 2.0 Core | Yes |
> long position (byte, long) | 2.0 Core | Yes |
> long position (Blob, long) | 2.0 Core | Yes |
> OutputStream setBinaryStream (long) | 3.0 Core | Yes |
> int setBytes (long, byte[]) | 3.0 Core | Yes |
> int setBytes (long, byte[], int, int) | 3.0 Core | Yes |
> void truncate (long) | 3.0 Core | Yes |
> NOTE: Blob support is emulated using LONGVARBINARY datatypes on SQL Server, Sybase, JDBC Socket, and ODBC Socket. Using emulated Blobs incurs a performance and scalability penalty.

> ### 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 | Not supported on servers which emulate this functionality over LONGVARBINARY.
> Blob getBlob (String) | 3.0 | No | Throws "unsupported method" exception.
> boolean execute () | 1.0 | Yes |
> boolean execute (String) | 1.0 | No | Throws "invalid method call" exception.
> boolean execute (String, int) | 3.0 | No | Throws "invalid method call" exception.
> boolean execute (String, int[]) | 3.0 | No | Throws "invalid method call" exception.
> boolean execute (String, String[]) | 3.0 | No | Throws "invalid method call" exception.
> boolean getBoolean (int) | 1.0 | Yes |
> boolean getBoolean (String) | 3.0 | No | Throws "unsupported method" exception.
> boolean getMoreResults () | 1.0 | Yes |
> boolean getMoreResults (int) | 3.0 | Yes | Not supported on Informix.
> boolean wasNull () | 1.0 | Yes |
> byte [] getBytes (int) | 1.0 | Yes |
> byte [] getBytes (String) | 3.0 | No | Throws "unsupported method" exception.
> byte getByte (int) | 1.0 | Yes |
> byte getByte (String) | 3.0 | No | Throws "unsupported method" exception.
> Clob getClob (int) | 2.0 Core | Yes | Not supported on servers which emulate this functionality over LONGVARCHAR.
> Clob getClob (String) | 3.0 | No | Throws "unsupported method" exception.
> Connection getConnection () | 2.0 Core | Yes |
> 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 [] executeBatch () | 2.0 Core | Yes |
> int executeUpdate () | 1.0 | Yes |
> int executeUpdate (String) | 1.0 | No | Throws "invalid method call" exception.
> int executeUpdate (String, int) | 3.0 | No | Throws "invalid method call" exception.
> int executeUpdate (String, int[]) | 3.0 | No | Throws "invalid method call" exception.
> int executeUpdate (String, String[]) | 3.0 | No | Throws "invalid method call" exception.
> int getFetchDirection () | 2.0 Core | Yes |
> int getFetchSize () | 2.0 Core | Yes |
> int getInt (int) | 1.0 | Yes |
> int getInt (String) | 3.0 | No | Throws "unsupported method" exception.
> int getMaxFieldSize () | 1.0 | Yes |
> int getMaxRows () | 1.0 | Yes |
> int getQueryTimeout () | 1.0 | Yes | Returns 0 for DB2 and Informix.
> int getResultSetConcurrency () | 2.0 Core | Yes |
> int getResultSetHoldability () | 3.0 | No | Throws "unsupported method" exception.
> int getResultSetType () | 2.0 Core | Yes |
> int getUpdateCount () | 1.0 | Yes |
> 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.
> ParameterMetaData getParameterMetaData() | 3.0 | Yes | Not supported on Oracle or Informix Servers.
> Ref getRef (int) | 2.0 Core | No | Throws "unsupported method" exception.
> Ref getRef (String) | 3.0 | No | Throws "unsupported method" exception.
> ResultSet executeQuery () | 1.0 | Yes |
> ResultSet executeQuery (String) | 1.0 | No | Throws "invalid method call" exception.
> ResultSet getGeneratedKeys() | 3.0 | No | Throws "unsupported method" exception.
> ResultSet getResultSet () | 1.0 | Yes |
> ResultSetMetaData getMetaData () | 2.0 Core | Yes |
> short getShort (int) | 1.0 | Yes |
> short getShort (String) | 3.0 | No | Throws "unsupported method" exception.
> SQLWarning getWarnings () | 1.0 | Yes |
> 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 addBatch () | 2.0 Core | Yes |
> void addBatch (String) | 2.0 Core | No | Throws "invalid method call" exception.
> void cancel () | 1.0 | Yes | Cancel can be used to cancel a function running synchronously on a statement, using a different thread. Whether Cancel will actually cancel the running function depends on the data store.
> void clearBatch () | 2.0 Core | Yes |
> void clearParameters () | 1.0 | Yes |
> void clearWarnings () | 1.0 | Yes |
> void close () | 1.0 | Yes |
> void registerOutParameter (int, int) | 1.0 | Yes | This method should only be used against data stores supporting output or input-output parameters.
> void registerOutParameter (int, int, int) | 1.0 | Yes | This method should only be used against data stores supporting output or input-output parameters.
> void registerOutParameter (int, int, String) | 2.0 Core | Yes | String/typename ignored. This method should only be used against data stores supporting output or input-output parameters.
> 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 (int, InputStream, int) | 1.0 | Yes |
> void setAsciiStream (String, InputStream, int) | 3.0 | No | Throws "unsupported method" exception.
> void setBigDecimal (int, BigDecimal) | 1.0 | Yes |
> void setBigDecimal (String, BigDecimal) | 3.0 | No | Throws "unsupported method" exception.
> void setBinaryStream (int, InputStream, int) | 1.0 | Yes |
> void setBinaryStream (String, InputStream, int) | 3.0 | No | Throws "unsupported method" exception.
> void setBlob (int, Blob) | 2.0 Core | Yes |
> void setBoolean (int, boolean) | 1.0 | Yes |
> void setBoolean (String, boolean) | 3.0 | No | Throws "unsupported method" exception.
> void setByte (int, byte) | 1.0 | Yes |
> void setByte (String, byte) | 3.0 | No | Throws "unsupported method" exception.
> void setBytes (int, byte []) | 1.0 | Yes |
> void setBytes (String, byte []) | 3.0 | No | Throws "unsupported method" exception.
> void setCharacterStream (int, Reader, int) | 2.0 Core | Yes |
> void setCharacterStream (String, Reader, int) | 3.0 | No | Throws "unsupported method" exception.
> void setClob (int, Clob) | 2.0 Core | Yes |
> void setCursorName (String) | 1.0 | No | Throws "unsupported method" exception.
> void setDate (int, Date) | 1.0 | Yes | SQL Server throws "optional feature not implemented" exception.
> void setDate (int, Date, Calendar) | 2.0 Core | Yes | SQL Server throws "optional feature not implemented" 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 (int, double) | 1.0 | Yes |
> void setDouble (String, double) | 3.0 | No | Throws "unsupported method" exception.
> void setEscapeProcessing (boolean) | 1.0 | Yes |
> void setFetchDirection (int) | 2.0 Core | Yes | SequeLink supports this method, but will ignore this hint provided by the application.
> void setFetchSize (int) | 2.0 Core | Yes | SequeLink supports this method, but will ignore this hint provided by the application.
> void setFloat (int, float) | 1.0 | Yes |
> void setFloat (String, float) | 3.0 | No | Throws "unsupported method" exception.
> void setInt (int, int) | 1.0 | Yes |
> void setInt (String, int) | 3.0 | No | Throws "unsupported method" exception.
> void setLong (int, long) | 1.0 | Yes | SQL Server throws "optional feature not implemented" exception. However, you can use the workaround MSSMapLongToDecimal, which maps setLong to DECIMAL instead of BIGINT.
> void setLong (String, long) | 3.0 | No | Throws "unsupported method" exception.
> void setMaxFieldSize (int) | 1.0 | Yes |
> void setMaxRows (int) | 1.0 | Yes |
> void setNull (int, int) | 1.0 | Yes |
> void setNull (int, int, String) | 2.0 Core | Yes | SequeLink does not support the Advanced Data Type functionality. This method is always mapped to setNull (i, sqlType).
> 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 (int, Object) | 1.0 | Yes |
> void setObject (int, Object, int) | 1.0 | Yes |
> void setObject (int, Object, int, int) | 1.0 | Yes |
> 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 setQueryTimeout (int) | 1.0 | Yes | Not supported on DB2 z/OS servers. Support for the JDBC and ODBC Socket Servers is dependent on the driver it loads.
> void setRef (int, Ref) | 2.0 Core | No | Throws "unsupported method" exception.
> void setShort (int, short) | 1.0 | Yes |
> void setShort (String, short) | 3.0 | No | Throws "unsupported method" exception.
> void setString (int, String) | 1.0 | Yes |
> void setString (String, String) | 3.0 | No | Throws "unsupported method" exception.
> void setTime (int, Time) | 1.0 | Yes | SQLServer throws "optional feature not implemented" exception.
> void setTime (int, Time, Calendar) | 2.0 Core | Yes | SQLServer throws "optional feature not implemented" 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 (int, Timestamp) | 1.0 | Yes |
> void setTimestamp (int, Timestamp, Calendar) | 2.0 Core | Yes |
> void setTimestamp (String, Timestamp) | 3.0 | No | Throws "unsupported method" exception.
> void setTimestamp (String, Timestamp, Calendar) | 3.0 | No | Throws "unsupported method" exception.
> void setUnicodeStream (int, InputStream, int) | 1.0 | Yes | Supported by SequeLink. This method has been deprecated in the JDBC 2.0 specification.
> void setURL (int, URL) | 3.0 | No | Throws "unsupported method" exception.
> void setURL (String, URL) | 3.0 | No | Throws "unsupported method" exception.

> ### Clob Object

> Clob Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> InputStream getAsciiStream () | 2.0 Core | Yes |
> Reader getCharacterStream () | 2.0 Core | Yes |
> String getSubString (long, int) | 2.0 Core | Yes |
> long length () | 2.0 Core | Yes |
> long position (Clob, long) | 2.0 Core | Yes |
> long position (String, long) | 2.0 Core | Yes |
> OutputStream setAsciiStream (long) | 3.0 Core | Yes |
> Writer setCharacterStream (long) | 3.0 Core | Yes |
> int setString (long, String) | 3.0 Core | Yes |
> int setString (long, String, int, int) | 3.0 Core | Yes |
> void truncate (long) | 3.0 Core | Yes |
> NOTE: Clob support is emulated using LONGVARCHAR datatypes on SQL Server, Sybase, JDBC Socket, and ODBC Socket. Using emulated Clobs incurs a performance and scalability penalty.

> ### 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 there is an active transaction, that transaction is rolled-back.
> void commit () | 1.0 | Yes |
> SQLWarning getWarnings () | 1.0 | Yes |
> Statement createStatement () | 1.0 | Yes |
> Statement createStatement (int, int) | 2.0 Core | Yes | The supported values for resultSetConcurrency depend on the data store you are connected to.
> Statement createStatement (int, int, int) | 3.0 | No | SequeLink only supports fixed Holdability values per RDBMS
> boolean getAutoCommit () | 1.0 | Yes |
> String getCatalog () | 1.0 | Yes | Support is database-specific.
> int getHoldability () | 3.0 | Yes | SequeLink only supports fixed Holdability values per RDBMS
> 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 | The supported values for resultSetConcurrency depend on the data store you are connected to.
> CallableStatement prepareCall (String, int, int, int) | 3.0 | No | SequeLink only supports fixed Holdability values per RDBMS
> PreparedStatement prepareStatement (String) | 1.0 | Yes |
> PreparedStatement prepareStatement (String, int) | 3.0 | No | Throws "unsupported method" exception.
> PreparedStatement prepareStatement (String, int[]) | 3.0 | No | Throws "unsupported method" exception.
> PreparedStatement prepareStatement (String, int, int) | 2.0 Core | Yes | The supported values for resultSetType and resultSetConcurrency depend on the data store you are connected to.
> PreparedStatement prepareStatement (String, int, int, int) | 3.0 | No | SequeLink only supports fixed Holdability values per RDBMS
> PreparedStatement prepareStatement (String, String []) | 3.0 | No | Throws "unsupported method" exception.
> void releaseSavepoint (Savepoint) | 3.0 | Yes |
> void rollback () | 1.0 | Yes |
> void rollback (Savepoint) | 3.0 | Yes |
> void setAutoCommit (boolean) | 1.0 | Yes |
> void setCatalog (String) | 1.0 | Yes | Switching of catalogs is supported if the SequeLink Server supports it.
> void setHoldability (int) | 3.0 | No | SequeLink only supports fixed Holdability values per RDBMS.
> void setReadOnly (boolean) | 1.0 | Yes |
> void setSavepoint () | 3.0 | Yes | Not supported with Informix servers.
> void setSavepoint (String) | 3.0 | Yes | Not supported with Informix servers.
> void setTransactionIsolation (int) | 1.0 | Yes |
> void setTypeMap (Map) | 2.0 Core | Yes | Ignored.

> ### ConnectionPoolDataSource Object

> ConnectionPoolData Source Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> PrintWriter getLogWriter () | 2.0 Optional | Yes |
> int getLoginTimeout () | 2.0 Optional | Yes |
> PooledConnection getPooledConnection () | 2.0 Optional | Yes |
> PooledConnection getPooledConnection (String, String) | 2.0 Optional | Yes |
> void setLogWriter (PrintWriter) | 2.0 Optional | Yes |
> void setLoginTimeout (int) | 2.0 Optional | Yes |

> ### DatabaseMetaData Object

> DatabaseMetaData Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> boolean allProceduresAreCallable () | 1.0 | Yes |
> boolean allTablesAreSelectable () | 1.0 | Yes |
> boolean dataDefinitionCausesTransaction Commit () | 1.0 | Yes |
> boolean dataDefinitionIgnoredInTransactions () | 1.0 | Yes |
> boolean deletesAreDetected (int) | 2.0 Core | Yes |
> boolean doesMaxRowSizeIncludeBlobs () | 1.0 | Yes | Not supported with DB2, SQL Server, and Sybase servers.
> ResultSet getAttributes (String, String) | 3.0 | No | Always returns empty result set.
> ResultSet getBestRowIdentifier (String, String, String, int, boolean) | 1.0 | Yes | The JDBC driver supports this method if the data store has support for it.
> ResultSet getCatalogs () | 1.0 | Yes | This method is supported if the SequeLink Server supports it.
> String getCatalogSeparator () | 1.0 | Yes |
> String getCatalogTerm () | 1.0 | Yes |
> ResultSet getColumnPrivileges (String, String, String, String) | 1.0 | Yes | The JDBC driver supports this method if the data store has support for it.
> ResultSet getColumns (String, String, String, String) | 1.0 | Yes |
> ResultSet getColumns (String, String, String, String) | 3.0 Extension | Yes | The extended resultset columns will all contain null as values.
> Connection getConnection () | 2.0 Core | Yes |
> ResultSet getCrossReference (String, String, String, String, String, String) | 1.0 | Yes | The JDBC driver supports this method if the data store has support for it.
> int getDatabaseMajorVersion () | 3.0 | Yes |
> int getDatabaseMinorVersion () | 3.0 | Yes |
> String getDatabaseProductName () | 1.0 | Yes |
> 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 | The JDBC driver supports this method if the data store has support for it.
> String getExtraNameCharacters () | 1.0 | Yes |
> String getIdentifierQuoteString () | 1.0 | Yes |
> ResultSet getImportedKeys (String, String, String) | 1.0 | Yes | The JDBC driver supports this method if the data store has support for it.
> ResultSet getIndexInfo (String, String, String, boolean, boolean) | 1.0 | Yes | The JDBC driver supports this method if the data store has support for it.
> 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 | The JDBC driver supports this method if the data store has support for it.
> ResultSet getProcedureColumns (String, String, String, String) | 1.0 | Yes | The JDBC driver supports this method if the data store has support for it.
> String getProcedureTerm () | 1.0 | Yes |
> ResultSet getProcedures (String, String, String) | 1.0 | Yes | The JDBC driver supports this method if the data store has support for it.
> int getResultSetHoldability () | 3.0 | Yes |
> ResultSet getSchemas () | 1.0 | Yes | The JDBC driver supports this method if the data store has support for it.
> ResultSet getSchemas () | 3.0 Extension | Yes | The JDBC driver supports this method if the data store has support for it.
> String getSchemaTerm () | 1.0 | Yes |
> String getSearchStringEscape () | 1.0 | Yes |
> String getStringFunctions () | 1.0 | Yes |
> String getSQLKeywords () | 1.0 | Yes |
> int getSQLStateType () | 3.0 | Yes |
> String getSystemFunctions () | 1.0 | Yes |
> ResultSet getSuperTables (String, String, String) | 3.0 | No | Always returns empty ResultSet.
> ResultSet getSuperTypes (String, String, String) | 3.0 | No | Always returns empty ResultSet.
> ResultSet getTablePrivileges (String, String, String) | 1.0 | Yes | The JDBC driver supports this method if the data store supports it.
> ResultSet getTableTypes () | 1.0 | Yes |
> ResultSet getTables (String, String, String, String []) | 1.0 | Yes |
> ResultSet getTables (String, String, String, String []) | 3.0 Extension | Yes | The extended resultset columns will all contain null as values.
> String getTimeDateFunctions () | 1.0 | Yes |
> ResultSet getTypeInfo () | 1.0 | Yes |
> ResultSet getUDTs (String, String, String, int []) | 2.0 Core | No | SequeLink does not support the Advanced Data Type functionality and always returns an empty result set.
> ResultSet getUDTs (String, String, String, int []) | 3.0 Extension | No | SequeLink does not support the Advanced Data Type functionality and always returns an empty result set.
> String getURL () | 1.0 | Yes |
> String getUserName () | 1.0 | Yes |
> ResultSet getVersionColumns (String, String, String) | 1.0 | Yes | The JDBC driver supports this method if the data store supports it.
> 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 supportsResultSetHoldability (int) | 3.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 () | 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 supportsMultipleOpenResultSets () | 3.0 | Yes |
> boolean supportsMultipleResultSets () | 1.0 | Yes | Not supported on Informix. NOTE: Use of this method with large result sets incurs a performance and scalability penalty.
> 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 | The driver returns hard coded false.
> boolean supportsPositionedUpdate () | 1.0 | Yes | The driver returns hard coded false.
> boolean supportsResultSetConcurrency (int, int) | 2.0 Core | 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 | SequeLink supports SELECT FOR UPDATE statements against certain DBMSs. SequeLink returns false, as it does not support UPDATE WHERE CURRENT OF statements.
> 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 |

> ### DataSource Object

> DataSource Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> Connection getConnection () | 2.0 Optional | Yes |
> Connection getConnection (String, String) | 2.0 Optional | Yes |
> PrintWriter getLogWriter () | 2.0 Optional | Yes |
> int getLoginTimeout () | 2.0 Optional | Yes |
> void setLogWriter (PrintWriter) | 2.0 Optional | Yes | Enables DataDirect Spy, which traces JDBC information into the specified PrintWriter.
> void setLoginTimeout (int) | 2.0 Optional | Yes |

> ### Driver Object

> Driver Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> boolean acceptsURL (String) | 1.0 | Yes |
> Connection connect (String, Properties) | 1.0 | Yes |
> int getMajorVersion () | 1.0 | Yes |
> int getMinorVersion () | 1.0 | Yes |
> DriverPropertyInfo [] getPropertyInfo (String, Properties) | 1.0 | Yes |
> boolean jdbcCompliant () | 1.0 | Yes |

> ### ParameterMetaData Object

> ParameterMetaData Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> String getParameterClassName (int) | 3.0 | Yes |
> int getParameterCount () | 3.0 | Yes |
> int getParameterMode (int) | 3.0 | Yes |
> int getParameterType (int) | 3.0 | Yes |
> String getParameterTypeName (int) | 3.0 | Yes |
> int getPrecision (int) | 3.0 | Yes |
> int getScale (int) | 3.0 | Yes |
> int isNullable (int) | 3.0 | Yes |
> boolean isSigned (int) | 3.0 | Yes |

> ### PooledConnection Object

> PooledConnection Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> void addConnectionEventListener (ConnectionEventListener) | 2.0 Optional | Yes |
> void close() | 2.0 Optional | Yes |
> Connection getConnection() | 2.0 Optional | Yes | A pooled connection object can have only one Connection object open (the one most recently created). The purpose of allowing the server (PoolManager implementation) to invoke the method getConnection a second time is to give that application server a way to take a connection away from an application and give it to another user (a rare occurrence). The drivers do not support this "reclaiming" of connections and will throw a SQLException "Reclaim of open connection is not supported."
> void removeConnectionEvent Listener (ConnectionEventListener) | 2.0 Optional | Yes |

> ### PreparedStatement Object

> PreparedStatement Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> void addBatch () | 2.0 Core | Yes |
> void addBatch (String) | 2.0 Core | No | Throws "invalid method call" exception.
> void cancel () | 1.0 | Yes | Cancel can be used to cancel a function running synchronously on a statement, using a different thread. Whether Cancel will actually cancel the running function depends on the data store.
> void clearBatch () | 2.0 Core | Yes |
> void clearParameters () | 1.0 | Yes |
> void clearWarnings () | 1.0 | Yes |
> void close () | 1.0 | Yes |
> boolean execute () | 1.0 | Yes |
> boolean execute (String) | 1.0 | No | Throws "invalid method call" exception.
> boolean execute (String, int) | 3.0 | No | Throws "invalid method call" exception.
> boolean execute (String, int []) | 3.0 | No | Throws "invalid method call" exception.
> boolean execute (String, String []) | 3.0 | No | Throws "invalid method call" exception.
> int [] executeBatch () | 2.0 Core | Yes |
> ResultSet executeQuery () | 1.0 | Yes |
> ResultSet executeQuery (String) | 1.0 | No | Throws "invalid method call" exception.
> int executeUpdate () | 1.0 | Yes |
> int executeUpdate (String) | 1.0 | No | Throws "invalid method call" exception.
> int executeUpdate (String, int) | 3.0 | No | Throws "unsupported method" exception.
> 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 |
> ParameterMetaData getParameterMetaData() | 3.0 | Yes | Not supported on Oracle or Informix Servers.
> ResultSet getGeneratedKeys () | 3.0 | No | Throws "unsupported method" exception.
> int getMaxFieldSize () | 1.0 | Yes |
> int getMaxRows () | 1.0 | Yes |
> ResultSetMetaData getMetaData () | 2.0 Core | Yes |
> boolean getMoreResults () | 1.0 | Yes |
> boolean getMoreResults (int) | 3.0 | Yes |
> int getQueryTimeout () | 1.0 | Yes |
> ResultSet getResultSet () | 1.0 | Yes |
> int getResultSetConcurrency () | 2.0 Core | Yes |
> int getResultSetHoldability () | 3.0 | No | Throws "unsupported method" exception.
> int getResultSetType () | 2.0 Core | Yes |
> int getUpdateCount () | 1.0 | Yes |
> SQLWarning getWarnings () | 1.0 | Yes |
> void 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 |
> void setBlob (int, Blob) | 2.0 Core | Yes |
> void setBoolean (int, boolean) | 1.0 | Yes |
> void setByte (int, byte) | 1.0 | Yes |
> void setBytes (int, byte []) | 1.0 | Yes |
> void setCharacterStream (int, Reader, int) | 2.0 Core | Yes |
> void setClob (int, Clob) | 2.0 Core | Yes |
> void setCursorName (String) | 1.0 | No |
> void setDate (int, Date) | 1.0 | Yes | SQL Server throws "optional feature not implemented" exception.
> void setDate (int, Date, Calendar) | 2.0 Core | Yes | SQL Server throws "optional feature not implemented" exception.
> void setDouble (int, double) | 1.0 | Yes |
> void setEscapeProcessing (boolean) | 1.0 | Yes | Ignored.
> void setFetchDirection (int) | 2.0 Core | Yes | SequeLink supports this method, but will ignore this hint provided by the application.
> void setFetchSize (int) | 2.0 Core | Yes | SequeLink supports this method, but will ignore this hint provided by the application.
> void setFloat (int, float) | 1.0 | Yes |
> void setInt (int, int) | 1.0 | Yes |
> void setLong (int, long) | 1.0 | Yes |
> void setMaxFieldSize (int) | 1.0 | Yes |
> void setMaxRows (int) | 1.0 | Yes |
> void setNull (int, int) | 1.0 | Yes |
> void setNull (int, int, String) | 2.0 Core | Yes | SequeLink does not support the Advanced Data Type functionality. This method is always mapped to setNull (i, sqlType).
> 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 | Support for the JDBC and ODBC Socket Servers is dependent on the driver it loads.
> 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 | SQL Server throws "optional feature not implemented" exception.
> void setTime (int, Time, Calendar) | 2.0 Core | Yes | SQL Server throws "optional feature not implemented" exception.
> void setTimestamp (int, Timestamp) | 1.0 | Yes |
> void setTimestamp (int, Timestamp, Calendar) | 2.0 Core | Yes |
> void setUnicodeStream (int, InputStream, int) | 1.0 | Yes | Throws "unsupported method" exception. This method was deprecated in the JDBC 2.0 specification.
> void setURL (int, URL) | 3.0 | No | Throws "unsupported method" exception.
> boolean wasNull () | 1.0 | Yes |

> ### Ref Object

> Ref Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> (all) | 2.0 Core | No | Ref objects are neither exposed, nor taken as input.

> ### Referenceable Object

> Referenceable Object Methods | JDBC Version Introduced | Supported | Comments
> --- | --- | --- | ---
> Reference getReference() | javax.naming | Yes | Implemented by SequeLinkDataSource.

> ### 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 | For the implementation of getAsciiStream (), the driver assumes that the underlying data in the database only contains 7-bit ASCII characters (represented in an ASCII or EBCDIC code-page). If the assumption is true, the driver returns bytes corresponding to ASCII characters, otherwise the results are unpredictable. In the case that getAsciiStream () is called on a binary column, the driver converts the binary data to the hexadecimal representation and returns the ASCII representation. For example, the binary value 20 is represented in hexidecimal as 14 or "1" "4". In ASCII, 1 is represented by "49" and 4 is represented by "52". This implies that the ASCII stream "4952" is returned.
> InputStream getAsciiStream (String) | 1.0 | Yes | For the implementation of getAsciiStream (), the drivers assume that the underlying data in the database only contains 7-bit ASCII characters (represented in an ASCII or EBCDIC code-page). If the assumption is true, the drivers return bytes corresponding to ASCII characters, otherwise the results are unpredictable. In the case that getAsciiStream () is called on a binary column, the driver converts the binary data to the hexidecimal representation and returns the ASCII representation. For example, the binary value 20 is represented in hexidecimal as 14 or "1" "4". In ASCII, 1 is represented by "49" and 4 is represented by "52". This implies that the ASCII stream "4952" is returned.
> BigDecimal getBigDecimal (int) | 2.0 Core | Yes |
> BigDecimal getBigDecimal (String) | 2.0 Core | Yes |
> BigDecimal getBigDecimal (int, int) | 1.0 | Yes |
> BigDecimal getBigDecimal (String, int) | 1.0 | Yes |
> InputStream getBinaryStream (int) | 1.0 | Yes |
> InputStream getBinaryStream (String) | 1.0 | Yes |
> Blob getBlob (int) | 2.0 Core | Yes |
> Blob getBlob (String) | 2.0 Core | Yes |
> 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 |
> byte [] getBytes (String) | 1.0 | Yes |
> Reader getCharacterStream (int) | 2.0 Core | Yes |
> Reader getCharacterStream (String) | 2.0 Core | Yes |
> Clob getClob (int) | 2.0 Core | Yes |
> Clob getClob (String) | 2.0 Core | Yes |
> int getConcurrency () | 2.0 Core | Yes |
> String getCursorName () | 1.0 | No | Throws "unsupported method" exception.
> Date getDate (int) | 1.0 | Yes |
> Date getDate (String) | 1.0 | Yes |
> Date getDate (int, Calendar) | 2.0 Core | 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 | SequeLink supports this method, but will ignore this hint provided by the application.
> int getFetchSize () | 2.0 Core | Yes | SequeLink supports this method, but will ignore this hint provided by the application.
> float getFloat (int) | 1.0 | Yes |
> float getFloat (String) | 1.0 | Yes |
> int getInt (int) | 1.0 | Yes |
> int getInt (String) | 1.0 | Yes |
> long getLong (int) | 1.0 | Yes |
> long getLong (String) | 1.0 | Yes |
> ResultSetMetaData getMetaData () | 1.0 | Yes |
> Object getObject (int) | 1.0 | Yes |
> Object getObject (String) | 1.0 | Yes |
> Object getObject (int, Map) | 2.0 Core | Yes | Map ignored.
> 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 (String) | 1.0 | Yes |
> Time getTime (int, Calendar) | 2.0 Core | Yes |
> Time getTime (String, Calendar) | 2.0 Core | Yes |
> Timestamp getTimestamp (int) | 1.0 | Yes |
> Timestamp getTimestamp (String) | 1.0 | Yes |
> Timestamp getTimestamp (int, Calendar) | 2.0 Core | Yes |
> Timestamp getTimestamp (String, Calendar) | 2.0 Core | Yes |
> int getType () | 2.0 Core | Yes |
> InputStream getUnicodeStream (int) | 1.0 | Yes |
> InputStream getUnicodeStream (String) | 1.0 | Yes | This method was deprecated in the JDBC 2.0 specification.
> 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 |
> void updateBlob (String, Blob) | 3.0 | Yes |
> void updateBoolean (int, boolean) | 2.0 Core | Yes |
> void updateBoolean (String, boolean) | 2.0 Core | Yes |
> void updateByte (int, byte) | 2.0 Core | Yes |
> void updateByte (String, byte) | 2.0 Core | Yes |
> void updateBytes (int, byte []) | 2.0 Core | Yes |
> void updateBytes (String, byte []) | 2.0 Core | Yes |
> void updateCharacterStream (int, Reader, int) | 2.0 Core | Yes |
> void updateCharacterStream (String, Reader, int) | 2.0 Core | Yes |
> void updateClob (int, Clob) | 3.0 | No |
> void updateClob (String, Clob) | 3.0 | No |
> 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 (String, Object) | 2.0 Core | Yes |
> void updateObject (int, Object, int) | 2.0 Core | Yes |
> void updateObject (String, Object, int) | 2.0 Core | Yes |
> void updateRef (int, Ref) | 3.0 | No | Throws "unsupported method" exception.
> void updateRef (String, Ref) | 3.0 | No | Throws "unsupported method" exception.
> void updateRow () | 2.0 Core | Yes |
> void updateShort (int, short) | 2.0 Core | Yes |
> void updateShort (String, short) | 2.0 Core | Yes |
> void updateString (int, String) | 2.0 Core | Yes |
> void updateString (String, String) | 2.0 Core | Yes |
> void updateTime (int, Time) | 2.0 Core | Yes |
> void updateTime (String, Time) | 2.0 Core | Yes |
> void updateTimestamp (int, Timestamp) | 2.0 Core | Yes |
> void updateTimestamp (String, Timestamp) | 2.0 Core | Yes |
> boolean wasNull () | 1.0 | Yes |

> ### ResultSetMetaData Object

> ResultSetMetaData Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> String getCatalogName (int) | 1.0 | Yes | The behavior of this method is data store specific.
> 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 | The behavior of this method is data store specific.
> String getTableName (int) | 1.0 | Yes | The behavior of this method is data store specific.
> 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 |

> ### RowSet Object

> RowSet Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> (all) | 2.0 Optional | No |

> ### SavePoint Object

> SavePoint Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> int getSavepointId () | 3.0 | Yes | Savepoint not supported on Informix, JDBC Socket, and ODBC Socket Server servers.
> String getSavepointName () | 3.0 | Yes | Savepoint not supported on Informix, JDBC Socket, and ODBC Socket Server servers.

> ### Serializable Object

> Serializable Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> (N/A) | java.io | Yes | Implemented by SequeLinkDataSource.

> ### Statement Object

> Statement Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> void addBatch (String) | 2.0 Core | Yes |
> void cancel () | 1.0 | Yes | Cancel can be used to cancel a function running synchronously on a statement, using a different thread. Whether Cancel will actually cancel the running function depends on the data store.
> void clearBatch () | 2.0 Core | Yes |
> void clearWarnings () | 1.0 | Yes |
> void close () | 1.0 | Yes |
> boolean execute (String) | 1.0 | Yes |
> boolean execute (String, int) | 3.0 | No | Throws "unsupported method" exception.
> 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 |
> int executeUpdate (String) | 1.0 | Yes |
> int executeUpdate (String, int) | 3.0 | No | Throws "unsupported method" exception.
> 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 | SequeLink supports this method, but ignores this hint provided by the application.
> int getFetchSize () | 2.0 Core | Yes | SequeLink supports this method, but ignores this hint provided by the application.
> ResultSet getGeneratedKeys () | 3.0 | No | Throws "unsupported method" exception.
> int getMaxFieldSize () | 1.0 | Yes |
> int getMaxRows () | 1.0 | Yes |
> boolean getMoreResults () | 1.0 | Yes |
> boolean getMoreResults (int) | 3.0 | No | Throws "unsupported method" exception.
> int getQueryTimeout () | 1.0 | Yes | Returns 0 for DB2 UDB and Informix.
> ResultSet getResultSet () | 1.0 | Yes |
> int getResultSetConcurrency () | 2.0 Core | Yes |
> int getResultSetHoldability () | 3.0 | No | Throws "unsupported method" exception.
> int getResultSetType () | 2.0 Core | Yes |
> int getUpdateCount () | 1.0 | Yes |
> SQLWarning getWarnings () | 1.0 | Yes |
> void setCursorName (String) | 1.0 | No |
> void setEscapeProcessing (boolean) | 1.0 | Yes |
> 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 | Support for JDBC and ODBC Socket Servers is dependent on the driver it loads.

> ### Struct Object

> Struct Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> (all) | 2.0 | No | Struct objects are neither exposed, nor taken as input.

> ### XAConnection Object

> XAConnection Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> XAResource getXAResource() | 2.0 Optional | Yes |

> ### XADataSource Object

> XADataSource Object Methods | Version Introduced | Supported | Comments
> --- | --- | --- | ---
> int getLoginTimeout () | 2.0 Optional | Yes |
> PrintWriter getLogWriter () | 2.0 Optional | Yes |
> XAConnection getXAConnection () | 2.0 Optional | Yes | The behavior of these methods depends on whether distributed/XA transactions are supported by the SequeLink Server. If not supported, the JDBC driver will throw an "XA-Open failed with return code -3" exception.
> XAConnection getXAConnection (String, String) | 2.0 Optional | Yes | The behavior of these methods depends on whether distributed/XA transactions are supported by the SequeLink Server. If not supported, the JDBC driver will throw an "XA-Open failed with return code -3" exception.
> void setLoginTimeout (int) | 2.0 Optional | Yes |
> void setLogWriter (PrintWriter) | 2.0 Optional | Yes |