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
HSQLDB
H2
(since Cayenne 3.0)
Ingres
(since Cayenne 1.2)
MySQL
Vendor Site |
http://www.mysql.com/ |
Driver Name |
com.mysql.jdbc.Driver |
Sample URL |
jdbc:mysql://127.0.0.1/dbname |
OpenBase
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.*)
SQLite 3.*
(since Cayenne 3.0)
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 |