Using JDBC to connect to an Encyclopedia volume database
iHub uses JDBC for connecting to the system and Encyclopedia volume database. The iHub run-time JRE environment uses Java 1.6. Any JDBC driver must be compatible with JRE version 1.6 or earlier.
iHub requires a JDBC driver that complies with the JDBC 3.0 specification or later. The function Driver.jdbcCompliant( ) must return TRUE. DatabaseMetadata
.getJDBCMajorVersion( ) must return 3 or greater than 3.
An administrator, who decides to customize iHub to connect to a database other than the OOTB PostgreSQL database, must ensure that the JDBC driver returns adequate information about the types on the database. At a minimum, the database must return the common data types, such as integer, floating point, and character. If the database does not return these common data types, then the database administrator must customize the database mapping framework to specify the types.
The JDBC driver must also support the following features:

Scrollable cursor

Retention of a cursor after commit

Update using a prepared cursor
When using connection pooling, the tracing functionality of the JDBC driver captures connection pool run-time statistics.