Appendix 3. Supported Databases

3.1. Apache Derby
3.2. Borland Interbase
3.2.1. Known issues with Interbase
3.3. JDataStore
3.4. IBM DB2
3.4.1. Known issues with DB2
3.5. Empress
3.5.1. Known issues with Empress
3.6. Hypersonic
3.6.1. Known issues with Hypersonic
3.7. Firebird
3.7.1. Known issues with Firebird
3.8. Informix
3.8.1. Known issues with Informix
3.9. InterSystems Cache
3.9.1. Known issues with InterSystems Cache
3.10. Microsoft Access
3.10.1. Known issues with Microsoft Access
3.11. Microsoft SQL Server
3.11.1. Known issues with SQL Server
3.12. Microsoft FoxPro
3.12.1. Known issues with Microsoft FoxPro
3.13. MySQL
3.13.1. Known issues with MySQL
3.14. Oracle
3.14.1. Using Query Hints with Oracle
3.14.2. Known issues with Oracle
3.15. Pointbase
3.15.1. Known issues with Pointbase
3.16. PostgreSQL
3.16.1. Known issues with PostgreSQL
3.17. Sybase Adaptive Server
3.17.1. Known issues with Sybase

Following is a table of the database and JDBC driver versions that are supported by Kodo.

NOTE:When Kodo is used as the embedded JPA provider for Oracle WebLogic Server, the Oracle WebLogic Server database certifications list applies.

Table 3.1. Supported Databases and JDBC Drivers

Database NameDatabase VersionJDBC Driver NameJDBC Driver Version
Apache Derby10.1.2.1Apache Derby Embedded JDBC Driver10.1.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
DB29.1 IBM DB2 JDBC Universal Driver 3.1.57
Empress8.62 Empress Category 2 JDBC Driver 8.62
Firebird1.5JayBird JCA/JDBC driver1.0.1
Hypersonic Database Engine1.8.0Hypersonic1.8.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 9.00.1399 (SQL Server 2005) SQLServer1.0.809.102
Microsoft Visual FoxPro7.0 DataDirect SequeLink 5.4.0038
MySQL3.23.43-logMySQL Driver3.0.14
MySQL5.0.26MySQL Driver3.0.14
Oracle8.1,9.2,10.1Oracle JDBC driver10.
Pointbase4.4Pointbase JDBC driver4.4 (4.4)
PostgreSQL7.2.1PostgreSQL Native Driver8.1
PostgreSQL8.1.5PostgreSQL Native Driver8.1
Sybase Adaptive Server Enterprise 12.5jConnect6.05 (6.05)

3.1. Apache Derby

Example 3.1. Example properties for Derby

kodo.ConnectionDriverName: org.apache.derby.jdbc.EmbeddedDriver
kodo.ConnectionURL: jdbc:derby:DB_NAME;create=true


Skip navigation bar   Back to Top