Appendix B. Supported Databases

B.1. Apache Derby
B.1.1. Known issues with Derbyt
B.2. Borland Interbase
B.2.1. Known issues with Interbase
B.3. JDataStore
B.4. IBM DB2
B.4.1. Known issues with DB2
B.5. Empress
B.5.1. Known issues with Empress
B.6. Hypersonic
B.6.1. Known issues with Hypersonic
B.7. Firebird
B.7.1. Known issues with Firebird
B.8. Informix
B.8.1. Known issues with Informix
B.9. InterSystems Cache
B.9.1. Known issues with InterSystems Cache
B.10. Microsoft Access
B.10.1. Known issues with Microsoft Access
B.11. Microsoft SQL Server
B.11.1. Known issues with SQL Server
B.12. Microsoft FoxPro
B.12.1. Known issues with Microsoft FoxPro
B.13. MySQL
B.13.1. Known issues with MySQL
B.14. Oracle
B.14.1. Known issues with Oracle
B.15. Pointbase
B.15.1. Known issues with Pointbase
B.16. PostgreSQL
B.16.1. Known issues with PostgreSQL
B.17. Sybase Adaptive Server
B.17.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
Apache Derby10.0.2.1Apache Derby Embedded JDBC Driver10.0.2.1
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
InterSystems Cache5.0Cache JDBC Driver5.0
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. Apache Derby

Example B.1. Example properties for Derby

javax.jdo.option.ConnectionDriverName: org.apache.derby.jdbc.EmbeddedDriver
javax.jdo.option.ConnectionURL: jdbc:derby:DB_NAME;create=true

B.1.1. Known issues with Derbyt

  • Apache Derby is still in pre-release (or "incubator" stage), so future versions may introduce incompatibilities with the current dictionary.