Unsupported Methods and Methods that Behave Differently

The following JDBC API methods are not supported by IBM Informix JDBC Driver and cannot be used in a Java program that connects to an Informix database:

• CallableStatement.getRef(int)
• Connection.setCatalog()
• Connection.setReadOnly()
• PreparedStatement.addBatch(String)
• PreparedStatement.setRef(int, Ref)
• PreparedStatement.setUnicodeStream(int, java.io.InputStream, int)
• ResultSet.getRef(int)
• ResultSet.getRef(String)
• ResultSet.getUnicodeStream(int)
• ResultSet.getUnicodeStream(String)
• ResultSet.refreshRow()
• ResultSet.rowDeleted()
• ResultSet.rowInserted()
• ResultSet.rowUpdated()
• ResultSet.setFetchSize()
• Statement.cancel()
• Statement.setMaxFieldSize()
• Statement.setQueryTimeout()

The Connection.setCatalog() and Connection.setReadOnly() methods return with no error. The other methods, above, throw the exception: Method not Supported.

The following JDBC API methods behave other than specified by the JavaSoft specification:

• CallableStatement.execute()

  Returns a single result set

• DatabaseMetaData.getProcedureColumns()

  Ignores the columnNamePattern field; returns NULL when used with any server version older than 9.x

• DatabaseMetaData.othersUpdatesAreVisible()

  Always returns FALSE

• DatabaseMetaData.othersDeletesAreVisible()

  Always returns FALSE

• DatabaseMetaData.othersInsertsAreVisible()

  Always returns FALSE

• DatabaseMetaData.ownUpdatesAreVisible()

  Always returns FALSE

• DatabaseMetaData.ownDeletesAreVisible()

  Always returns FALSE

• DatabaseMetaData.ownInsertsAreVisible()

  Always returns FALSE

• DatabaseMetaData.deletesAreDetected()

  Always returns FALSE

• DatabaseMetaData.updatesAreDetected()

  Always returns FALSE

• DatabaseMetaData.insertsAreDetected()

  Always returns FALSE

• PreparedStatement.execute()

  Returns a single result set

• ResultSet.getFetchSize()

  Always returns 0

• ResultSetMetaData.getCatalogName()

  Always returns a String object containing one blank space

• ResultSetMetaData.getTableName()

  Returns the table name for SELECT, INSERT, and UPDATE statements

  SELECT statements with more than one table name and all other statements return a String object containing one blank space.

• ResultSetMetaData.getSchemaName()

  Always returns a String object containing one blank space

• ResultSetMetaData.isDefinitelyWriteable()

  Always returns TRUE

• ResultSetMetaData.isReadOnly()

  Always returns FALSE

• ResultSetMetaData.isWriteable()

  Always returns TRUE

• Statement.execute()

  Returns a single result set

• Connection.isReadOnly()

  Returns TRUE only when connecting to a secondary server in HDR scenario (see Important note below)