Type 4 JDBC Drivers

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

JDBC Support

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

 

JDBC Compatibility

Table A-1 shows compatibility among the JDBC specification versions, JVMs, and the Type 4 JDBC drivers.

 

Supported Functionality

The following tables list functionality supported for each JDBC object.

Array Object

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

Blob Object

Table A-3 Blob Object 
Blob Object Methods
Version
Introduced
Supported
Comments
InputStream getBinaryStream ()
2.0 Core
Yes
The SQL Server driver supports using with data types that map to the JDBCLONGVARBINARY data type.
byte[] getBytes (long, int)
2.0 Core
Yes
The SQL Server driver supports using with data types that map to the LONGVARBINARY data type.
long length ()
2.0 Core
Yes
The SQL Server driver supports using with data types that map to the LONGVARBINARY data type.
long position (Blob, long)
2.0 Core
Yes
The SQL Server driver supports using with data types that map to the LONGVARBINARY data type.
long position (byte[], long)
2.0 Core
Yes
The SQL Server driver supports using with data types that map to the LONGVARBINARY data type.
OutputStream setBinaryStream (long)
3.0
Yes
The SQL Server driver supports using with data types that map to the LONGVARBINARY data type.
int setBytes (long, byte[])
3.0
Yes
The SQL Server driver supports using with data types that map to the LONGVARBINARY data type.
int setBytes (long, byte[], int, int)
3.0
Yes
The SQL Server driver supports using with data types that map to the LONGVARBINARY data type.
void truncate (long)
3.0
Yes
The SQL Server driver supports using with data types that map to the LONGVARBINARY data type.

CallableStatement Object

Table A-4 CallableStatement Object 
CallableStatement Object  
Methods
Version
Introduced
Supported
Comments
Array getArray (int)
2.0 Core
No
Throws “unsupported method” exception.
Array getArray (String)
3.0
No
Throws “unsupported method” exception.
BigDecimal getBigDecimal (int)
2.0 Core
Yes
 
BigDecimal getBigDecimal (int, int)
1.0
Yes
 
BigDecimal getBigDecimal (String)
3.0
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 driver supports 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
 

Clob Object

Table A-5 Clob Object 
Clob Object 
Methods
Version
Introduced
Supported
Comments
InputStream getAsciiStream ()
2.0 Core
Yes
The SQL Server driver supports using with data types that map to the LONGVARCHAR data type.
Reader getCharacterStream ()
2.0 Core
Yes
The SQL Server driver supports using with data types that map to the LONGVARCHAR data type.
String getSubString (long, int)
2.0 Core
Yes
The SQL Server driver supports using with data types that map to the LONGVARCHAR data type.
long length ()
2.0 Core
Yes
The SQL Server driver supports using with data types that map to the LONGVARCHAR data type.
long position (Clob, long)
2.0 Core
Yes
The SQL Server driver supports using with data types that map to the LONGVARCHAR data type.
long position (String, long)
2.0 Core
Yes
The SQL Server driver supports using with data types that map to the LONGVARCHAR data type.
OutputStream setAsciiStream (long)
3.0 Core
Yes
The SQL Server driver supports using with data types that map to the LONGVARCHAR data type.
Writer setCharacterStream (long)
3.0 Core
Yes
The SQL Server driver supports using with data types that map to the LONGVARCHAR data type.
int setString (long, String)
3.0 Core
Yes
The SQL Server driver supports using with data types that map to the LONGVARCHAR data type.
int setString (long, String, int, int)
3.0 Core
Yes
The SQL Server driver supports using with data types that map to the LONGVARCHAR data type.
void truncate (long)
3.0 Core
Yes
The SQL Server driver supports using with data types that map to the LONGVARCHAR data type.

Connection Object

Table A-6 Connection Object 
Connection Object
Methods
Version
Introduced
Supported
Comments
void clearWarnings ()
1.0
Yes
 
void close ()
1.0
Yes
When a connection is closed while a transaction is still active, that transaction is rolled back.
void commit ()
1.0
Yes
 
Statement createStatement ()
1.0
Yes
 
Statement createStatement (int, int)
2.0 Core
Yes
 
Statement createStatement (int, int, int)
3.0
No
Throws "unsupported method" exception.
boolean getAutoCommit ()
1.0
Yes
 
String getCatalog ()
1.0
Yes
 
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
 
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
 
PreparedStatement prepareStatement (String, int, int, int)
3.0
No
Throws "unsupported method" exception.
PreparedStatement prepareStatement (String, int[])
3.0
Yes
 
PreparedStatement prepareStatement (String, String [])
3.0
Yes
 
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
 
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
 
Savepoint setSavepoint (String)
3.0
Yes
 
void setTransactionIsolation (int)
1.0
Yes
 
void setTypeMap (Map)
2.0 Core
Yes
Ignored.

DatabaseMetaData Object

Table A-7 DababaseMetaData Object 
DatabaseMetaData Object  
Methods
Version
Introduced
Supported
Comments
boolean allProceduresAreCallable ()
1.0
Yes
 
