Appendix B. Supported Databases

B.1. JDataStore
B.2. IBM DB2
B.2.1. Known issues with DB2
B.3. Hypersonic
B.3.1. Known issues with Hypersonic
B.4. Informix
B.4.1. Known issues with Informix
B.5. Microsoft Access
B.5.1. Known issues with Microsoft Access
B.6. Microsoft SQL Server
B.6.1. Known issues with SQL Server
B.7. Microsoft FoxPro
B.7.1. Known issues with Microsoft FoxPro
B.8. MySQL
B.8.1. Known issues with MySQL
B.9. Oracle
B.9.1. Known issues with Oracle
B.10. Pointbase
B.10.1. Known issues with Pointbase
B.11. PostgreSQL
B.11.1. Known issues with PostgreSQL
B.12. Sybase Adaptive Server
B.12.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 JDataStore6.0 Borland JDataStore 6.0
DB28.1 IBM DB2 JDBC Universal Driver 1.0.581
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 Driver2.0 (2.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.5jConnect4.2 (4.2)

B.1. JDataStore

Example B.1. Example properties for JDataStore

javax.jdo.option.ConnectionDriverName: \
    com.borland.datastore.jdbc.DataStoreDriver
javax.jdo.option.ConnectionURL: \
    jdbc:borland:dslocal:db-jdatastore.jds;create=true