Appendix G. Supported Databases
Prev   Next

Appendix G. Supported Databases

Table of Contents

G.1. Example properties for Pointbase JDBC driver (Pointbase)
G.2. Example properties for InstantDB JDBC driver (InstantDB)
G.3. Example properties for Cloudscape JDBC driver (Cloudscape)
G.4. Example properties for DB2 JDBC driver (DB2)
G.5. Example properties for Oracle JDBC driver (Oracle)
G.6. Example properties for PostgreSQL Native Driver (PostgreSQL)
G.7. Example properties for SQLServer (Microsoft SQL Server)
G.8. Example properties for jConnect (Sybase Adaptive Server Enterprise)
G.9. Example properties for Hypersonic (Hypersonic Database Engine)
G.10. Example properties for MySQL Driver (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 Name Database Version JDBC Driver Name JDBC Driver Version
Pointbase4.2Pointbase JDBC driver4.2 (4.2)
InstantDB3.26InstantDB JDBC driver3.26 (3.26)
Cloudscape4.0.6Cloudscape JDBC driver4.0 (4.0.6)
DB27.2DB2 JDBC driver7.1 (7.1)
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 JDBC driver (Pointbase) 

javax.jdo.option.RetainValues: true
javax.jdo.option.RestoreValues: true
javax.jdo.option.Optimistic: true
javax.jdo.option.NontransactionalWrite: false
javax.jdo.option.NontransactionalRead: true
javax.jdo.option.Multithreaded: true
javax.jdo.option.MsWait: 5000
javax.jdo.option.MinPool: 1
javax.jdo.option.MaxPool: 80
javax.jdo.option.IgnoreCache: false
javax.jdo.option.ConnectionUserName: jdotestuser
javax.jdo.option.ConnectionURL: \
    jdbc:pointbase:jdotest,database.home=pointbasedb,create=true,cache.size=10000,database.pagesize=30720
javax.jdo.option.ConnectionPassword: PASSWORD
javax.jdo.option.ConnectionDriverName: \
    com.pointbase.jdbc.jdbcUniversalDriver
com.solarmetric.kodo.impl.jdbc.WarnOnPersistentTypeFailure: true
com.solarmetric.kodo.impl.jdbc.SequenceFactoryClass: \
    com.solarmetric.kodo.impl.jdbc.schema.DBSequenceFactory
com.solarmetric.kodo.impl.jdbc.FlatInheritanceMapping: true
com.solarmetric.kodo.LicenseKey: LICENSE_KEY
com.solarmetric.kodo.EnableQueryExtensions: false
com.solarmetric.kodo.DefaultFetchThreshold: 30
com.solarmetric.kodo.DefaultFetchBatchSize: 10

Prev Up Next
Appendix F. Known Bugs and Limitations Home G.2. Example properties for InstantDB JDBC driver (InstantDB)