Following is a table of the dbversions and JDBC driver versions that are supported by Kodo JDO.
Table B.1. Supported Databases and JDBC Drivers
Database Name | Database Version | JDBC Driver Name | JDBC Driver Version |
---|---|---|---|
Borland Interbase | 7.1.0.202 | Interclient | 4.5.1 |
Borland JDataStore | 6.0 | Borland JDataStore | 6.0 |
DB2 | 8.1 | IBM DB2 JDBC Universal Driver | 1.0.581 |
Empress | 8.62 | Empress Category 2 JDBC Driver | 8.62 |
Firebird | 1.5 | JayBird JCA/JDBC driver | 1.0.1 |
Hypersonic Database Engine | 1.7.0 | Hypersonic | 1.7.0 |
Informix Dynamic Server | 9.30.UC10 | Informix JDBC driver | 2.21.JC2 |
InterSystems Cache | 5.0 | Cache JDBC Driver | 5.0 |
Microsoft Access | 9.0 (a.k.a. "2000") | DataDirect SequeLink | 5.4.0038 |
Microsoft SQL Server | 8.00.194 (SQL Server 2000) | SQLServer | 2.2 (2.2.0002) |
Microsoft Visual FoxPro | 7.0 | DataDirect SequeLink | 5.4.0038 |
MySQL | 3.23.43-log | MySQL Driver | 3.0.14 |
Oracle | 8.1-9.2 | Oracle JDBC driver | 9.0 (9.0.1.0.0) |
Pointbase | 4.4 | Pointbase JDBC driver | 4.4 (4.4) |
PostgreSQL | 7.2.1 | PostgreSQL Native Driver | 7.2 (7.2) |
Sybase Adaptive Server Enterprise | 12.5 | jConnect | 5.5 (5.5) |
Example B.1. Example properties for Interbase
javax.jdo.option.ConnectionDriverName: \ interbase.interclient.Driver javax.jdo.option.ConnectionURL: \ jdbc:interbase://SERVER_NAME:SERVER_PORT/DB_PATH
Interbase does not support record locking, so datastore transactions can use the pessimistic lock manager.
Interbase does not support the LOWER, SUBSTRING, or INSTR SQL functions, which means that toLowerCase(), indexOf(), and substring() methods in JDOQL cannot be used.