Cayenne User Documentation
Database Support

This page provides useful information about JDBC driver settings for various database. All databases below have custom Cayenne DbAdapters and are automatically recognized by Cayenne AutoAdapter.

Database | Driver Name | Sample URL | Notes
--- | --- | --- | ---
DB2 | com.ibm.db2.jcc.DB2Driver | jdbc:db2://127.0.0.1:50000/dbname |
Derby | org.apache.derby.jdbc.ClientDriver | jdbc:derby://127.0.0.1/testdb | client/server
| org.apache.derby.jdbc.EmbeddedDriver | jdbc:derby:path-to-hsql-db-files;create=true | embedded
FrontBase | jdbc.FrontBase.FBJDriver | jdbc:FrontBase://127.0.0.1/dbname |
HSQLDB | org.hsqldb.jdbcDriver | jdbc:hsqldb:hsql://127.0.0.1 | client/server
|  | jdbc:hsqldb: file:/path-to-hsql-db-files | embedded
H2 | org.h2.Driver | jdbc:h2:mem:myTestMem;MVCC=TRUE | embedded in-memory
Ingres | com.ingres.jdbc.IngresDriver | jdbc:ingres://127.0.0.1:II7/dbname |
MySQL | com.mysql.jdbc.Driver | jdbc:mysql://127.0.0.1/dbname |
OpenBase | com.openbase.jdbc.ObDriver | jdbc:openbase://127.0.0.1/dbname |
Oracle (10i, 9i, 8i, 8) | oracle.jdbc.driver.OracleDriver | jdbc:oracle:thin:@//127.0.0.1:1521/dbname |
PostgreSQL (7.4, 8.*) | org.postgresql.Driver | jdbc:postgresql://127.0.0.1:5432/dbname |
SQLite 3.* | org.sqlite.JDBC | jdbc:sqlite:path_to_dbfile | driver from zentus.com
SQLServer | com.microsoft.sqlserver.jdbc.SQLServerDriver | jdbc:sqlserver://127.0.0.1;databaseName=dbname | Microsoft Driver
| com.microsoft.jdbc.sqlserver.SQLServerDriver | jdbc:microsoft:sqlserver://127.0.0.1;databaseName=dbname;SelectMethod=cursor | Microsoft Driver, SQL Server prior to 2005
| net.sourceforge.jtds.jdbc.Driver | jdbc:jtds:sqlserver://127.0.0.1:5000/dbname | jTDS Driver
Sybase | com.sybase.jdbc3.jdbc.SybDriver | jdbc:sybase:Tds:127.0.0.1:5000/dbname | Sybase driver
| net.sourceforge.jtds.jdbc.Driver | jdbc:jtds:sybase://127.0.0.1:5000/dbname;useLOBs=false;TDS=4.2 | jTDS Driver

.
Copyright ©2001-2010 Apache Software Foundation