JDBC Driver
The JDBC Driver is a pure Java implementation of the JDBC 4.2 API released with Oracle Java Platform SE 8. The driver supports application, applet, and servlet access to Actian X data sources through the Data Access Server.
The JDBC Driver supports the following JDBC features.
JDBC 4.2 features:
• Long (eight-byte) row counts – method variants with 'Large' in method name.
• Method variants that utilize the SQLType class.
• LocalDate, LocalTime, LocalDateTime, OffsetTime, OffsetDateTime classes.
• TIME_WITH_TIMEZONE and TIMESTAMP_WITH_TIMEZONE. Actian X supports corresponding types; the driver prior to 4.2 identified these types as TIME and TIMESTAMP types. For backward compatibility, the driver continues to identify the Actian X types as TIME/TIMESTAMP and return Time/Timestamp objects. The new types are supported as aliases for TIME and TIMESTAMP.
JDBC 4.1 features:
• Connection.abort()
• Connection.getNetworkTimeout() and Connection.setNetworkTimeout()
• DatabaseMetaData.generatedKeyAlwaysReturned()
• Statement.isCloseOnCompletion() and Statement.closeOnCompletion()
• CallableStatement.getObject( int, Class<T> ) and CallableStatement.getObject( String, Class<T> )
• ResultSet.getObject( int, Class<T> ) and ResultSet.getObject( String, Class<T> )
JDBC 4.0 features:
• Auto-loading of the driver
• National Character Set Support
• Support for createBlob(), createClob(), and createNClob Methods
• Support for java.sql.Wrapper Interface
JDBC 3.0 features:
• Updatable ResultSets
• Scrollable ResultSets
• Transaction savepoints
• Named procedure parameters
• Auto-generated keys
• Parameter metadata
• Blob and clob data objects
The JDBC Driver is delivered as a single Java archive file, named iijdbc.jar, located in the library directory (lib) of the Actian X instance. Depending on the Java environment used, access to the driver requires adding the Java archive to the CLASSPATH environment setting or as a resource in the appropriate utility. For browser/applet access, the Java archive must be copied to the Web Server directories.
Last modified date: 11/09/2022