Appendix G. Supported Databases

G.1. Example properties for Pointbase
G.2. Example properties for IBM DB2
G.3. Example properties for Informix Dynamic Server
G.4. Example properties for Oracle
G.5. Example properties for PostgreSQL
G.6. Example properties for SQLServer
G.7. Example properties for Sybase
G.8. Example properties for Hypersonic
G.9. Example properties for MySQL

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

Table G.1. Supported Databases and JDBC Drivers

Database NameDatabase VersionJDBC Driver NameJDBC Driver Version
Pointbase4.2Pointbase JDBC driver4.2 (4.2)
Informix Dynamic Server9.30.UC10Informix JDBC driver2.21.JC2
DB28.1IBM DB2 JDBC Universal Driver1.0.581
Oracle8.1-9.1Oracle JDBC driver9.0 (9.0.1.0.0)
PostgreSQL7.2.1PostgreSQL Native Driver7.2 (7.2)
Microsoft SQL Server8.00.194 (SQL Server 2000)SQLServer2.2 (2.2.0002)
Sybase Adaptive Server Enterprise12.5jConnect4.2 (4.2)
Hypersonic Database Engine1.6Hypersonic1.6 (1.6)
MySQL3.23.43-logMySQL Driver2.0 (2.0.14)

G.1. Example properties for Pointbase

javax.jdo.option.ConnectionDriverName: \
    com.pointbase.jdbc.jdbcUniversalDriver
javax.jdo.option.ConnectionURL: \
    jdbc:pointbase:DB_NAME,database.home=pointbasedb,create=true,cache.size=10000,database.pagesize=30720
javax.jdo.option.ConnectionUserName: USERNAME
javax.jdo.option.ConnectionPassword: PASSWORD
com.solarmetric.kodo.LicenseKey: LICENSE_KEY