docs/3.0/database-support.html

Title: Database Support

	<P>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.</P>


<H3><A name="DatabaseSupport-DB2"></A>DB2</H3>

<DIV class="table-wrap">
<TABLE class="confluenceTable"><TBODY>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://www.ibm.com/db2/" class="external-link" rel="nofollow">http://www.ibm.com/db2/</A></TD>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">com.ibm.db2.jcc.DB2Driver</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:db2://127.0.0.1:50000/dbname</TD>
</TR>
</TBODY></TABLE>
</DIV>



<H3><A name="DatabaseSupport-Derby"></A>Derby</H3>

<DIV class="table-wrap">
<TABLE class="confluenceTable"><TBODY>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://db.apache.org/derby/" class="external-link" rel="nofollow">http://db.apache.org/derby/</A></TD>
</TR>
<TR>
<TH class="confluenceTh">&nbsp;</TH>
<TH class="confluenceTh">Embedded</TH>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">org.apache.derby.jdbc.EmbeddedDriver</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:derby:path-to-hsql-db-files;create=true</TD>
</TR>
<TR>
<TH class="confluenceTh">&nbsp;</TH>
<TH class="confluenceTh">Remote Server</TH>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">org.apache.derby.jdbc.ClientDriver</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:derby://127.0.0.1/testdb</TD>
</TR>
</TBODY></TABLE>
</DIV>




<H3><A name="DatabaseSupport-FireBird%28Interbase%29"></A>FireBird (Interbase)</H3>

<DIV class="table-wrap">
<TABLE class="confluenceTable"><TBODY>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://firebird.sourceforge.net/" class="external-link" rel="nofollow">http://firebird.sourceforge.net/</A></TD>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">org.firebirdsql.jdbc.FBDriver</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:firebirdsql:127.0.0.1/10007:/path-to-dbname.fdb</TD>
</TR>
<TR>
<TD class="confluenceTd">Notes</TD>
<TD class="confluenceTd">FirebirdAdapter hasn't been well-tested for some time. Looking for volunteer FireBird users to help us.</TD>
</TR>
</TBODY></TABLE>
</DIV>


<H3><A name="DatabaseSupport-FrontBase"></A>FrontBase</H3>

<DIV class="table-wrap">
<TABLE class="confluenceTable"><TBODY>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://www.frontbase.com/" class="external-link" rel="nofollow">http://www.frontbase.com/</A></TD>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">jdbc.FrontBase.FBJDriver</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:FrontBase://127.0.0.1/dbname</TD>
</TR>
</TBODY></TABLE>
</DIV>



<H3><A name="DatabaseSupport-HSQLDB"></A>HSQLDB</H3>

<DIV class="table-wrap">
<TABLE class="confluenceTable"><TBODY>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://hsqldb.sourceforge.net/" class="external-link" rel="nofollow">http://hsqldb.sourceforge.net/</A></TD>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">org.hsqldb.jdbcDriver</TD>
</TR>
<TR>
<TH class="confluenceTh">&nbsp;</TH>
<TH class="confluenceTh">Embedded</TH>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:hsqldb:
<A href="file:///path-to-hsql-db-files" class="external-link" rel="nofollow">file:/path-to-hsql-db-files</A></TD>
</TR>
<TR>
<TH class="confluenceTh">&nbsp;</TH>
<TH class="confluenceTh">Remote Server</TH>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:hsqldb:hsql://127.0.0.1</TD>
</TR>
</TBODY></TABLE>
</DIV>



<H3><A name="DatabaseSupport-H2"></A>H2</H3>
<P><EM>(since Cayenne 3.0)</EM></P>


<DIV class="table-wrap">
<TABLE class="confluenceTable"><TBODY>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://www.h2database.com/" class="external-link" rel="nofollow">http://www.h2database.com/</A></TD>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">org.h2.Driver</TD>
</TR>
<TR>
<TH class="confluenceTh">&nbsp;</TH>
<TH class="confluenceTh">In Memory</TH>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:h2:mem:myTestMem;MVCC=TRUE</TD>
</TR>
</TBODY></TABLE>
</DIV>



<H3><A name="DatabaseSupport-Ingres"></A>Ingres</H3>
<P><EM>(since Cayenne 1.2)</EM></P>

<DIV class="table-wrap">
<TABLE class="confluenceTable"><TBODY>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://www.ingres.com/products/ingres-database.php" class="external-link" rel="nofollow">http://www.ingres.com/products/ingres-database.php</A></TD>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">com.ingres.jdbc.IngresDriver</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:ingres://127.0.0.1:II7/dbname</TD>
</TR>
</TBODY></TABLE>
</DIV>


<H3><A name="DatabaseSupport-MySQL"></A>MySQL</H3>

<DIV class="table-wrap">
<TABLE class="confluenceTable"><TBODY>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://www.mysql.com/" class="external-link" rel="nofollow">http://www.mysql.com/</A></TD>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">com.mysql.jdbc.Driver</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:mysql://127.0.0.1/dbname</TD>
</TR>
</TBODY></TABLE>
</DIV>


<H3><A name="DatabaseSupport-OpenBase"></A>OpenBase</H3>

