blob: 4993a49e244f014ae6bf7b2e3b894f345ddcad94 [file] [log] [blame]
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Appendix&nbsp;2.&nbsp; Supported Databases</title><link rel="stylesheet" href="css/docbook.css" type="text/css"><base href="display"><meta name="generator" content="DocBook XSL Stylesheets V1.72.0"><link rel="start" href="manual.html" title="Apache OpenJPA 2.0 User's Guide"><link rel="up" href="appendices.html" title="Part&nbsp;4.&nbsp;Appendices"><link rel="prev" href="jpa_resources.html" title="Appendix&nbsp;1.&nbsp; JPA Resources"><link rel="next" href="dbsupport.html" title="2.&nbsp; Verified Database Matrix"></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Appendix&nbsp;2.&nbsp;
Supported Databases
</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="jpa_resources.html">Prev</a>&nbsp;</td><th width="60%" align="center">Part&nbsp;4.&nbsp;Appendices</th><td width="20%" align="right">&nbsp;<a accesskey="n" href="dbsupport.html">Next</a></td></tr></table><hr></div><div class="appendix" lang="en" id="supported_databases"><div class="titlepage"><div><div><h2 class="title"><a name="supported_databases"></a>Appendix&nbsp;2.&nbsp;
Supported Databases
</h2></div></div></div><div class="toc"><p><b>Table of Contents</b></p><dl><dt><span class="section"><a href="supported_databases.html#dbappendix">1.
Overview
</a></span></dt><dt><span class="section"><a href="dbsupport.html">2.
Verified Database Matrix
</a></span></dt><dt><span class="section"><a href="dbcompatible.html">3.
Compatible Database Matrix
</a></span></dt><dt><span class="section"><a href="dbsupport_derby.html">4.
Apache Derby
</a></span></dt><dt><span class="section"><a href="dbsupport_interbase.html">5.
Borland Interbase
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_interbase.html#dbsupport_interbase_issues">5.1.
Known issues with Interbase
</a></span></dt></dl></dd><dt><span class="section"><a href="dbsupport_jdatastore.html">6.
JDataStore
</a></span></dt><dt><span class="section"><a href="dbsupport_db2.html">7.
IBM DB2
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_db2.html#dbsupport_db2_issues">7.1.
Known issues with DB2
</a></span></dt></dl></dd><dt><span class="section"><a href="dbsupport_empress.html">8.
Empress
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_empress.html#dbsupport_empress_issues">8.1.
Known issues with Empress
</a></span></dt></dl></dd><dt><span class="section"><a href="dbsupport_h2.html">9.
H2 Database Engine
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_h2.html#dbsupport_h2_issues">9.1.
Known issues with H2 Database Engine
</a></span></dt></dl></dd><dt><span class="section"><a href="dbsupport_hypersonic.html">10.
Hypersonic
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_hypersonic.html#dbsupport_hypersonic_issues">10.1.
Known issues with Hypersonic
</a></span></dt></dl></dd><dt><span class="section"><a href="dbsupport_firebird.html">11.
Firebird
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_firebird.html#dbsupport_firebird_issues">11.1.
Known issues with Firebird
</a></span></dt></dl></dd><dt><span class="section"><a href="dbsupport_informix.html">12.
Informix
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_informix.html#dbsupport_informix_issues">12.1.
Known issues with Informix
</a></span></dt></dl></dd><dt><span class="section"><a href="dbsupport_ingres.html">13.
Ingres Database
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_ingres.html#dbsupport_ingres_issues">13.1.
Known issues with Ingres
</a></span></dt></dl></dd><dt><span class="section"><a href="dbsupport_intersystems_cache.html">14.
InterSystems Cache
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_intersystems_cache.html#dbsupport_intersystems_cache_issues">14.1.
Known issues with InterSystems Cache
</a></span></dt></dl></dd><dt><span class="section"><a href="dbsupport_access.html">15.
Microsoft Access
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_access.html#dbsupport_access_issues">15.1.
Known issues with Microsoft Access
</a></span></dt></dl></dd><dt><span class="section"><a href="dbsupport_sqlserver.html">16.
Microsoft SQL Server
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_sqlserver.html#dbsupport_sqlserver_issues">16.1.
Known issues with SQL Server
</a></span></dt></dl></dd><dt><span class="section"><a href="dbsupport_foxpro.html">17.
Microsoft FoxPro
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_foxpro.html#dbsupport_foxpro_issues">17.1.
Known issues with Microsoft FoxPro
</a></span></dt></dl></dd><dt><span class="section"><a href="dbsupport_mysql.html">18.
MySQL
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_mysql.html#dbsupport_mysql_query_hints">18.1.
Using Query Hints with MySQL
</a></span></dt><dt><span class="section"><a href="dbsupport_mysql.html#dbsupport_mysql_issues">18.2.
Known issues with MySQL
</a></span></dt></dl></dd><dt><span class="section"><a href="dbsupport_oracle.html">19.
Oracle
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_oracle.html#dbsupport_oracle_query_hints">19.1.
Using Query Hints with Oracle
</a></span></dt><dt><span class="section"><a href="dbsupport_oracle.html#dbsupport_oracle_issues">19.2.
Known issues with Oracle
</a></span></dt></dl></dd><dt><span class="section"><a href="dbsupport_pointbase.html">20.
Pointbase
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_pointbase.html#dbsupport_pointbase_issues">20.1.
Known issues with Pointbase
</a></span></dt></dl></dd><dt><span class="section"><a href="dbsupport_postgresql.html">21.
PostgreSQL
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_postgresql.html#dbsupport_postgresql_issues">21.1.
Known issues with PostgreSQL
</a></span></dt></dl></dd><dt><span class="section"><a href="dbsupport_sybase.html">22.
Sybase Adaptive Server
</a></span></dt><dd><dl><dt><span class="section"><a href="dbsupport_sybase.html#dbsupport_sybase_issues">22.1.
Known issues with Sybase
</a></span></dt></dl></dd></dl></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="dbappendix"></a>1.&nbsp;
Overview
</h2></div></div></div><p>
The following appendix covers the database and JDBC driver versions that are
known to work with OpenJPA, along with any database specific configuration
parameters, known issues or limitations.
The <a href="dbsupport.html" title="2.&nbsp; Verified Database Matrix">Verified Database Matrix</a>, contains the
list of databases and drivers that were tested extensively against this
release of OpenJPA, while the <a href="dbcompatible.html" title="3.&nbsp; Compatible Database Matrix">Compatible Database
Matrix</a> contains the list of databases and drivers that were tested
against prior releases or by OpenJPA users and may not support every feature
of this release.
</p></div></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="jpa_resources.html">Prev</a>&nbsp;</td><td width="20%" align="center"><a accesskey="u" href="appendices.html">Up</a></td><td width="40%" align="right">&nbsp;<a accesskey="n" href="dbsupport.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Appendix&nbsp;1.&nbsp;
JPA Resources
&nbsp;</td><td width="20%" align="center"><a accesskey="h" href="manual.html">Home</a></td><td width="40%" align="right" valign="top">&nbsp;2.&nbsp;
Verified Database Matrix
</td></tr></table></div></body></html>