Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbcompatible.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbcompatible.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbcompatible.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,198 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>3. Compatible Database Matrix</title><base
href="display"><link rel="stylesheet" type="text/css"
href="css/docbook.css"><meta name="generator" content="DocBook XSL Stylesheets
V1.79.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.4 User's
Guide"><link rel="up" href="supported_databases.html"
title="Appendix 2. Supported Databases"><link rel="prev"
href="dbsupport.html" title="2. Verified Database Matrix"><link
rel="next" href="dbunverified.html" title="4. Unverified 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">3.
+ Compatible Database Matrix
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="dbsupport.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbunverified.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbcompatible"><div class="titlepage"><div><div><h2
class="title" style="clear: both">3.
+ Compatible Database Matrix
+ </h2></div></div></div>
+
+ <p>
+Following is a table of the database and JDBC driver versions that are
+compatible with OpenJPA. Some of these databases have been tested against this
+version of OpenJPA, while others were added or tested in prior releases and
+may not support all of the new features of this release. For the list of
+databases that have been fully tested against this release, please refer to the
+<a class="link" href="dbsupport.html" title="2. Verified Database
Matrix">Verified Database Matrix</a> section.
+ </p>
+ <div class="table" id="d5e17696"><p class="title"><b>Table 2.2.
+ Compatible Databases and JDBC Drivers
+ </b></p><div class="table-contents">
+
+ <table class="table" summary="
 Compatible Databases
and JDBC Drivers
 " border="1"><colgroup><col align="left"
class="dbname"><col align="left" class="dbversion"><col align="left"
class="drivname"><col align="left"
class="drivversion"></colgroup><thead><tr><th align="left">
+ Database Name
+ </th><th align="left">
+ Database Version
+ </th><th align="left">
+ JDBC Driver Name
+ </th><th align="left">
+ JDBC Driver Version
+ </th></tr></thead><tbody><tr><td align="left">
+ <a class="link" href="dbsupport_derby.html"
title="5. Apache Derby">Apache Derby</a>
+ </td><td align="left">
+ 10.1.2.1
+ </td><td align="left">
+ Apache Derby Embedded JDBC Driver
+ </td><td align="left">
+ 10.1.2.1
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_interbase.html"
title="6. Borland Interbase">Borland Interbase</a>
+ </td><td align="left">
+ 7.1.0.202
+ </td><td align="left">
+ Interclient
+ </td><td align="left">
+ 4.5.1
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_jdatastore.html"
title="7. JDataStore">Borland JDataStore</a>
+ </td><td align="left">
+ 6.0
+ </td><td align="left">
+ Borland JDataStore
+ </td><td align="left">
+ 6.0
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_db2.html"
title="8. IBM DB2">DB2</a>
+ </td><td align="left">
+ 8.1
+ </td><td align="left">
+ IBM DB2 JDBC Universal Driver
+ </td><td align="left">
+ 1.0.581, 2.10.72
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_empress.html"
title="9. Empress">Empress</a>
+ </td><td align="left">
+ 8.62
+ </td><td align="left">
+ Empress Category 2 JDBC Driver
+ </td><td align="left">
+ 8.62
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_firebird.html"
title="12. Firebird">Firebird</a>
+ </td><td align="left">
+ 1.5, 2.0, 2.1
+ </td><td align="left">
+ JayBird JCA/JDBC driver
+ </td><td align="left">
+ 2.1.6
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_h2.html"
title="10. H2 Database Engine">H2 Database Engine</a>
+ </td><td align="left">
+ 1.1.118
+ </td><td align="left">
+ H2
+ </td><td align="left">
+ Same as Database Version
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_hypersonic.html"
title="11. Hypersonic">Hypersonic Database Engine</a>
+ </td><td align="left">
+ 1.8.0, 2.0.1 RC2
+ </td><td align="left">
+ Hypersonic
+ </td><td align="left">
+ Same as Database Version
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_informix.html"
title="13. Informix">Informix Dynamic Server</a>
+ </td><td align="left">
+ 9.30.UC10, 9.4xC7
+ </td><td align="left">
+ Informix JDBC driver
+ </td><td align="left">
+ 2.21.JC2, 3.00 JC3, 3.10 JC1
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_ingres.html"
title="14. Ingres Database">Ingres Database</a>
+ </td><td align="left">
+ 9.2
+ </td><td align="left">
+ Ingres JDBC Driver
+ </td><td align="left">
+ 9.2-3.4.8
+ </td></tr><tr><td align="left">
+ <a class="link"
href="dbsupport_intersystems_cache.html" title="15. InterSystems
Cache">InterSystems Cache</a>
+ </td><td align="left">
+ 5.0
+ </td><td align="left">
+ Cache JDBC Driver
+ </td><td align="left">
+ 5.0
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_access.html"
title="16. Microsoft Access">Microsoft Access</a>
+ </td><td align="left">
+ 9.0 (a.k.a. "2000")
+ </td><td align="left">
+ DataDirect SequeLink
+ </td><td align="left">
+ 5.4.0038
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_sqlserver.html"
title="17. Microsoft SQL Server">Microsoft SQL Server</a>
+ </td><td align="left">
+ 2000 (8.00)
+ </td><td align="left">
+ Microsoft SQL Server JDBC Driver
+ </td><td align="left">
+ 1.2
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_foxpro.html"
title="18. Microsoft FoxPro">Microsoft Visual FoxPro</a>
+ </td><td align="left">
+ 7.0
+ </td><td align="left">
+ DataDirect SequeLink
+ </td><td align="left">
+ 5.4.0038
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_mysql.html"
title="19. MySQL">MySQL</a>
+ </td><td align="left">
+ 3.23.43-log
+ </td><td align="left">
+ MySQL Driver
+ </td><td align="left">
+ 3.0.14
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_oracle.html"
title="20. Oracle">Oracle</a>
+ </td><td align="left">
+ 8.1, 9.2
+ </td><td align="left">
+ Oracle JDBC driver
+ </td><td align="left">
+ 10.2.0.1
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_pointbase.html"
title="21. Pointbase">Pointbase</a>
+ </td><td align="left">
+ 4.4
+ </td><td align="left">
+ Pointbase JDBC driver
+ </td><td align="left">
+ 4.4 (4.4)
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_postgresql.html"
title="22. PostgreSQL">PostgreSQL</a>
+ </td><td align="left">
+ 7.2.1, 8.1.5
+ </td><td align="left">
+ PostgreSQL Native Driver
+ </td><td align="left">
+ 8.1
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_soliddb.html"
title="23. IBM solidDB">IBM solidDB</a>
+ </td><td align="left">
+ 6.5.0.0
+ </td><td align="left">
+ solidDB JDBC Driver
+ </td><td align="left">
+ 2.0
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_sybase.html"
title="24. Sybase Adaptive Server">Sybase Adaptive Server Enterprise</a>
+ </td><td align="left">
+ 12.5
+ </td><td align="left">
+ jConnect
+ </td><td align="left">
+ 5.5 (5.5)
+ </td></tr></tbody></table>
+ </div></div><br class="table-break">
+
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="dbsupport.html">Prev</a> </td><td width="20%" align="center"><a
accesskey="u" href="supported_databases.html">Up</a></td><td width="40%"
align="right"> <a accesskey="n"
href="dbunverified.html">Next</a></td></tr><tr><td width="40%" align="left"
valign="top">2.
+ Verified Database Matrix
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 4.
+ Unverified Database Matrix
+ </td></tr></table></div></body></html>
\ No newline at end of file
Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,108 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>2. Verified Database Matrix</title><base href="display"><link
rel="stylesheet" type="text/css" href="css/docbook.css"><meta name="generator"
content="DocBook XSL Stylesheets V1.79.1"><link rel="home" href="manual.html"
title="Apache OpenJPA 2.4 User's Guide"><link rel="up"
href="supported_databases.html" title="Appendix 2. Supported
Databases"><link rel="prev" href="supported_databases.html"
title="Appendix 2. Supported Databases"><link rel="next"
href="dbcompatible.html" title="3. Compatible 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">2.
+ Verified Database Matrix
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="supported_databases.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbcompatible.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbsupport"><div class="titlepage"><div><div><h2
class="title" style="clear: both">2.
+ Verified Database Matrix
+ </h2></div></div></div>
+
+ <p>
+Following is a table of the supported database and JDBC driver versions that
+have been verified against this version of OpenJPA. For the list of other
+databases and drivers that were tested in prior releases or by other OpenJPA
+users, but may not support every feature of this release, please refer to the
+<a class="link" href="dbcompatible.html" title="3. Compatible Database
Matrix">Compatible Database Matrix</a> section.
+ </p>
+ <div class="table" id="d5e17624"><p class="title"><b>Table 2.1.
+ Supported Databases and JDBC Drivers
+ </b></p><div class="table-contents">
+
+ <table class="table" summary="
 Supported Databases and