<DIV class="table-wrap">
<TABLE class="confluenceTable"><TBODY>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://www.openbase.com/" class="external-link" rel="nofollow">http://www.openbase.com/</A></TD>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">com.openbase.jdbc.ObDriver</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:openbase://127.0.0.1/dbname</TD>
</TR>
</TBODY></TABLE>
</DIV>


<H3><A name="DatabaseSupport-Oracle%2810i%29"></A>Oracle (10i)</H3>

<DIV class="table-wrap">
<TABLE class="confluenceTable"><TBODY>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://oracle.com/" class="external-link" rel="nofollow">http://oracle.com/</A></TD>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">oracle.jdbc.driver.OracleDriver</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:oracle:thin:@//127.0.0.1:1521/dbname</TD>
</TR>
</TBODY></TABLE>
</DIV>


<H3><A name="DatabaseSupport-Oracle%288%2C8i%2C9i%29"></A>Oracle (8, 8i, 9i)</H3>

<DIV class="table-wrap">
<TABLE class="confluenceTable"><TBODY>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://oracle.com/" class="external-link" rel="nofollow">http://oracle.com/</A></TD>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">oracle.jdbc.driver.OracleDriver</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:oracle:thin:@127.0.0.1:1521:dbname</TD>
</TR>
</TBODY></TABLE>
</DIV>


<H3><A name="DatabaseSupport-PostgreSQL%287.4%2C8.%29"></A>PostgreSQL (7.4, 8.*)</H3>

<DIV class="table-wrap">
<TABLE class="confluenceTable"><TBODY>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://www.postgresql.org/" class="external-link" rel="nofollow">http://www.postgresql.org/</A></TD>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">org.postgresql.Driver</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:postgresql://127.0.0.1:5432/dbname</TD>
</TR>
</TBODY></TABLE>
</DIV>


<H3><A name="DatabaseSupport-SQLite3."></A>SQLite 3.*</H3>
<P><EM>(since Cayenne 3.0)</EM></P>

<DIV class="table-wrap">
<TABLE class="confluenceTable"><TBODY>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://www.sqlite.org/" class="external-link" rel="nofollow">http://www.sqlite.org/</A> <A href="http://www.zentus.com/sqlitejdbc/" class="external-link" rel="nofollow">http://www.zentus.com/sqlitejdbc/</A></TD>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">org.sqlite.JDBC</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:sqlite:path_to_dbfile</TD>
</TR>
</TBODY></TABLE>
</DIV>



<H3><A name="DatabaseSupport-SQLServer"></A>SQLServer</H3>

<DIV class="table-wrap">
<TABLE class="confluenceTable"><TBODY>
<TR>
<TH class="confluenceTh">&nbsp;</TH>
<TH class="confluenceTh">Microsoft Driver - SQL Server</TH>
</TR>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://msdn.microsoft.com/en-us/data/aa937724.aspx" class="external-link" rel="nofollow">http://msdn.microsoft.com/en-us/data/aa937724.aspx</A></TD>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">com.microsoft.sqlserver.jdbc.SQLServerDriver</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:sqlserver://127.0.0.1;databaseName=dbname</TD>
</TR>
<TR>
<TH class="confluenceTh">&nbsp;</TH>
<TH class="confluenceTh">Microsoft Driver - SQL Server prior to 2005</TH>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">com.microsoft.jdbc.sqlserver.SQLServerDriver</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:microsoft:sqlserver://127.0.0.1;databaseName=dbname;SelectMethod=cursor</TD>
</TR>
<TR>
<TH class="confluenceTh">&nbsp;</TH>
<TH class="confluenceTh">jTDS Driver</TH>
</TR>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://jtds.sourceforge.net/" class="external-link" rel="nofollow">http://jtds.sourceforge.net/</A></TD>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">net.sourceforge.jtds.jdbc.Driver</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:jtds:sqlserver://127.0.0.1:5000/dbname</TD>
</TR>
</TBODY></TABLE>
</DIV>


<H3><A name="DatabaseSupport-Sybase"></A>Sybase</H3>

<DIV class="table-wrap">
<TABLE class="confluenceTable"><TBODY>
<TR>
<TH class="confluenceTh">&nbsp;</TH>
<TH class="confluenceTh">Sybase Driver</TH>
</TR>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://www.sybase.com/" class="external-link" rel="nofollow">http://www.sybase.com/</A></TD>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">com.sybase.jdbc3.jdbc.SybDriver</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:sybase:Tds:127.0.0.1:5000/dbname</TD>
</TR>
<TR>
<TH class="confluenceTh">&nbsp;</TH>
<TH class="confluenceTh">jTDS Driver</TH>
</TR>
<TR>
<TD class="confluenceTd">Vendor Site</TD>
<TD class="confluenceTd"><A href="http://jtds.sourceforge.net/" class="external-link" rel="nofollow">http://jtds.sourceforge.net/</A></TD>
</TR>
<TR>
<TD class="confluenceTd">Driver Name</TD>
<TD class="confluenceTd">net.sourceforge.jtds.jdbc.Driver</TD>
</TR>
<TR>
<TD class="confluenceTd">Sample URL</TD>
<TD class="confluenceTd">jdbc:jtds:sybase://127.0.0.1:5000/dbname;useLOBs=false;TDS=4.2</TD>
</TR>
</TBODY></TABLE>
</DIV>