Unsupported java.sql methods and interfaces

For the Java 6 class distribution, the java.sql package conforms with the JDBC 4.x specification. However, the underlying Sybase implementation is at the JDBC 2.0 level. All JDBC methods included since the JDBC 2.0 specification are not supported. In addition, the following methods specified in JDBC 2.0 are not supported.

• Connection.commit( )

• Connection.getMetaData( )

• Connection.nativeSQL( )

• Connection.rollback( )

• Connection.setAutoCommit( )

• Connection.setCatalog( )

• Connection.setReadOnly( )

• Connection.setTransactionIsolation( )

• DatabaseMetaData.* – DatabaseMetaData is supported except for these methods:

  • deletesAreDetected()

  • getUDTs()

  • insertsAreDetected()

  • updatesAreDetected()

  • othersDeletesAreVisible()

  • othersInsertsAreVisible()

  • othersUpdatesAreVisible()

  • ownDeletesAreVisible()

  • ownInsertsAreVisible()

  • ownUpdatesAreVisible()

• PreparedStatement.setAsciiStream( )

• PreparedStatement.setUnicodeStream( )

• PreparedStatement.setBinaryStream( )

• ResultSetMetaData.getCatalogName( )

• ResultSetMetaData.getSchemaName( )

• ResultSetMetaData.getTableName( )

• ResultSetMetaData.isCaseSensitive( )

• ResultSetMetaData.isReadOnly( )

• ResultSetMetaData.isSearchable( )

• ResultSetMetaData.isWritable( )

• Statement.getMaxFieldSize( )

• Statement.setMaxFieldSize( )

• Statement.setCursorName( )

• Statement.setEscapeProcessing( )

• Statement.getQueryTimeout( )

• Statement.setQueryTimeoutt()