JDBC Drivers
 " border="1"><colgroup><col align="left"
class="dbname"><col align="left" class="dbversion"><col align="left"
class="drivname"><col align="left"
class="drivversion"></colgroup><thead><tr><th align="left">
+ Database Name
+ </th><th align="left">
+ Database Version
+ </th><th align="left">
+ JDBC Driver Name
+ </th><th align="left">
+ JDBC Driver Version
+ </th></tr></thead><tbody><tr><td align="left">
+ <a class="link" href="dbsupport_derby.html"
title="5. Apache Derby">Apache Derby</a>
+ </td><td align="left">
+ 10.2.2.0, 10.3.3.0, 10.4.2.0, 10.5.3.0, 10.8.2.2
+ </td><td align="left">
+ Apache Derby Embedded JDBC Driver
+ </td><td align="left">
+ Same as Database Version
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_db2.html"
title="8. IBM DB2">IBM DB2</a>
+ </td><td align="left">
+ 8.1, 8.2, 9.1, 9.5, 9.7
+ </td><td align="left">
+ IBM DB2 JDBC Universal Driver
+ </td><td align="left">
+ 3.50.152
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_informix.html"
title="13. Informix">IBM Informix Dynamic Server</a>
+ </td><td align="left">
+ 10.00xC6, 11.10xC1, 11.5xC1
+ </td><td align="left">
+ Informix JDBC driver
+ </td><td align="left">
+ 3.00 JC3, 3.10 JC1, 3.50 JC1
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_sqlserver.html"
title="17. Microsoft SQL Server">Microsoft SQL Server</a>
+ </td><td align="left">
+ 2005 (9.00), 2008 (10.00)
+ </td><td align="left">
+ Microsoft SQL Server JDBC Driver
+ </td><td align="left">
+ 1.2 or 2.0
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_mysql.html"
title="19. MySQL">MySQL</a>
+ </td><td align="left">
+ 5.0.26, 5.1.6
+ </td><td align="left">
+ MySQL Driver
+ </td><td align="left">
+ 5.1.6
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_oracle.html"
title="20. Oracle">Oracle</a>
+ </td><td align="left">
+ 10g (10.1, 10.2), 11g (11.1, 11.2)
+ </td><td align="left">
+ Oracle JDBC driver
+ </td><td align="left">
+ 11.2.0.1
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_postgresql.html"
title="22. PostgreSQL">PostgreSQL</a>
+ </td><td align="left">
+ 8.3.5, 8.4
+ </td><td align="left">
+ PostgreSQL Native Driver
+ </td><td align="left">
+ 8.3 JDBC3 (build 603), 8.4 JDBC3 (build 701)
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_soliddb.html"
title="23. IBM solidDB">IBM solidDB</a>
+ </td><td align="left">
+ 6.5.0.0
+ </td><td align="left">
+ solidDB JDBC Driver
+ </td><td align="left">
+ 2.0
+ </td></tr><tr><td align="left">
+ <a class="link" href="dbsupport_sybase.html"
title="24. Sybase Adaptive Server">Sybase Adaptive Server Enterprise</a>
+ </td><td align="left">
+ 12.5, 15.0
+ </td><td align="left">
+ jConnect
+ </td><td align="left">
+ 5.5, 6.0
+ </td></tr></tbody></table>
+ </div></div><br class="table-break">
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="supported_databases.html">Prev</a> </td><td width="20%"
align="center"><a accesskey="u" href="supported_databases.html">Up</a></td><td
width="40%" align="right"> <a accesskey="n"
href="dbcompatible.html">Next</a></td></tr><tr><td width="40%" align="left"
valign="top">Appendix 2.
+ Supported Databases
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 3.
+ Compatible Database Matrix
+ </td></tr></table></div></body></html>
\ No newline at end of file
Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_access.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_access.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_access.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,36 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>16. Microsoft Access</title><base href="display"><link
rel="stylesheet" type="text/css" href="css/docbook.css"><meta name="generator"
content="DocBook XSL Stylesheets V1.79.1"><link rel="home" href="manual.html"
title="Apache OpenJPA 2.4 User's Guide"><link rel="up"
href="supported_databases.html" title="Appendix 2. Supported
Databases"><link rel="prev" href="dbsupport_intersystems_cache.html"
title="15. InterSystems Cache"><link rel="next"
href="dbsupport_sqlserver.html" title="17. Microsoft SQL
Server"></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">16.
+ Microsoft Access
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="dbsupport_intersystems_cache.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbsupport_sqlserver.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbsupport_access"><div class="titlepage"><div><div><h2
class="title" style="clear: both">16.
+ Microsoft Access
+ </h2></div></div></div><div class="toc"><dl class="toc"><dt><span
class="section"><a href="dbsupport_access.html#dbsupport_access_issues">16.1.
+ Known issues with Microsoft Access
+ </a></span></dt></dl></div>
+
+ <div class="example" id="example_props_access"><p
class="title"><b>Example 2.12.
+ Example properties for Microsoft Access
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: com.ddtek.jdbc.sequelink.SequeLinkDriver
+openjpa.ConnectionURL: jdbc:sequelink://SERVER_NAME:SERVER_PORT
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" id="dbsupport_access_issues"><div
class="titlepage"><div><div><h3 class="title">16.1.
+ Known issues with Microsoft Access
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist"
style="list-style-type: disc; "><li class="listitem">
+ <p>
+Using the Sun JDBC-ODBC bridge to connect is not supported.
+ </p>
+ </li></ul></div>
+ </div>
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="dbsupport_intersystems_cache.html">Prev</a> </td><td width="20%"
align="center"><a accesskey="u" href="supported_databases.html">Up</a></td><td
width="40%" align="right"> <a accesskey="n"
href="dbsupport_sqlserver.html">Next</a></td></tr><tr><td width="40%"
align="left" valign="top">15.
+ InterSystems Cache
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 17.
+ Microsoft SQL Server
+ </td></tr></table></div></body></html>
\ No newline at end of file
Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_db2.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_db2.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_db2.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,83 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>8. IBM DB2</title><base href="display"><link rel="stylesheet"
type="text/css" href="css/docbook.css"><meta name="generator" content="DocBook
XSL Stylesheets V1.79.1"><link rel="home" href="manual.html" title="Apache
OpenJPA 2.4 User's Guide"><link rel="up" href="supported_databases.html"
title="Appendix 2. Supported Databases"><link rel="prev"
href="dbsupport_jdatastore.html" title="7. JDataStore"><link rel="next"
href="dbsupport_empress.html" title="9. Empress"></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">8.
+ IBM DB2
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="dbsupport_jdatastore.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbsupport_empress.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbsupport_db2"><div class="titlepage"><div><div><h2
class="title" style="clear: both">8.
+ IBM DB2
+ </h2></div></div></div><div class="toc"><dl class="toc"><dt><span
class="section"><a href="dbsupport_db2.html#dbsupport_db2_issues">8.1.
+ Known issues with DB2
+ </a></span></dt></dl></div>
+
+ <div class="example" id="example_props_db2"><p
class="title"><b>Example 2.4.
+ Example properties for IBM DB2
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: com.ibm.db2.jcc.DB2Driver
+openjpa.ConnectionURL: jdbc:db2://SERVER_NAME:SERVER_PORT/DB_NAME
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" id="dbsupport_db2_issues"><div
class="titlepage"><div><div><h3 class="title">8.1.
+ Known issues with DB2
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist"
style="list-style-type: disc; "><li class="listitem">
+ <p>
+Floats and doubles may lose precision when stored.
+ </p>
+ </li><li class="listitem">
+ <p>
+Empty char values are stored as NULL.
+ </p>
+ </li><li class="listitem">
+ <p>
+Fields of type BLOB and CLOB are limited to 1M. This number can be increased by
+extending <code class="classname">DB2Dictionary</code>.
+ </p>
+ </li><li class="listitem">
+ <p>
+Explicit creation of indexes specified by the OpenJPA @Index annotation will
+fail on DB2 for iSeries if the default schema used by the JDBC driver does not
+exist. If a default schema is not specified on the connection, the iSeries
+will default to the user profile name. If a schema of that name does not
+exist, DB2 on iSeries will not create the schema, resulting in a failure when
+creating the index. The failure message will look similar to: "[SQL0204]
+USERNAME in QSYS type *LIB not found." To work around this issue, specify a
+default schema on the JDBC URL or data source property and make sure that
+schema exists or create a schema which matches the user profile of the
+connection.
+ </p>
+ </li><li class="listitem">
+ <p>
+Use of DB2 on z/OS with the IBM JCC driver requires the DESCSTAT subsystem
+parameter value to be set to 'YES'. If this parameter is set to 'NO', the
+mapping tool will fail with a persistence exception containing this text:
+"Invalid parameter: Unknown column name TABLE_SCHEM". After changing the
value
+of DESCSTAT, DB2 metadata tables must be recreated by running the DSNTIJMS
job.
+See DB2 for z/OS documentation for additional information.
+ </p>
+ </li><li class="listitem">
+ <p>
+When using LOBs with persistent attributes of a streaming data type (e.g.
+<code class="literal">java.io.InputStream</code>) in the case of very large
LOB, DB2 JCC
+driver will automatically use progressive streaming to retrieve the LOB data.
+With progressiveStreaming, the inputStream retrieved must be fully materialized
+before the next iteration of call to rs.next(). By default
+this will result in a LobClosedException when OpenJPA processes the
InputStream.
+ </p>
+ <p>
+To work around this condition you may force fullyMaterializedLobData to true
in
+the connection URL as shown below :
+</p><pre class="programlisting">
+openjpa.ConnectionURL:
jdbc:db2://localhost:50000/demodb:fullyMaterializeLobData=true;progressiveStreaming=NO
+</pre><p>
+ </p>
+ </li></ul></div>
+ </div>
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="dbsupport_jdatastore.html">Prev</a> </td><td width="20%"
align="center"><a accesskey="u" href="supported_databases.html">Up</a></td><td
width="40%" align="right"> <a accesskey="n"
href="dbsupport_empress.html">Next</a></td></tr><tr><td width="40%"
align="left" valign="top">7.
+ JDataStore
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 9.
+ Empress
+ </td></tr></table></div></body></html>
\ No newline at end of file
Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_derby.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_derby.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_derby.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,24 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>5. Apache Derby</title><base href="display"><link
rel="stylesheet" type="text/css" href="css/docbook.css"><meta name="generator"
content="DocBook XSL Stylesheets V1.79.1"><link rel="home" href="manual.html"
title="Apache OpenJPA 2.4 User's Guide"><link rel="up"
href="supported_databases.html" title="Appendix 2. Supported
Databases"><link rel="prev" href="dbunverified.html" title="4. Unverified
Database Matrix"><link rel="next" href="dbsupport_interbase.html"
title="6. Borland Interbase"></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">5.
+ Apache Derby
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="dbunverified.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbsupport_interbase.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbsupport_derby"><div class="titlepage"><div><div><h2
class="title" style="clear: both">5.
+ Apache Derby
+ </h2></div></div></div>
+
+ <div class="example" id="example_props_derby"><p
class="title"><b>Example 2.1.
+ Example properties for Derby
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: org.apache.derby.jdbc.EmbeddedDriver
+openjpa.ConnectionURL: jdbc:derby:DB_NAME;create=true
+</pre>
+ </div></div><br class="example-break">
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="dbunverified.html">Prev</a> </td><td width="20%" align="center"><a
accesskey="u" href="supported_databases.html">Up</a></td><td width="40%"
align="right"> <a accesskey="n"
href="dbsupport_interbase.html">Next</a></td></tr><tr><td width="40%"
align="left" valign="top">4.
+ Unverified Database Matrix
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 6.
+ Borland Interbase
+ </td></tr></table></div></body></html>
\ No newline at end of file
Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_empress.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_empress.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_empress.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,42 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>9. Empress</title><base href="display"><link rel="stylesheet"
type="text/css" href="css/docbook.css"><meta name="generator" content="DocBook
XSL Stylesheets V1.79.1"><link rel="home" href="manual.html" title="Apache
OpenJPA 2.4 User's Guide"><link rel="up" href="supported_databases.html"
title="Appendix 2. Supported Databases"><link rel="prev"
href="dbsupport_db2.html" title="8. IBM DB2"><link rel="next"
href="dbsupport_h2.html" title="10. H2 Database Engine"></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">9.
+ Empress
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="dbsupport_db2.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbsupport_h2.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbsupport_empress"><div class="titlepage"><div><div><h2
class="title" style="clear: both">9.
+ Empress
+ </h2></div></div></div><div class="toc"><dl class="toc"><dt><span
class="section"><a href="dbsupport_empress.html#dbsupport_empress_issues">9.1.
+ Known issues with Empress
+ </a></span></dt></dl></div>
+
+ <div class="example" id="example_props_empress"><p
class="title"><b>Example 2.5.
+ Example properties for Empress
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: empress.jdbc.empressDriver
+openjpa.ConnectionURL:
jdbc:empress://SERVER=yourserver;PORT=6322;DATABASE=yourdb
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" id="dbsupport_empress_issues"><div
class="titlepage"><div><div><h3 class="title">9.1.
+ Known issues with Empress
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist"
style="list-style-type: disc; "><li class="listitem">
+ <p>
+Empress enforces pessimistic semantics (lock on
+read) when not using <code class="literal">AllowConcurrentRead</code> property
(which
+bypasses row locking) for <code class="classname">EmpressDictionary</code>.
+ </p>
+ </li><li class="listitem">
+ <p>
+Only the category 2 non-local driver is supported.
+ </p>
+ </li></ul></div>
+ </div>
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="dbsupport_db2.html">Prev</a> </td><td width="20%" align="center"><a
accesskey="u" href="supported_databases.html">Up</a></td><td width="40%"
align="right"> <a accesskey="n"
href="dbsupport_h2.html">Next</a></td></tr><tr><td width="40%" align="left"
valign="top">8.
+ IBM DB2
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 10.
+ H2 Database Engine
+ </td></tr></table></div></body></html>
\ No newline at end of file
Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_firebird.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_firebird.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_firebird.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,41 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>12. Firebird</title><base href="display"><link
rel="stylesheet" type="text/css" href="css/docbook.css"><meta name="generator"
content="DocBook XSL Stylesheets V1.79.1"><link rel="home" href="manual.html"
title="Apache OpenJPA 2.4 User's Guide"><link rel="up"
href="supported_databases.html" title="Appendix 2. Supported
Databases"><link rel="prev" href="dbsupport_hypersonic.html" title="11.
Hypersonic"><link rel="next" href="dbsupport_informix.html" title="13.
Informix"></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">12.
+ Firebird
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="dbsupport_hypersonic.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbsupport_informix.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbsupport_firebird"><div class="titlepage"><div><div><h2
class="title" style="clear: both">12.
+ Firebird
+ </h2></div></div></div><div class="toc"><dl class="toc"><dt><span
class="section"><a
href="dbsupport_firebird.html#dbsupport_firebird_issues">12.1.
+ Known issues with Firebird
+ </a></span></dt></dl></div>
+
+ <div class="example" id="example_props_firebird"><p
class="title"><b>Example 2.8.
+ Example properties for Firebird
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: org.firebirdsql.jdbc.FBDriver
+openjpa.ConnectionURL: jdbc:firebirdsql:SERVER_NAME/3050:DB_PATH_OR_ALIAS
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" id="dbsupport_firebird_issues"><div
class="titlepage"><div><div><h3 class="title">12.1.
+ Known issues with Firebird
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist"
style="list-style-type: disc; "><li class="listitem">
+ <p>
+Firebird does not support auto-increment columns.
+ </p>
+ </li><li class="listitem">
+ <p>
+In order to use many of JPQL functions with Firebird 1.5, Interbase UDFs
+have to be available in the database.
+ </p>
+ </li></ul></div>
+ </div>
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="dbsupport_hypersonic.html">Prev</a> </td><td width="20%"
align="center"><a accesskey="u" href="supported_databases.html">Up</a></td><td
width="40%" align="right"> <a accesskey="n"
href="dbsupport_informix.html">Next</a></td></tr><tr><td width="40%"
align="left" valign="top">11.
+ Hypersonic
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 13.
+ Informix
+ </td></tr></table></div></body></html>
\ No newline at end of file
Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_foxpro.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_foxpro.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_foxpro.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,36 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>18. Microsoft FoxPro</title><base href="display"><link
rel="stylesheet" type="text/css" href="css/docbook.css"><meta name="generator"
content="DocBook XSL Stylesheets V1.79.1"><link rel="home" href="manual.html"
title="Apache OpenJPA 2.4 User's Guide"><link rel="up"
href="supported_databases.html" title="Appendix 2. Supported
Databases"><link rel="prev" href="dbsupport_sqlserver.html" title="17.
Microsoft SQL Server"><link rel="next" href="dbsupport_mysql.html"
title="19. MySQL"></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">18.
+ Microsoft FoxPro
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="dbsupport_sqlserver.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbsupport_mysql.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbsupport_foxpro"><div class="titlepage"><div><div><h2
class="title" style="clear: both">18.
+ Microsoft FoxPro
+ </h2></div></div></div><div class="toc"><dl class="toc"><dt><span
class="section"><a href="dbsupport_foxpro.html#dbsupport_foxpro_issues">18.1.
+ Known issues with Microsoft FoxPro
+ </a></span></dt></dl></div>
+
+ <div class="example" id="example_props_foxpro"><p
class="title"><b>Example 2.14.
+ Example properties for Microsoft FoxPro
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: com.ddtek.jdbc.sequelink.SequeLinkDriver
+openjpa.ConnectionURL: jdbc:sequelink://SERVER_NAME:SERVER_PORT
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" id="dbsupport_foxpro_issues"><div
class="titlepage"><div><div><h3 class="title">18.1.
+ Known issues with Microsoft FoxPro
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist"
style="list-style-type: disc; "><li class="listitem">
+ <p>
+Using the Sun JDBC-ODBC bridge to connect is not supported.
+ </p>
+ </li></ul></div>
+ </div>
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="dbsupport_sqlserver.html">Prev</a> </td><td width="20%"
align="center"><a accesskey="u" href="supported_databases.html">Up</a></td><td
width="40%" align="right"> <a accesskey="n"
href="dbsupport_mysql.html">Next</a></td></tr><tr><td width="40%" align="left"
valign="top">17.
+ Microsoft SQL Server
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 19.
+ MySQL
+ </td></tr></table></div></body></html>
\ No newline at end of file
Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_h2.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_h2.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_h2.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,36 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>10. H2 Database Engine</title><base href="display"><link
rel="stylesheet" type="text/css" href="css/docbook.css"><meta name="generator"
content="DocBook XSL Stylesheets V1.79.1"><link rel="home" href="manual.html"
title="Apache OpenJPA 2.4 User's Guide"><link rel="up"
href="supported_databases.html" title="Appendix 2. Supported
Databases"><link rel="prev" href="dbsupport_empress.html" title="9.
Empress"><link rel="next" href="dbsupport_hypersonic.html" title="11.
Hypersonic"></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">10.
+ H2 Database Engine
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="dbsupport_empress.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbsupport_hypersonic.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbsupport_h2"><div class="titlepage"><div><div><h2
class="title" style="clear: both">10.
+ H2 Database Engine
+ </h2></div></div></div><div class="toc"><dl class="toc"><dt><span
class="section"><a href="dbsupport_h2.html#dbsupport_h2_issues">10.1.
+ Known issues with H2 Database Engine
+ </a></span></dt></dl></div>
+
+ <div class="example" id="example_props_h2"><p
class="title"><b>Example 2.6.
+ Example properties for H2 Database Engine
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: org.h2.Driver
+openjpa.ConnectionURL: jdbc:h2:DB_NAME
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" id="dbsupport_h2_issues"><div
class="titlepage"><div><div><h3 class="title">10.1.
+ Known issues with H2 Database Engine
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist"
style="list-style-type: disc; "><li class="listitem">
+ <p>
+None
+ </p>
+ </li></ul></div>
+ </div>
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="dbsupport_empress.html">Prev</a> </td><td width="20%"
align="center"><a accesskey="u" href="supported_databases.html">Up</a></td><td
width="40%" align="right"> <a accesskey="n"
href="dbsupport_hypersonic.html">Next</a></td></tr><tr><td width="40%"
align="left" valign="top">9.
+ Empress
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 11.
+ Hypersonic
+ </td></tr></table></div></body></html>
\ No newline at end of file
Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_hypersonic.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_hypersonic.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_hypersonic.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,38 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>11. Hypersonic</title><base href="display"><link
rel="stylesheet" type="text/css" href="css/docbook.css"><meta name="generator"
content="DocBook XSL Stylesheets V1.79.1"><link rel="home" href="manual.html"
title="Apache OpenJPA 2.4 User's Guide"><link rel="up"
href="supported_databases.html" title="Appendix 2. Supported
Databases"><link rel="prev" href="dbsupport_h2.html" title="10. H2
Database Engine"><link rel="next" href="dbsupport_firebird.html"
title="12. Firebird"></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">11.
+ Hypersonic
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="dbsupport_h2.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbsupport_firebird.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbsupport_hypersonic"><div class="titlepage"><div><div><h2
class="title" style="clear: both">11.
+ Hypersonic
+ </h2></div></div></div><div class="toc"><dl class="toc"><dt><span
class="section"><a
href="dbsupport_hypersonic.html#dbsupport_hypersonic_issues">11.1.
+ Known issues with Hypersonic
+ </a></span></dt></dl></div>
+
+ <div class="example" id="example_props_hypersonic"><p
class="title"><b>Example 2.7.
+ Example properties for Hypersonic
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: org.hsqldb.jdbcDriver
+openjpa.ConnectionURL: jdbc:hsqldb:DB_NAME
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" id="dbsupport_hypersonic_issues"><div
class="titlepage"><div><div><h3 class="title">11.1.
+ Known issues with Hypersonic
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist"
style="list-style-type: disc; "><li class="listitem">
+ <p>
+Hypersonic does not support pessimistic locking, so non-optimistic transactions
+will fail unless the <code class="literal">SimulateLocking</code> property is
set for the
+<a class="link" href="ref_guide_conf_jdbc.html#openjpa.jdbc.DBDictionary"
title="6.2. openjpa.jdbc.DBDictionary"> openjpa.jdbc.DBDictionary</a>
+ </p>
+ </li></ul></div>
+ </div>
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="dbsupport_h2.html">Prev</a> </td><td width="20%" align="center"><a
accesskey="u" href="supported_databases.html">Up</a></td><td width="40%"
align="right"> <a accesskey="n"
href="dbsupport_firebird.html">Next</a></td></tr><tr><td width="40%"
align="left" valign="top">10.
+ H2 Database Engine
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 12.
+ Firebird
+ </td></tr></table></div></body></html>
\ No newline at end of file
Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_informix.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_informix.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_informix.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,37 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>13. Informix</title><base href="display"><link
rel="stylesheet" type="text/css" href="css/docbook.css"><meta name="generator"
content="DocBook XSL Stylesheets V1.79.1"><link rel="home" href="manual.html"
title="Apache OpenJPA 2.4 User's Guide"><link rel="up"
href="supported_databases.html" title="Appendix 2. Supported
Databases"><link rel="prev" href="dbsupport_firebird.html" title="12.
Firebird"><link rel="next" href="dbsupport_ingres.html" title="14. Ingres
Database"></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">13.
+ Informix
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="dbsupport_firebird.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbsupport_ingres.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbsupport_informix"><div class="titlepage"><div><div><h2
class="title" style="clear: both">13.
+ Informix
+ </h2></div></div></div><div class="toc"><dl class="toc"><dt><span
class="section"><a
href="dbsupport_informix.html#dbsupport_informix_issues">13.1.
+ Known issues with Informix
+ </a></span></dt></dl></div>
+
+ <div class="example" id="example_props_informix"><p
class="title"><b>Example 2.9.
+ Example properties for Informix Dynamic Server
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: com.informix.jdbc.IfxDriver
+openjpa.ConnectionURL: \
+ jdbc:informix-sqli://SERVER_NAME:SERVER_PORT/DB_NAME:INFORMIXSERVER=SERVER_ID
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" id="dbsupport_informix_issues"><div
class="titlepage"><div><div><h3 class="title">13.1.
+ Known issues with Informix
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist"
style="list-style-type: disc; "><li class="listitem">
+ <p>
+None
+ </p>
+ </li></ul></div>
+ </div>
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="dbsupport_firebird.html">Prev</a> </td><td width="20%"
align="center"><a accesskey="u" href="supported_databases.html">Up</a></td><td
width="40%" align="right"> <a accesskey="n"
href="dbsupport_ingres.html">Next</a></td></tr><tr><td width="40%" align="left"
valign="top">12.
+ Firebird
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 14.
+ Ingres Database
+ </td></tr></table></div></body></html>
\ No newline at end of file
Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_ingres.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_ingres.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_ingres.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,38 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>14. Ingres Database</title><base href="display"><link
rel="stylesheet" type="text/css" href="css/docbook.css"><meta name="generator"
content="DocBook XSL Stylesheets V1.79.1"><link rel="home" href="manual.html"
title="Apache OpenJPA 2.4 User's Guide"><link rel="up"
href="supported_databases.html" title="Appendix 2. Supported
Databases"><link rel="prev" href="dbsupport_informix.html" title="13.
Informix"><link rel="next" href="dbsupport_intersystems_cache.html"
title="15. InterSystems Cache"></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">14.
+ Ingres Database
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="dbsupport_informix.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbsupport_intersystems_cache.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbsupport_ingres"><div class="titlepage"><div><div><h2
class="title" style="clear: both">14.
+ Ingres Database
+ </h2></div></div></div><div class="toc"><dl class="toc"><dt><span
class="section"><a href="dbsupport_ingres.html#dbsupport_ingres_issues">14.1.
+ Known issues with Ingres
+ </a></span></dt></dl></div>
+
+ <div class="example" id="example_props_ingres"><p
class="title"><b>Example 2.10.
+ Example properties for Ingres
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: com.ingres.jdbc.IngresDriver
+openjpa.ConnectionURL: \
+ jdbc:ingres://SERVER_NAME:DAS_SERVER_PORT/DB_NAME
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" id="dbsupport_ingres_issues"><div
class="titlepage"><div><div><h3 class="title">14.1.
+ Known issues with Ingres
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist"
style="list-style-type: disc; "><li class="listitem">
+ <p>
+ Databases must be created with the -n flag for Unicode
compatibility in
+ order to use LOBs.
+ </p>
+ </li></ul></div>
+ </div>
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="dbsupport_informix.html">Prev</a> </td><td width="20%"
align="center"><a accesskey="u" href="supported_databases.html">Up</a></td><td
width="40%" align="right"> <a accesskey="n"
href="dbsupport_intersystems_cache.html">Next</a></td></tr><tr><td width="40%"
align="left" valign="top">13.
+ Informix
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 15.
+ InterSystems Cache
+ </td></tr></table></div></body></html>
\ No newline at end of file
Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_interbase.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_interbase.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_interbase.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,42 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>6. Borland Interbase</title><base href="display"><link
rel="stylesheet" type="text/css" href="css/docbook.css"><meta name="generator"
content="DocBook XSL Stylesheets V1.79.1"><link rel="home" href="manual.html"
title="Apache OpenJPA 2.4 User's Guide"><link rel="up"
href="supported_databases.html" title="Appendix 2. Supported
Databases"><link rel="prev" href="dbsupport_derby.html" title="5. Apache
Derby"><link rel="next" href="dbsupport_jdatastore.html" title="7.
JDataStore"></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">6.
+ Borland Interbase
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="dbsupport_derby.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbsupport_jdatastore.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbsupport_interbase"><div class="titlepage"><div><div><h2
class="title" style="clear: both">6.
+ Borland Interbase
+ </h2></div></div></div><div class="toc"><dl class="toc"><dt><span
class="section"><a
href="dbsupport_interbase.html#dbsupport_interbase_issues">6.1.
+ Known issues with Interbase
+ </a></span></dt></dl></div>
+
+ <div class="example" id="example_props_interbase"><p
class="title"><b>Example 2.2.
+ Example properties for Interbase
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: interbase.interclient.Driver
+openjpa.ConnectionURL: jdbc:interbase://SERVER_NAME:SERVER_PORT/DB_PATH
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" id="dbsupport_interbase_issues"><div
class="titlepage"><div><div><h3 class="title">6.1.
+ Known issues with Interbase
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist"
style="list-style-type: disc; "><li class="listitem">
+ <p>
+Interbase does not support record locking, so
+datastore transactions cannot use the pessimistic lock manager.
+ </p>
+ </li><li class="listitem">
+ <p>
+Interbase does not support the <code class="literal">LOWER</code>,
+<code class="literal">SUBSTRING</code>, or <code class="literal">INSTR</code>
SQL functions.
+ </p>
+ </li></ul></div>
+ </div>
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="dbsupport_derby.html">Prev</a> </td><td width="20%"
align="center"><a accesskey="u" href="supported_databases.html">Up</a></td><td
width="40%" align="right"> <a accesskey="n"
href="dbsupport_jdatastore.html">Next</a></td></tr><tr><td width="40%"
align="left" valign="top">5.
+ Apache Derby
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 7.
+ JDataStore
+ </td></tr></table></div></body></html>
\ No newline at end of file
Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_intersystems_cache.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_intersystems_cache.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_intersystems_cache.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,37 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>15. InterSystems Cache</title><base href="display"><link
rel="stylesheet" type="text/css" href="css/docbook.css"><meta name="generator"
content="DocBook XSL Stylesheets V1.79.1"><link rel="home" href="manual.html"
title="Apache OpenJPA 2.4 User's Guide"><link rel="up"
href="supported_databases.html" title="Appendix 2. Supported
Databases"><link rel="prev" href="dbsupport_ingres.html" title="14.
Ingres Database"><link rel="next" href="dbsupport_access.html" title="16.
Microsoft Access"></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">15.
+ InterSystems Cache
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="dbsupport_ingres.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbsupport_access.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbsupport_intersystems_cache"><div
class="titlepage"><div><div><h2 class="title" style="clear: both">15.
+ InterSystems Cache
+ </h2></div></div></div><div class="toc"><dl class="toc"><dt><span
class="section"><a
href="dbsupport_intersystems_cache.html#dbsupport_intersystems_cache_issues">15.1.
+ Known issues with InterSystems Cache
+ </a></span></dt></dl></div>
+
+ <div class="example" id="example_props_intersystems_cache"><p
class="title"><b>Example 2.11.
+ Example properties for InterSystems Cache
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: com.intersys.jdbc.CacheDriver
+openjpa.ConnectionURL: jdbc:Cache://SERVER_NAME:SERVER_PORT/DB_NAME
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" id="dbsupport_intersystems_cache_issues"><div
class="titlepage"><div><div><h3 class="title">15.1.
+ Known issues with InterSystems Cache
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist"
style="list-style-type: disc; "><li class="listitem">
+ <p>
+Support for Cache is done via SQL access over JDBC, not through their object
+database APIs.
+ </p>
+ </li></ul></div>
+ </div>
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="dbsupport_ingres.html">Prev</a> </td><td width="20%"
align="center"><a accesskey="u" href="supported_databases.html">Up</a></td><td
width="40%" align="right"> <a accesskey="n"
href="dbsupport_access.html">Next</a></td></tr><tr><td width="40%" align="left"
valign="top">14.
+ Ingres Database
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 16.
+ Microsoft Access
+ </td></tr></table></div></body></html>
\ No newline at end of file
Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_jdatastore.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_jdatastore.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_jdatastore.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,24 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>7. JDataStore</title><base href="display"><link
rel="stylesheet" type="text/css" href="css/docbook.css"><meta name="generator"
content="DocBook XSL Stylesheets V1.79.1"><link rel="home" href="manual.html"
title="Apache OpenJPA 2.4 User's Guide"><link rel="up"
href="supported_databases.html" title="Appendix 2. Supported
Databases"><link rel="prev" href="dbsupport_interbase.html" title="6.
Borland Interbase"><link rel="next" href="dbsupport_db2.html" title="8.
IBM DB2"></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">7.
+ JDataStore
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="dbsupport_interbase.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbsupport_db2.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbsupport_jdatastore"><div class="titlepage"><div><div><h2
class="title" style="clear: both">7.
+ JDataStore
+ </h2></div></div></div>
+
+ <div class="example" id="example_props_jdatastore"><p
class="title"><b>Example 2.3.
+ Example properties for JDataStore
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: com.borland.datastore.jdbc.DataStoreDriver
+openjpa.ConnectionURL: jdbc:borland:dslocal:db-jdatastore.jds;create=true
+</pre>
+ </div></div><br class="example-break">
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="dbsupport_interbase.html">Prev</a> </td><td width="20%"
align="center"><a accesskey="u" href="supported_databases.html">Up</a></td><td
width="40%" align="right"> <a accesskey="n"
href="dbsupport_db2.html">Next</a></td></tr><tr><td width="40%" align="left"
valign="top">6.
+ Borland Interbase
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 8.
+ IBM DB2
+ </td></tr></table></div></body></html>
\ No newline at end of file
Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_mysql.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_mysql.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_mysql.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,101 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>19. MySQL</title><base href="display"><link rel="stylesheet"
type="text/css" href="css/docbook.css"><meta name="generator" content="DocBook
XSL Stylesheets V1.79.1"><link rel="home" href="manual.html" title="Apache
OpenJPA 2.4 User's Guide"><link rel="up" href="supported_databases.html"
title="Appendix 2. Supported Databases"><link rel="prev"
href="dbsupport_foxpro.html" title="18. Microsoft FoxPro"><link
rel="next" href="dbsupport_oracle.html" title="20. Oracle"></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">19.
+ MySQL
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="dbsupport_foxpro.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbsupport_oracle.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbsupport_mysql"><div class="titlepage"><div><div><h2
class="title" style="clear: both">19.
+ MySQL
+ </h2></div></div></div><div class="toc"><dl class="toc"><dt><span
class="section"><a
href="dbsupport_mysql.html#dbsupport_mysql_query_hints">19.1.
+ Using Query Hints with MySQL
+ </a></span></dt><dt><span class="section"><a
href="dbsupport_mysql.html#dbsupport_mysql_issues">19.2.
+ Known issues with MySQL
+ </a></span></dt></dl></div>
+
+ <div class="example" id="example_props_mysql"><p
class="title"><b>Example 2.15.
+ Example properties for MySQL
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: com.mysql.jdbc.Driver
+openjpa.ConnectionURL: jdbc:mysql://SERVER_NAME/DB_NAME
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" id="dbsupport_mysql_query_hints"><div
class="titlepage"><div><div><h3 class="title">19.1.
+ Using Query Hints with MySQL
+ </h3></div></div></div>
+
+ <p>
+MySQL has support for "query hints", which are keywords embedded in
+SQL that provide some hint for how the query should be executed. These hints
are
+usually designed to provide suggestions to the MySQL query optimizer for how to
+efficiently perform a certain query, and aren't typically needed for any but
+the most intensive queries.
+OpenJPA supports hints to be placed between SELECT keyword and column list.
+ </p>
+ <div class="example" id="dbsupport_mysql_query_hints_ex"><p
class="title"><b>Example 2.16.
+ Using MySQL Hints
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+Query query = em.createQuery(...);
+query.setHint("openjpa.hint.MySQLSelectHint", "SQL_NO_CACHE");
+List results = query.getResultList();
+</pre>
+ </div></div><br class="example-break">
+ </div>
+ <div class="section" id="dbsupport_mysql_issues"><div
class="titlepage"><div><div><h3 class="title">19.2.
+ Known issues with MySQL
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist"
style="list-style-type: disc; "><li class="listitem">
+ <p>
+The default table types that MySQL uses do not support transactions, which will
+prevent OpenJPA from being able to roll back transactions. Use the
+<code class="literal">InnoDB</code> table type for any tables that OpenJPA
will access.
+ </p>
+ </li><li class="listitem">
+ <p>
+MySQL does not support sub-selects in versions prior to 4.1, so
+some operations (such as the <code class="function">isEmpty()</code> method in
a
+query) will fail due to this.
+ </p>
+ </li><li class="listitem">
+ <p>
+Rollback due to database error or optimistic lock violation is not supported
+unless the table type is one of the MySQL transactional types. Explicit calls
to
+<code class="function">rollback()</code> before a transaction has been
committed,
+however, are always supported.
+ </p>
+ </li><li class="listitem">
+ <p>
+Floats and doubles may lose precision when stored in some datastores.
+ </p>
+ </li><li class="listitem">
+ <p>
+When storing a field of type <code
class="classname">java.math.BigDecimal</code>, some
+datastores will add extraneous trailing 0 characters, causing an equality
+mismatch between the field that is stored and the field that is retrieved.
+ </p>
+ </li><li class="listitem">
+ <p>
+When using large result sets with MySQL there are a number of documented
limitations.
+Please read the section titled "ResultSet" in the "MySQL JDBC API
Implementation Notes".
+The net effect of these limitations is that you will have to read all of the
rows of a
+result set (or close the connection) before you can issue any other queries on
+the connection, or an exception will be thrown. Setting openjpa.FetchBatchSize
+to any value greater than zero will enable streaming result sets.
+ </p>
+ </li><li class="listitem">
+ <p>
+The use of <a class="link"
href="ref_guide_mapping_jpa.html#ref_guide_streamsupport" title="7.11.
LOB Streaming">LOB streaming</a> is limited.
+When reading LOB data from the database, the MySQL JDBC driver will actually
+load all the data into memory at the same time.
+ </p>
+ </li></ul></div>
+ </div>
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="dbsupport_foxpro.html">Prev</a> </td><td width="20%"
align="center"><a accesskey="u" href="supported_databases.html">Up</a></td><td
width="40%" align="right"> <a accesskey="n"
href="dbsupport_oracle.html">Next</a></td></tr><tr><td width="40%" align="left"
valign="top">18.
+ Microsoft FoxPro
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 20.
+ Oracle
+ </td></tr></table></div></body></html>
\ No newline at end of file
Added:
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_oracle.html
==============================================================================
---
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_oracle.html
(added)
+++
websites/production/openjpa/content/builds/2.4.2/apache-openjpa/docs/dbsupport_oracle.html
Fri Jan 6 19:19:20 2017
@@ -0,0 +1,142 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>20. Oracle</title><base href="display"><link rel="stylesheet"
type="text/css" href="css/docbook.css"><meta name="generator" content="DocBook
XSL Stylesheets V1.79.1"><link rel="home" href="manual.html" title="Apache
OpenJPA 2.4 User's Guide"><link rel="up" href="supported_databases.html"
title="Appendix 2. Supported Databases"><link rel="prev"
href="dbsupport_mysql.html" title="19. MySQL"><link rel="next"
href="dbsupport_pointbase.html" title="21. Pointbase"></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">20.
+ Oracle
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p"
href="dbsupport_mysql.html">Prev</a> </td><th width="60%"
align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n"
href="dbsupport_pointbase.html">Next</a></td></tr></table><hr></div><div
class="section" id="dbsupport_oracle"><div class="titlepage"><div><div><h2
class="title" style="clear: both">20.
+ Oracle
+ </h2></div></div></div><div class="toc"><dl class="toc"><dt><span
class="section"><a
href="dbsupport_oracle.html#dbsupport_oracle_query_hints">20.1.
+ Using Query Hints with Oracle
+ </a></span></dt><dt><span class="section"><a
href="dbsupport_oracle.html#dbsupport_oracle_issues">20.2.
+ Known issues with Oracle
+ </a></span></dt></dl></div>
+
+ <div class="example" id="example_props_oracle"><p
class="title"><b>Example 2.17.
+ Example properties for Oracle
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: oracle.jdbc.driver.OracleDriver
+openjpa.ConnectionURL: jdbc:oracle:thin:@SERVER_NAME:1521:DB_NAME
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" id="dbsupport_oracle_query_hints"><div
class="titlepage"><div><div><h3 class="title">20.1.
+ Using Query Hints with Oracle
+ </h3></div></div></div>
+
+ <p>
+Oracle has support for "query hints", which are formatted comments embedded in
+SQL that provide some hint for how the query should be executed. These hints
are
+usually designed to provide suggestions to the Oracle query optimizer for how
to
+efficiently perform a certain query, and aren't typically needed for any but
+the most intensive queries.
+ </p>
+ <div class="example" id="dbsupport_oracle_query_hints_ex"><p
class="title"><b>Example 2.18.
+ Using Oracle Hints
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+Query query = em.createQuery(...);
+query.setHint("openjpa.hint.OracleSelectHint", "/*+ first_rows(100) */");
+List results = query.getResultList();
+</pre>
+ </div></div><br class="example-break">
+ </div>
+ <div class="section" id="dbsupport_oracle_issues"><div
class="titlepage"><div><div><h3 class="title">20.2.
+ Known issues with Oracle
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist"
style="list-style-type: disc; "><li class="listitem">
+ <p>
+The Oracle JDBC driver has significant differences between different versions.
+It is important to use the officially supported version of the drivers
+(10.2.0.1.0/11.2.0.x.0), which is backward compatible with previous versions
of the Oracle
+server. It can be downloaded from
+<a class="ulink"
href="http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html";
target="_top">
+http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html</a>.
+ </p>
+ </li><li class="listitem">
+ <p>
+Empty string/char values are stored as NULL.
+ </p>
+ </li><li class="listitem">
+ <p>
+Oracle corp's JDBC driver for Oracle has only limited support for batch
updates.
+The result for OpenJPA is that batching of some statements may fail and in
some cases,
+the exact object that failed an optimistic lock check cannot be determined.
OpenJPA will
+throw an <code class="classname">OptimisticException</code> with more failed
objects than actually
+failed. This situation may be resolved by disabling statement batching by
setting the
+batchLimit value to zero or by using a more recent Oracle JDBC Driver
(11.2.0.1) with
+batch support improvements. Attempting to resolve the issue with a more
current driver
+is recommended since disabling statement batching can result in a decrease in
performance.
+ </p><div class="example"
id="dbsupport_oracle_disable_batch_updates"><p
class="title"><b>Example 2.19.
+ Property to disable statement batching for Oracle
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.jdbc.DBDictionary: oracle(batchLimit=0)
+</pre>
+ </div></div><p><br class="example-break">
+ </p>
+ </li><li class="listitem">
+ <p>
+Oracle cannot store numbers with more than 38 digits in numeric columns.
+ </p>
+ </li><li class="listitem">
+ <p>
+Floats and doubles may lose precision when stored.
+ </p>
+ </li><li class="listitem">
+ <p>
+CLOB columns cannot be used in queries.
+ </p>
+ </li><li class="listitem">
+ <p>
+The use of LOBs with persistent attributes of a streaming data type (ex.
+<code class="literal">java.io.InputStream</code> or <code
class="literal">java.io.Reader</code>) may
+require the same connection to be used over the life of the transaction or
+entity manager. If the same connection is not used for persistent operations
+a <code class="literal">java.io.IOException</code> with message <code
class="literal">Closed Connection
+</code> may result. The OpenJPA property <code
class="literal">openjpa.ConnectionRetainMode</code>
+can be used to control how OpenJPA uses datastore connections. See
+<a class="xref" href="ref_guide_dbsetup_retain.html" title="8.
Configuring the Use of JDBC Connections">Section 8, “
+ Configuring the Use of JDBC Connections
+ ”</a> for details.
+ </p><div class="example"
id="dbsupport_oracle_retain_connection"><p
class="title"><b>Example 2.20.
+ Property to retain connection over the lifetime of the
entity manager
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionRetainMode: always
+</pre>
+ </div></div><p><br class="example-break">
+ </p>
+ </li><li class="listitem">
+ <p>
+Mapping persistent attributes to <a class="link"
href="ref_guide_mapping_jpa.html#ref_guide_xmlmapping" title="7.10. XML
Column Mapping">XML columns</a> requires
+a JDBC 4 compliant driver if XML strings are longer than 4000 bytes, as
counted in database.
+Otherwise an <code class="literal">ORA-01461: can bind a LONG value only for
insert into a LONG column</code>
+error may result.
+ </p>
+ </li><li class="listitem">
+ <p>
+If Oracle dictionary property <code class="literal">MaxEmbeddedBlobSize</code>
or
+<code class="literal">MaxEmbeddedClobSize</code> is set to some limit (i.e.
not -1) and embedded collection
+with BLOB/CLOB attribute is used, a
+<code class="literal">"org.apache.openjpa.persistence.ArgumentException:
+"x.y.z.EmbedOwner.embedCollection<element:class x.y.z.EmbedValue>"
+is mapped as embedded, but embedded field
+"x.y.z.EmbedOwner.embedCollection.x.y.z.EmbedValue.blob" is not embeddable.
+Embedded element/key/value types are limited to simple fields and direct
relations to other
+persistent types"</code> error may result. To overcome this limitation, either
use JDBC driver
+11.2.0.x.0 (or later version) or set both <code
class="literal">MaxEmbeddedBlobSize</code> and
+<code class="literal">MaxEmbeddedClobSize</code> properties to -1.
+ </p>
+ </li></ul></div>
+ </div>
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation
footer"><tr><td width="40%" align="left"><a accesskey="p"
href="dbsupport_mysql.html">Prev</a> </td><td width="20%"
align="center"><a accesskey="u" href="supported_databases.html">Up</a></td><td
width="40%" align="right"> <a accesskey="n"
href="dbsupport_pointbase.html">Next</a></td></tr><tr><td width="40%"
align="left" valign="top">19.
+ MySQL
+ </td><td width="20%" align="center"><a accesskey="h"
href="manual.html">Home</a></td><td width="40%" align="right"
valign="top"> 21.
+ Pointbase
+ </td></tr></table></div></body></html>
\ No newline at end of file