boolean allTablesAreSelectable ()
1.0
Yes
 
boolean dataDefinitionCausesTransaction
Commit ()
1.0
Yes
 
boolean dataDefinitionIgnoredInTransactions ()
1.0
Yes
 
boolean deletesAreDetected (int)
2.0 Core
Yes
 
boolean doesMaxRowSizeIncludeBlobs ()
1.0
Yes
Not supported by the SQL Server driver.
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
 
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
Names ()
1.0
Yes
 
boolean supportsExpressionsIn
OrderBy ()
1.0
Yes
 
boolean supportsExtendedSQLGrammar ()
1.0
Yes
 
boolean supportsFullOuterJoins ()
1.0
Yes
 
boolean supportsGetGeneratedKeys ()
3.0
Yes
 
boolean supportsGroupBy ()
1.0
Yes
 
boolean supportsGroupByBeyondSelect ()
1.0
Yes
 
boolean supportsGroupByUnrelated ()
1.0
Yes
 
boolean supportsIntegrityEnhancement
Facility ()
1.0
Yes
 
boolean supportsLikeEscapeClause ()
1.0
Yes
 
boolean supportsLimitedOuterJoins ()
1.0
Yes
 
boolean supportsMinimumSQLGrammar ()
1.0
Yes
 
boolean supportsMixedCaseIdentifiers ()
1.0
Yes
 
boolean supportsMixedCaseQuoted
Identifiers ()
1.0
Yes
 
boolean supportsMultipleOpenResults ()
3.0
Yes
 
boolean supportsMultipleResultSets ()
1.0
Yes
 
boolean supportsMultipleTransactions ()
1.0
Yes
 
boolean supportsNamedParameters ()
3.0
Yes
 
boolean supportsNonNullableColumns ()
1.0
Yes
 
boolean supportsOpenCursorsAcross
Commit ()
1.0
Yes
 
boolean supportsOpenCursorsAcross
Rollback ()
1.0
Yes
 
boolean supportsOpenStatementsAcross
Commit ()
1.0
Yes
 
boolean supportsOpenStatementsAcross
Rollback ()
1.0
Yes
 
boolean supportsOrderByUnrelated ()
1.0
Yes
 
boolean supportsOuterJoins ()
1.0
Yes
 
boolean supportsPositionedDelete ()
1.0
Yes
 
boolean supportsPositionedUpdate ()
1.0
Yes
 
boolean supportsResultSetConcurrency (int, int)
2.0 Core
Yes
 
boolean supportsResultSetHoldability (int)
3.0
Yes
 
boolean supportsResultSetType (int)
2.0 Core
Yes
 
boolean supportsSavePoints ()
3.0
Yes
 
boolean supportsSchemasInData
Manipulation ()
1.0
Yes
 
boolean supportsSchemasInIndex
Definitions ()
1.0
Yes
 
boolean supportsSchemasIn
PrivilegeDefinitions ()
1.0
Yes
 
boolean supportsSchemasInProcedure
Calls ()
1.0
Yes
 
boolean supportsSchemasInTable
Definitions ()
1.0
Yes
 
boolean supportsSelectForUpdate ()
1.0
Yes
 
boolean supportsStoredProcedures ()
1.0
Yes
 
boolean supportsSubqueriesIn
Comparisons ()
1.0
Yes
 
boolean supportsSubqueriesInExists ()
1.0
Yes
 
boolean supportsSubqueriesInIns ()
1.0
Yes
 
boolean supportsSubqueriesIn
Quantifieds ()
1.0
Yes
 
boolean supportsTableCorrelationNames ()
1.0
Yes
 
boolean supportsTransactionIsolationLevel (int)
1.0
Yes
 
boolean supportsTransactions ()
1.0
Yes
 
boolean supportsUnion ()
1.0
Yes
 
boolean supportsUnionAll ()
1.0
Yes
 
boolean updatesAreDetected (int)
2.0 Core
Yes
 
boolean usesLocalFilePerTable ()
1.0
Yes
 
boolean usesLocalFiles ()
1.0
Yes
 

Driver Object

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

ParameterMetaData Object

Table A-9 ParameterMetaData Object
ParameterMetaData Object
Methods
Version
Introduced
Supported
Comments
String getParameterClassName (int)
3.0
Yes
 
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
 
boolean jdbcCompliant ()
1.0
Yes
 

PreparedStatement Object

Table A-10 PreparedStatement Object 
PreparedStatement Object
Methods
Version
Introduced
Supported
Comments
void addBatch ()
2.0 Core
Yes
 
void clearParameters ()
1.0
Yes
 
boolean execute ()
1.0
Yes
 
ResultSet executeQuery ()
1.0
Yes
 
int executeUpdate ()
1.0
Yes
ResultSetMetaData getMetaData ()
2.0 Core
Yes
 
ParameterMetaData getParameterMetaData ()
3.0
Yes
 
void setArray (int, Array)
2.0 Core
No
Throws "unsupported method" exception.
void setAsciiStream (int, InputStream, int)
1.0
Yes
 
void setBigDecimal (int, BigDecimal)
1.0
Yes
 
