Documentation Index
Fetch the complete documentation index at: https://docs.ocient.com/llms.txt
Use this file to discover all available pages before exploring further.
Recommended JDBC Driver Versions
This table describes the recommended versions of the JDBC driver and for each System release.| Ocient System Version | JDBC Driver Version | Java Version |
|---|---|---|
| 27.0 | 4.1.0 | 8 or later |
| 26.1 | 3.7.0 and 4.0.0 | 8 or later |
| 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.
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 4.0.0 |
|---|---|---|
| 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 the maximum Logical LOB size and if Ref Cursors are supported | 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 | Supported |
| 4.0 | National Character Set support added | 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 | 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. | 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, and ARRAY values. | 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 | Supported |
| 2.1 | Programmatic updates—using ResultSet updater methods | Not Supported |
| 2.1 | New data types—interfaces mapping the SQL3 data types | 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. | 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 | Not Supported |
| 2.0 | The DataSource interface as a means of making a connection. The 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 |
|---|---|---|
| 27.0 | 3.0 | 3.6.2 |