DatabaseSupportDrivers

Database Support Drivers

Signsoft intelliBO supports a lot of databases with special drivers, that offers additional functionality to handle common problems with the original database drivers. We recommend you to use this Signsoft intelliBO drivers together with your JDBC driver.

This section contains a list with all class names of the Signsoft intelliBO database drivers.

Oracle 8

Support Driver

com.signsoft.ibo.dbsupport.oracle81x.OracleDatabaseInfo

Requires Oracle JDBC driver 8.1.7 or higher.

Oracle Native Sequence

Signsoft intelliBO supports oracle sequences. Please set the class name of the object id generator to

com.signsoft.ibo.dbsupport.oracle.OracleSequence

The following properties are needed:

sequence-name - the name of the Oracle sequence
field-name - the name of the primary key attribute
pre-allocation-size - number of keys fetched at once

Oracle 9

Support Driver

com.signsoft.ibo.dbsupport.oracle9x.OracleDatabaseInfo

Requires Oracle JDBC driver 9.0.x or higher.

Oracle Native Sequence

Signsoft intelliBO supports oracle sequences. Please set the class name of the object id generator to

com.signsoft.ibo.dbsupport.oracle.OracleSequence

The following properties are needed:

sequence-name - the name of the Oracle sequence
field-name - the name of the primary key attribute
pre-allocation-size - number of keys fetched at once

Oracle 10

Support Driver

com.signsoft.ibo.dbsupport.oracle10x.OracleDatabaseInfo

Requires Oracle JDBC driver 10.0.x or higher.

Oracle Native Sequence

Signsoft intelliBO supports oracle sequences. Please set the class name of the object id generator to

com.signsoft.ibo.dbsupport.oracle.OracleSequence

The following properties are needed:

sequence-name - the name of the Oracle sequence
field-name - the name of the primary key attribute
pre-allocation-size - number of keys fetched at once

DB2 UDB

Support Driver

com.signsoft.ibo.dbsupport.db2udb.DB2UDBDatabaseInfo

DB2 Native Sequence

Signsoft intelliBO supports sequences for DB2 UDB. Please set the class name of the object id generator to

com.signsoft.ibo.dbsupport.db2.DirectDB2Sequence

The following properties are needed:

sequence-name - the name of the DB2 sequence
field-name - the name of the primary key attribute
pre-allocation-size - number of keys fetched at once

Derby

com.signsoft.ibo.dbsupport.derby.DerbyDatabaseInfo

Firebird

com.signsoft.ibo.dbsupport.firebird2.FirebirdDatabaseInfo

Requires Firebird JDBC driver 2.0 or higher.

H2

com.signsoft.ibo.dbsupport.h2.H2DatabaseInfo

HSQL

com.signsoft.ibo.dbsupport.hsql.HSQLDatabaseInfo

Informix

com.signsoft.ibo.dbsupport.informix93.InformixDatabaseInfo

Requires Informix JDBC driver 9.3 or higher.

Mckoi

com.signsoft.ibo.dbsupport.mckoi.MckoiDatabaseInfo

Microsoft SQLServer

com.signsoft.ibo.dbsupport.mssql.MSSQLDatabaseInfo

MySQL

com.signsoft.ibo.dbsupport.mysql.MySqlDatabaseInfo

PostgreSQL

PostgreSQL JDBC driver 7 or higher:

com.signsoft.ibo.dbsupport.postgresql7.PostgreSQLDatabaseInfo

Note: only supports ResultSetType TYPE_FORWARD_ONLY

PostgreSQL JDBC driver 8 or higher:

com.signsoft.ibo.dbsupport.postgresql8.PostgreSQLDatabaseInfo

Sybase

com.signsoft.ibo.dbsupport.sybase2.SybaseDatabaseInfo