JDBC Features for the Connection Mode

The JDBC driver enterpriseone connection mode explicitly does not support the following JDBC features:

  • Catalog methods (in DatabaseMetaData) with the exception of getCatalogs, getSchemas, getTables and getColumns.

  • Cursor names (Statement.setCursorName and ResultSet.getCursorName).

  • ResultSetMetaData as returned by PreparedStatement.getMetaData (the same information is available from ResultSet.getMetaData).

  • Result set holdability (Connection.createStatement, Connection.prepareStatement, Connection.prepareCall, and Statement.getResultSetHoldability).

  • Savepoints (Connection.setSavepoint and Connection.rollback).

  • Scrollable result sets (Connection.createStatement, Connection.prepareStatement, Connection.prepareCall, Statement.getResultSetType, and ResultSet.getType).

  • Stored procedures (Connection.prepareCall).

  • Type map (Connection.setTypeMap, Connection.getTypeMap, and ResultSet.getObject).

  • Update operations that involve JD Edwards EnterpriseOne software data (Statement.executeUpdate, PreparedStatement.executeUpdate, and ResultSet update methods).

In most cases, invoking these features results in an SQLException with a message describing the specific feature that is not supported.