Version Compatibility

recommended jdbc driver versions this table describes the recommended versions of the jdbc driver and {{java}} for each {{ocient}} system release ocient system version jdbc driver version java version 25 5 3 6 7, 3 6 6, 3 6 5, and 3 6 4 8 or later 25 2 3 5 1 8 or later 25 1 3 4 1 8 or later 25 0 3 3 1 8 or later 24 3 and 24 4 3 2 x 11 or later 23 1, 24 0, 24 1, and 24 2 3 1 7 8 or later 23 0 3 0 8 or later jdbc versions 3 2 x are not compatible with java 8 version 3 3 0 is compatible ocient versions 22 0 and earlier might experience tail latency after submitting fetch data requests using jdbc driver version 3 0 0 to reduce this latency, upgrade to ocient version 23 0 or later jdbc api compatibility this table describes the specifications for each version of the jdbc api and whether it is supported by the latest ocient jdbc driver jdbc api version requirement support as of jdbc 2 93 4 3 enhanced databasemetadata to determine if sharding is supported supported 4 3 added the method drivers to drivermanager to return a stream of the currently loaded and available jdbc drivers supported 4 3 added support to statement for enquoting literals and simple identifiers supported 4 3 clarified the java se version that methods were deprecated supported 4 3 added sharding support not supported 4 3 enhanced connection to be able to provide hints to the driver that a request, an independent unit of work, is beginning or ending not supported 4 2 added jdbctype enum and sqltype interface supported 4 2 added support for large update counts supported 4 2 databasemetadata methods to return maximum logical lob size and if ref cursors are supported not supported 4 2 support for ref cursors in callablestatement not supported 4 1 allow connection, resultset and statement objects to be used with the try with resources statement supported 4 1 support added to callablestatement and resultset to specify the java type to convert to using the getobject method supported 4 1 added support to connection to specify a database schema, abort and timeout a physical connection supported 4 1 databasemetadata methods to return pseudocolumns and if a generated key is always returned not supported 4 1 added support to close a statement object when its dependent objects have been closed not supported 4 1 support for obtaining the parent logger for a driver, datasource, connectionpooldatasource and xadatasource not supported 4 0 auto java sql driver discovery no longer need to load a java sql driver class using class forname not supported 4 0 national character set support added not supported 4 0 support added for the sql 2003 xml data type not supported 4 0 sqlexception enhancements added support for cause chaining; new sqlexceptions added for common sqlstate class value codes not supported 4 0 enhanced blob/clob functionality support provided to create and free a blob/clob instance as well as additional methods added to improve accessibility not supported 4 0 support added for accessing a sql rowid not supported 4 0 support added to allow a jdbc application to access an instance of a jdbc resource that has been wrapped by a vendor, usually in an application server or connection pooling environment not supported 4 0 availability to be notified when a preparedstatement that is associated with a pooledconnection has been closed or the driver determines is invalid not supported 3 0 pooled statements reuse of statements associated with a pooled connection supported 3 0 savepoints allow a transaction to be rolled back to a designated savepoint not supported 3 0 properties defined for connectionpooldatasource specify how connections are to be pooled not supported 3 0 metadata for parameters of a preparedstatement object not supported 3 0 ability to retrieve values from automatically generated columns not supported 3 0 ability to have multiple resultset objects returned from callablestatement objects open at the same time not supported 3 0 ability to identify parameters to callablestatement objects by name as well as by index not supported 3 0 resultset holdability ability to specify whether cursors should be held open or closed at the end of a transaction not supported 3 0 ability to retrieve and update the sql structured type instance that a ref object references not supported 3 0 ability to programmatically update blob, clob, array, and ref values not supported 3 0 addition of the java sql types datalink data type allows jdbc drivers access to objects stored outside a data source not supported 3 0 addition of metadata for retrieving sql type hierarchies not supported 2 1 scrollable result sets using new methods in the resultset interface that allow the cursor to be moved to a particular row or to a position relative to its current position not supported 2 1 batch updates not supported 2 1 programmatic updates using resultset updater methods not supported 2 1 new data types interfaces mapping the sql3 data types not supported 2 1 custom mapping of user defined types (udts) not supported 2 1 miscellaneous features, including performance hints, the use of character streams, full precision for java math bigdecimal values, additional security, and support for time zones in date, time, and timestamp values not supported 2 0 pooled connections allowing connections to be used and reused supported 2 0 distributed transactions allowing a transaction to span diverse dbms servers supported 2 0 the datasource interface as a means of making a connection the {{jndi}} is used for registering a datasource object with a naming service and also for retrieving it not supported 2 0 rowset technology providing a convenient means of handling and passing data not supported recommended lat versions this table describes the recommended ocient loading and transformation (lat) versions for each ocient system release ocient system version minimum version recommended version 25 2 3 0 3 4 3 lat version 3 0 0 and greater is only compatible with version 22 0 and greater of the ocient system due to a change in the calculations of empty bounding boxes on geospatial data types related links docid\ dp2xebkp7vyuwzdqzpeia