Appendix B. Supported Databases

B.1. Borland Interbase
B.1.1. Known issues with Interbase
B.2. JDataStore
B.3. IBM DB2
B.3.1. Known issues with DB2
B.4. Empress
B.4.1. Known issues with Empress
B.5. Hypersonic
B.5.1. Known issues with Hypersonic
B.6. Firebird
B.7. Informix
B.7.1. Known issues with Informix
B.8. Microsoft Access
B.8.1. Known issues with Microsoft Access
B.9. Microsoft SQL Server
B.9.1. Known issues with SQL Server
B.10. Microsoft FoxPro
B.10.1. Known issues with Microsoft FoxPro
B.11. MySQL
B.11.1. Known issues with MySQL
B.12. Oracle
B.12.1. Known issues with Oracle
B.13. Pointbase
B.13.1. Known issues with Pointbase
B.14. PostgreSQL
B.14.1. Known issues with PostgreSQL
B.15. Sybase Adaptive Server
B.15.1. Known issues with Sybase

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 NameDatabase VersionJDBC Driver NameJDBC Driver Version
Borland Interbase7.1.0.202Interclient4.5.1
Borland JDataStore6.0 Borland JDataStore 6.0
DB28.1 IBM DB2 JDBC Universal Driver 1.0.581
Empress8.62 Empress Category 2 JDBC Driver 8.62
Firebird1.5JayBird JCA/JDBC driver1.0.1
Hypersonic Database Engine1.7.0Hypersonic1.7.0
Informix Dynamic Server9.30.UC10Informix JDBC driver2.21.JC2
Microsoft Access9.0 (a.k.a. "2000") DataDirect SequeLink 5.4.0038
Microsoft SQL Server 8.00.194 (SQL Server 2000) SQLServer2.2 (2.2.0002)
Microsoft Visual FoxPro7.0 DataDirect SequeLink 5.4.0038
MySQL3.23.43-logMySQL Driver3.0.14
Oracle8.1-9.2Oracle JDBC driver9.0 (9.0.1.0.0)
Pointbase4.4Pointbase JDBC driver4.4 (4.4)
PostgreSQL7.2.1PostgreSQL Native Driver7.2 (7.2)
Sybase Adaptive Server Enterprise 12.5jConnect5.5 (5.5)

B.1. Borland Interbase

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

B.1.1. Known issues with Interbase

  • Interbase does not support record locking, so datastore transactions can use the pessimistic lock manager.