void setBinaryStream (int, InputStream, int)
1.0
Yes
 
void setBlob (int, Blob)
2.0 Core
Yes
The SQL Server driver supports 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
 
void setCharacterStream (int, Reader, int)
2.0 Core
Yes
 
void setClob (int, Clob)
2.0 Core
Yes
The SQL Server driver supports 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 SQL Server driver 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.

Ref Object

Table A-11 Ref Object
Ref Object  
Methods
Version
Introduced
Supported
Comments
(all)
2.0 Core
No
 

ResultSet Object

Table A-12 ResultSet Object
ResultSet Object
Methods
Version
Introduced
Supported
Comments
boolean absolute (int)
2.0 Core
Yes
 
void afterLast ()
2.0 Core
Yes
void beforeFirst ()
2.0 Core
Yes
void cancelRowUpdates ()
2.0 Core
Yes
void clearWarnings ()
1.0
Yes
void close ()
1.0
Yes
void deleteRow ()
2.0 Core
Yes
int findColumn (String)
1.0
Yes
boolean first ()
2.0 Core
Yes
Array getArray (int)
2.0 Core
No
Throws "unsupported method" exception.
Array getArray (String)
2.0 Core
No
Throws "unsupported method" exception.
InputStream getAsciiStream (int)
1.0
Yes
 
InputStream getAsciiStream (String)
1.0
Yes
 
BigDecimal getBigDecimal (int)
2.0 Core
Yes
BigDecimal getBigDecimal (int, int)
1.0
Yes
BigDecimal getBigDecimal (String)
2.0 Core
Yes
BigDecimal getBigDecimal (String, int)
1.0
Yes
InputStream getBinaryStream (int)
1.0
Yes
 
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
The SQL Server driver supports using with data types that map to the JDBC LONGVARCHAR data type.
Clob getClob (String)
2.0 Core
Yes
The SQL Server driver supports 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
 
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 SQL Server driver supports using with data types that map to the JDBC LONGVARBINARY data type.
void updateBlob (String, Blob)
3.0
Yes
The SQL Server driver supports 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 driver supports using with data types that map to the JDBC LONGVARCHAR data type
void updateClob (String, Clob)
3.0
Yes
The SQL Server driver supports 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

ResultSetMetaData Object

Table A-13 ResultSetMetaData Object 
ResultSetMetaData Object  
Methods
Version
Introduced
Supported
Comments
String getCatalogName (int)
1.0
Yes
 
String getColumnClassName (int)
2.0 Core
Yes
 
int getColumnCount ()
1.0
Yes
 
int getColumnDisplaySize (int)
1.0
Yes
 
String getColumnLabel (int)
1.0
Yes
 
String getColumnName (int)
1.0
Yes
 
int getColumnType (int)
1.0
Yes
 
String getColumnTypeName (int)
1.0
Yes
 
int getPrecision (int)
1.0
Yes
 
int getScale (int)
1.0
Yes
 
String getSchemaName (int)
1.0
Yes
 
String getTableName (int)
1.0
Yes
For versions 3.4 and higher:
  • By default, getTableName returns an empty string for the SQL Server Type 4 driver.
  • To return a table name for the SQL Server Type 4 driver, add the following property to the connection pool Properties field:
         ResultsetMetaDataOptions=1
boolean isAutoIncrement (int)
1.0
Yes
 
boolean isCaseSensitive (int)
1.0
Yes
 
boolean isCurrency (int)
1.0
Yes
 
boolean isDefinitelyWritable (int)
1.0
Yes
 
int isNullable (int)
1.0
Yes
 
boolean isReadOnly (int)
1.0
Yes
 
boolean isSearchable (int)
1.0
Yes
 
boolean isSigned (int)
1.0
Yes
 
boolean isWritable (int)
1.0
Yes
 

SavePoint Object

Table A-14 SavePoint Object
SavePoint Object  
Methods
Version
Introduced
Supported
Comments
(all)
3.0
Yes
 

Statement Object

Table A-15 Statement Object 
Statement Object
Methods
Version
Introduced
Supported
Comments
void addBatch (String)
2.0 Core
Yes
Throws “invalid method call” exception for PreparedStatement and CallableStatement.
void cancel ()
1.0
Yes
The SQL Server driver cancels 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
 
boolean execute (String, String [])
3.0
Yes
 
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
 
int executeUpdate (String, String [])
3.0
Yes
 
Connection getConnection ()
2.0 Core
Yes
int getFetchDirection ()
2.0 Core
Yes
int getFetchSize ()
2.0 Core
Yes
ResultSet getGeneratedKeys ()
3.0
Yes
The SQL server driver returns 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.
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 SQL Server driver returns 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 SQL Server driver supports setting a timeout value, in seconds, for a statement. If the execution of the statement exceeds the timeout value, the statement is timed out by the database server, and the driver throws an exception indicating that the statement was timed out.

Struct Object

Table A-16 Struct Object 
Statement Object  
Methods
Version
Introduced
Supported
Comments
(all)
2.0
No
 


  Back to Top       Previous  Next