JDBC drivers must be JDBC 3.0 compatible. Specifically, the function Driver.jdbcCompliant() must return TRUE, and DatabaseMetadata.getJDBCMajorVersion() must return at least 3. Because the iServer compiler is based on Java 1.5, JDBC drivers should be compatible with JRE version 1.5 or earlier.
The JDBC driver must be able to retrieve a list of tables using the DataBaseMetaData.getTables() method. Some tables returned by this method may not be callable by the database user specified in the data connection definition. Actuate SQL queries that use these tables may fail at query execution time. For Information Object Designer to display only the tables that can be selected, DataBaseMetaData.allTablesAreSelectable() must return TRUE.
The JDBC driver must be able to retrieve a list of stored procedures using the DataBaseMetaData.getProcedures() method. Some stored procedures returned by this method may not be callable by the database user specified in the data connection definition. Actuate SQL queries that use these stored procedures may fail at query execution time. For Information Object Designer to display only the callable stored procedures, DataBaseMetaData.allProceduresAreCallable() must return TRUE.
