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-db-dir;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 | oracle.jdbc.driver.OracleDriver | jdbc:oracle:thin:@//127.0.0.1:1521/dbname | |
| PostgreSQL | 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 |