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.
| Vendor Site | http://www.ibm.com/db2/ |
| Driver Name | com.ibm.db2.jcc.DB2Driver |
| Sample URL | jdbc:db2://127.0.0.1:50000/dbname |
(since Cayenne 1.2)
| Vendor Site | http://db.apache.org/derby/ |
| Embedded | |
|---|---|
| Driver Name | org.apache.derby.jdbc.EmbeddedDriver |
| Sample URL | jdbc:derby:path-to-hsql-db-files;create=true |
| Remote Server | |
| Driver Name | org.apache.derby.jdbc.ClientDriver |
| Sample URL | jdbc:derby://127.0.0.1/testdb |
| Vendor Site | http://firebird.sourceforge.net/ |
| Driver Name | org.firebirdsql.jdbc.FBDriver |
| Sample URL | jdbc:firebirdsql:127.0.0.1/10007:/path-to-dbname.fdb |
| Notes | FirebirdAdapter hasn't been well-tested for some time. Looking for volunteer FireBird users to help us. |
(since Cayenne 1.2)
| Vendor Site | http://www.frontbase.com/ |
| Driver Name | jdbc.FrontBase.FBJDriver |
| Sample URL | jdbc:FrontBase://127.0.0.1/dbname |
| Vendor Site | http://hsqldb.sourceforge.net/ |
| Driver Name | org.hsqldb.jdbcDriver |
| Embedded | |
|---|---|
| Sample URL | jdbc:hsqldb:file:/path-to-hsql-db-files |
| Remote Server | |
| Sample URL | jdbc:hsqldb:hsql://127.0.0.1 |
(since Cayenne 3.0)
| Vendor Site | http://www.h2database.com/ |
| Driver Name | org.h2.Driver |
| In Memory | |
|---|---|
| Sample URL | jjdbc:h2:mem:myTestMem;MVCC=TRUE |
(since Cayenne 1.2)
| Vendor Site | http://opensource.ca.com/projects/ingres/ |
| Driver Name | com.ingres.jdbc.IngresDriver |
| Sample URL | jdbc:ingres://127.0.0.1:II7/dbname |
| Vendor Site | http://www.mysql.com/ |
| Driver Name | com.mysql.jdbc.Driver |
| Sample URL | jdbc:mysql://127.0.0.1/dbname |
| Vendor Site | http://www.openbase.com/ |
| Driver Name | com.openbase.jdbc.ObDriver |
| Sample URL | jdbc:openbase://127.0.0.1/dbname |
| Vendor Site | http://oracle.com/ |
| Driver Name | oracle.jdbc.driver.OracleDriver |
| Sample URL | jdbc:oracle:thin:@//127.0.0.1:1521/dbname |
| Vendor Site | http://oracle.com/ |
| Driver Name | oracle.jdbc.driver.OracleDriver |
| Sample URL | jdbc:oracle:thin:@127.0.0.1:1521:dbname |
| Vendor Site | http://www.postgresql.org/ |
| Driver Name | org.postgresql.Driver |
| Sample URL | jdbc:postgresql://127.0.0.1:5432/dbname |
(since Cayenne 3.0)
| Vendor Site | http://www.sqlite.org/ |
| Driver Name | org.sqlite.JDBC |
| Sample URL | jdbc:sqlite:path_to_dbfile |
| Microsoft Driver - SQL Server 2005 | |
|---|---|
| Vendor Site | http://www.microsoft.com/sql/default.asp |
| Driver Name | com.microsoft.sqlserver.jdbc.SQLServerDriver |
| Sample URL | jdbc:sqlserver://127.0.0.1;databaseName=dbname |
| Microsoft Driver - SQL Server prior to 2005 | |
| Vendor Site | http://www.microsoft.com/sql/default.asp |
| Driver Name | com.microsoft.jdbc.sqlserver.SQLServerDriver |
| Sample URL | jdbc:microsoft:sqlserver://127.0.0.1;databaseName=dbname;SelectMethod=cursor |
| jTDS Driver | |
| Vendor Site | http://jtds.sourceforge.net/ |
| Driver Name | net.sourceforge.jtds.jdbc.Driver |
| Sample URL | jdbc:jtds:sqlserver://127.0.0.1:5000/dbname |
| Sybase Driver | |
|---|---|
| Vendor Site | http://www.sybase.com/ |
| Driver Name | com.sybase.jdbc3.jdbc.SybDriver |
| Sample URL | jdbc:sybase:Tds:127.0.0.1:5000/dbname |
| jTDS Driver | |
| Vendor Site | http://jtds.sourceforge.net/ |
| Driver Name | net.sourceforge.jtds.jdbc.Driver |
| Sample URL | jdbc:jtds:sybase://127.0.0.1:5000/dbname;useLOBs=false;TDS=4.2 |