[CONF] Apache Cayenne Documentation: Database Support (page edited)

[confluence]

Page Edited : CAYDOC : Database Support Database Support has been edited by Ari Maniatis (Apr 13, 2009). Change summary: Andrus fixed the Oracle issue (View changes) Content: 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 (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 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 (since Cayenne 1.2) 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 jjdbc: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 2005 Vendor Site http://www.microsoft.com/sql/technologies/jdbc/default.mspx 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   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

Powered by Atlassian Confluence (Version: 2.2.9 Build:#527 Sep 07, 2006) - Bug/feature request

Unsubscribe or edit your notifications preferences