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.

### DB2

Vendor Site | http://www.ibm.com/db2/
Driver Name | com.ibm.db2.jcc.DB2Driver
Sample URL | jdbc:db2://127.0.0.1:50000/dbname

### Derby

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

### FireBird (Interbase)

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.

### FrontBase

Vendor Site | http://www.frontbase.com/
Driver Name | jdbc.FrontBase.FBJDriver
Sample URL | jdbc:FrontBase://127.0.0.1/dbname

### HSQLDB

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

### H2

(since Cayenne 3.0)

Vendor Site | http://www.h2database.com/
Driver Name | org.h2.Driver
| In Memory
--- | ---
Sample URL | jdbc:h2:mem:myTestMem;MVCC=TRUE

### Ingres

(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

### MySQL

Vendor Site | http://www.mysql.com/
Driver Name | com.mysql.jdbc.Driver
Sample URL | jdbc:mysql://127.0.0.1/dbname

### OpenBase

Vendor Site | http://www.openbase.com/
Driver Name | com.openbase.jdbc.ObDriver
Sample URL | jdbc:openbase://127.0.0.1/dbname

### Oracle (10i)

Vendor Site | http://oracle.com/
Driver Name | oracle.jdbc.driver.OracleDriver
Sample URL | jdbc:oracle:thin:@//127.0.0.1:1521/dbname

### Oracle (8, 8i, 9i)

Vendor Site | http://oracle.com/
Driver Name | oracle.jdbc.driver.OracleDriver
Sample URL | jdbc:oracle:thin:@127.0.0.1:1521:dbname

### PostgreSQL (7.4, 8.*)

Vendor Site | http://www.postgresql.org/
Driver Name | org.postgresql.Driver
Sample URL | jdbc:postgresql://127.0.0.1:5432/dbname

### SQLite 3.*

(since Cayenne 3.0)

Vendor Site | http://www.sqlite.org/ http://www.zentus.com/sqlitejdbc/
Driver Name | org.sqlite.JDBC
Sample URL | jdbc:sqlite:path_to_dbfile

### SQLServer

| Microsoft Driver - SQL Server
--- | ---
Vendor Site | http://msdn.microsoft.com/en-us/data/aa937724.aspx
Driver Name | com.microsoft.sqlserver.jdbc.SQLServerDriver
Sample URL | jdbc:sqlserver://127.0.0.1;databaseName=dbname
| Microsoft Driver - SQL Server prior to 2005
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

| 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

.
Copyright ©2001-2008 Apache Software Foundation