You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openjpa.apache.org by kw...@apache.org on 2014/05/15 00:22:26 UTC
svn commit: r908837 [2/37] -
/websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_db2.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_db2.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_db2.html Wed May 14 22:22:23 2014
@@ -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-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 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" title="8. IBM DB2"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_db2">8.
+ IBM DB2
+ </h2></div></div></div><div class="toc"><dl><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"><a name="example_props_db2"></a><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" title="8.1. Known issues with DB2"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_db2_issues">8.1.
+ Known issues with DB2
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist" 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
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_db2.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_derby.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_derby.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_derby.html Wed May 14 22:22:23 2014
@@ -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-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 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" title="5. Apache Derby"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_derby">5.
+ Apache Derby
+ </h2></div></div></div>
+
+ <div class="example"><a name="example_props_derby"></a><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
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_derby.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_empress.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_empress.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_empress.html Wed May 14 22:22:23 2014
@@ -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-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 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" title="9. Empress"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_empress">9.
+ Empress
+ </h2></div></div></div><div class="toc"><dl><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"><a name="example_props_empress"></a><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" title="9.1. Known issues with Empress"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_empress_issues">9.1.
+ Known issues with Empress
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist" 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
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_empress.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_firebird.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_firebird.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_firebird.html Wed May 14 22:22:23 2014
@@ -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-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 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" title="12. Firebird"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_firebird">12.
+ Firebird
+ </h2></div></div></div><div class="toc"><dl><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"><a name="example_props_firebird"></a><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" title="12.1. Known issues with Firebird"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_firebird_issues">12.1.
+ Known issues with Firebird
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist" 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
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_firebird.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_foxpro.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_foxpro.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_foxpro.html Wed May 14 22:22:23 2014
@@ -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-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 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" title="18. Microsoft FoxPro"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_foxpro">18.
+ Microsoft FoxPro
+ </h2></div></div></div><div class="toc"><dl><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"><a name="example_props_foxpro"></a><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" title="18.1. Known issues with Microsoft FoxPro"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_foxpro_issues">18.1.
+ Known issues with Microsoft FoxPro
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist" 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
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_foxpro.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_h2.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_h2.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_h2.html Wed May 14 22:22:23 2014
@@ -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-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 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" title="10. H2 Database Engine"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_h2">10.
+ H2 Database Engine
+ </h2></div></div></div><div class="toc"><dl><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"><a name="example_props_h2"></a><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" title="10.1. Known issues with H2 Database Engine"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_h2_issues">10.1.
+ Known issues with H2 Database Engine
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist" 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
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_h2.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_hypersonic.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_hypersonic.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_hypersonic.html Wed May 14 22:22:23 2014
@@ -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-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 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" title="11. Hypersonic"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_hypersonic">11.
+ Hypersonic
+ </h2></div></div></div><div class="toc"><dl><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"><a name="example_props_hypersonic"></a><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" title="11.1. Known issues with Hypersonic"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_hypersonic_issues">11.1.
+ Known issues with Hypersonic
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist" 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
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_hypersonic.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_informix.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_informix.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_informix.html Wed May 14 22:22:23 2014
@@ -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-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 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" title="13. Informix"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_informix">13.
+ Informix
+ </h2></div></div></div><div class="toc"><dl><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"><a name="example_props_informix"></a><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" title="13.1. Known issues with Informix"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_informix_issues">13.1.
+ Known issues with Informix
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist" 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
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_informix.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_ingres.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_ingres.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_ingres.html Wed May 14 22:22:23 2014
@@ -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-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 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" title="14. Ingres Database"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_ingres">14.
+ Ingres Database
+ </h2></div></div></div><div class="toc"><dl><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"><a name="example_props_ingres"></a><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" title="14.1. Known issues with Ingres"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_ingres_issues">14.1.
+ Known issues with Ingres
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist" 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
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_ingres.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_interbase.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_interbase.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_interbase.html Wed May 14 22:22:23 2014
@@ -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-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 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" title="6. Borland Interbase"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_interbase">6.
+ Borland Interbase
+ </h2></div></div></div><div class="toc"><dl><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"><a name="example_props_interbase"></a><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" title="6.1. Known issues with Interbase"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_interbase_issues">6.1.
+ Known issues with Interbase
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist" 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
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_interbase.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_intersystems_cache.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_intersystems_cache.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_intersystems_cache.html Wed May 14 22:22:23 2014
@@ -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-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 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" title="15. InterSystems Cache"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_intersystems_cache">15.
+ InterSystems Cache
+ </h2></div></div></div><div class="toc"><dl><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"><a name="example_props_intersystems_cache"></a><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" title="15.1. Known issues with InterSystems Cache"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_intersystems_cache_issues">15.1.
+ Known issues with InterSystems Cache
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist" 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
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_intersystems_cache.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_jdatastore.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_jdatastore.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_jdatastore.html Wed May 14 22:22:23 2014
@@ -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-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 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" title="7. JDataStore"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_jdatastore">7.
+ JDataStore
+ </h2></div></div></div>
+
+ <div class="example"><a name="example_props_jdatastore"></a><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
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_jdatastore.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_mysql.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_mysql.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_mysql.html Wed May 14 22:22:23 2014
@@ -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-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 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" title="19. MySQL"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_mysql">19.
+ MySQL
+ </h2></div></div></div><div class="toc"><dl><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"><a name="example_props_mysql"></a><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" title="19.1. Using Query Hints with MySQL"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_mysql_query_hints">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"><a name="dbsupport_mysql_query_hints_ex"></a><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" title="19.2. Known issues with MySQL"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_mysql_issues">19.2.
+ Known issues with MySQL
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist" 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
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_mysql.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_oracle.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_oracle.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_oracle.html Wed May 14 22:22:23 2014
@@ -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-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 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" title="20. Oracle"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_oracle">20.
+ Oracle
+ </h2></div></div></div><div class="toc"><dl><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"><a name="example_props_oracle"></a><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" title="20.1. Using Query Hints with Oracle"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_oracle_query_hints">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"><a name="dbsupport_oracle_query_hints_ex"></a><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" title="20.2. Known issues with Oracle"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_oracle_issues">20.2.
+ Known issues with Oracle
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist" 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"><a name="dbsupport_oracle_disable_batch_updates"></a><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"><a name="dbsupport_oracle_retain_connection"></a><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
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_oracle.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_pointbase.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_pointbase.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_pointbase.html Wed May 14 22:22:23 2014
@@ -0,0 +1,39 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>21. Pointbase</title><base href="display"><link rel="stylesheet" type="text/css" href="css/docbook.css"><meta name="generator" content="DocBook XSL-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 User's Guide"><link rel="up" href="supported_databases.html" title="Appendix 2. Supported Databases"><link rel="prev" href="dbsupport_oracle.html" title="20. Oracle"><link rel="next" href="dbsupport_postgresql.html" title="22. PostgreSQL"></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">21.
+ Pointbase
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p" href="dbsupport_oracle.html">Prev</a> </td><th width="60%" align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n" href="dbsupport_postgresql.html">Next</a></td></tr></table><hr></div><div class="section" title="21. Pointbase"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_pointbase">21.
+ Pointbase
+ </h2></div></div></div><div class="toc"><dl><dt><span class="section"><a href="dbsupport_pointbase.html#dbsupport_pointbase_issues">21.1.
+ Known issues with Pointbase
+ </a></span></dt></dl></div>
+
+ <div class="example"><a name="example_props_pointbase"></a><p class="title"><b>Example 2.21.
+ Example properties for Pointbase
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: com.pointbase.jdbc.jdbcUniversalDriver
+openjpa.ConnectionURL: \
+ jdbc:pointbase:DB_NAME,database.home=pointbasedb,create=true,cache.size=10000,database.pagesize=30720
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" title="21.1. Known issues with Pointbase"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_pointbase_issues">21.1.
+ Known issues with Pointbase
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist" type="disc"><li class="listitem">
+ <p>
+Fields of type BLOB and CLOB are limited to 1M. Set the <code class="literal">BlobTypeName
+</code> and/or <code class="literal">ClobTypeName</code> properties of the
+<code class="literal">openjpa.jdbc.DBDictionary</code> setting to override.
+ </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_oracle.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_postgresql.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">20.
+ Oracle
+ </td><td width="20%" align="center"><a accesskey="h" href="manual.html">Home</a></td><td width="40%" align="right" valign="top"> 22.
+ PostgreSQL
+ </td></tr></table></div></body></html>
\ No newline at end of file
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_pointbase.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_postgresql.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_postgresql.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_postgresql.html Wed May 14 22:22:23 2014
@@ -0,0 +1,50 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>22. PostgreSQL</title><base href="display"><link rel="stylesheet" type="text/css" href="css/docbook.css"><meta name="generator" content="DocBook XSL-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 User's Guide"><link rel="up" href="supported_databases.html" title="Appendix 2. Supported Databases"><link rel="prev" href="dbsupport_pointbase.html" title="21. Pointbase"><link rel="next" href="dbsupport_soliddb.html" title="23. IBM solidDB"></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">22.
+ PostgreSQL
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p" href="dbsupport_pointbase.html">Prev</a> </td><th width="60%" align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n" href="dbsupport_soliddb.html">Next</a></td></tr></table><hr></div><div class="section" title="22. PostgreSQL"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_postgresql">22.
+ PostgreSQL
+ </h2></div></div></div><div class="toc"><dl><dt><span class="section"><a href="dbsupport_postgresql.html#dbsupport_postgresql_issues">22.1.
+ Known issues with PostgreSQL
+ </a></span></dt></dl></div>
+
+ <div class="example"><a name="example_props_postgresql"></a><p class="title"><b>Example 2.22.
+ Example properties for PostgreSQL
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: org.postgresql.Driver
+openjpa.ConnectionURL: jdbc:postgresql://SERVER_NAME:5432/DB_NAME
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" title="22.1. Known issues with PostgreSQL"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_postgresql_issues">22.1.
+ Known issues with PostgreSQL
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist" type="disc"><li class="listitem">
+ <p>
+Floats and doubles may lose precision when stored.
+ </p>
+ </li><li class="listitem">
+ <p>
+PostgreSQL cannot store very low and very high dates.
+ </p>
+ </li><li class="listitem">
+ <p>
+Empty string/char values are stored as NULL.
+ </p>
+ </li><li class="listitem">
+ <p>
+Persistent fields of type <code class="classname">java.io.Reader</code> are not
+supported when using
+<a class="link" href="ref_guide_mapping_jpa.html#ref_guide_streamsupport" title="7.11. LOB Streaming">LOB streaming</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_pointbase.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_soliddb.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">21.
+ Pointbase
+ </td><td width="20%" align="center"><a accesskey="h" href="manual.html">Home</a></td><td width="40%" align="right" valign="top"> 23.
+ IBM solidDB
+ </td></tr></table></div></body></html>
\ No newline at end of file
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_postgresql.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_soliddb.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_soliddb.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_soliddb.html Wed May 14 22:22:23 2014
@@ -0,0 +1,70 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>23. IBM solidDB</title><base href="display"><link rel="stylesheet" type="text/css" href="css/docbook.css"><meta name="generator" content="DocBook XSL-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 User's Guide"><link rel="up" href="supported_databases.html" title="Appendix 2. Supported Databases"><link rel="prev" href="dbsupport_postgresql.html" title="22. PostgreSQL"><link rel="next" href="dbsupport_sybase.html" title="24. Sybase Adaptive 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">23.
+ IBM solidDB
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p" href="dbsupport_postgresql.html">Prev</a> </td><th width="60%" align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n" href="dbsupport_sybase.html">Next</a></td></tr></table><hr></div><div class="section" title="23. IBM solidDB"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_soliddb">23.
+ IBM solidDB
+ </h2></div></div></div><div class="toc"><dl><dt><span class="section"><a href="dbsupport_soliddb.html#dbsupport_soliddb_table_types">23.1.
+ M-type tables vs. D-type tables
+ </a></span></dt><dt><span class="section"><a href="dbsupport_soliddb.html#dbsupport_soliddb_concurrency_control">23.2.
+ Concurrency control mechanism
+ </a></span></dt></dl></div>
+
+ <div class="example"><a name="example_props_soliddb"></a><p class="title"><b>Example 2.23.
+ Example properties for IBM solidDB
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: solid.jdbc.SolidDriver
+openjpa.ConnectionURL: jdbc:solid://localhost:2315/dba/dba
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" title="23.1. M-type tables vs. D-type tables"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_soliddb_table_types">23.1.
+ M-type tables vs. D-type tables
+ </h3></div></div></div>
+
+ <p>
+IBM solidDB supports two types of tables: in-memory tables (M-tables) and
+on-disk tables (D-tables). Since cursor hold over commit can not apply to M-tables
+(which will cause SOLID Table Error 13187: The cursor cannot continue
+accessing M-tables after the transaction has committed or aborted.
+The statement must be re-executed), the default OpenJPA tables are D-tables.
+One can set the whole server to disk-based mode by adding
+ [General]
+ DefaultStoreIsMemory=no
+in solid.ini. The table types can also be determined by setting OpenJPA property
+"openjpa.jdbc.DBDictionary" with value "storeIsMemory=true" or "storeIsMemory=false"
+in the persistence.xml. The "STORE MEMORY" and "STORE DISK" will be appended to
+the create table DDL, respectively.
+ </p>
+ </div>
+ <div class="section" title="23.2. Concurrency control mechanism"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_soliddb_concurrency_control">23.2.
+ Concurrency control mechanism
+ </h3></div></div></div>
+
+ <p>
+The default concurrency control mechanism depends on the table type:
+Disk-based tables (D-tables) are by default optimistic.
+Main-memory tables (M-tables) are always pessimistic.
+Since OpenJPA applications expects lock waits as usually is done with
+normal pessimistic databases, the server should be set to the pessimistic mode.
+The optimistic mode is about not waiting for the locks at all. That increases
+concurrency but requires more programming. The pessimistic mode with the
+READ COMMITTED isolation level (default) should get as much concurrency as one
+might need. The pessimistic locking mode can be set in solid.ini:
+ [General]
+ Pessimistic=yes
+One can override the locking mode on the per table base by setting OpenJPA property
+"openjpa.jdbc.DBDictionary" to value "lockingMode=PESSIMISTIC" in the persistence.xml.
+An extra SQL will be generated along with CREATE TABLE DDL:
+ALTER TABLE EX_POBJECT SET PESSIMISTIC.
+The possible values for lockingMode is OPTIMISTIC/PESSIMISTIC.
+ </p>
+ </div>
+ </div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="dbsupport_postgresql.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_sybase.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">22.
+ PostgreSQL
+ </td><td width="20%" align="center"><a accesskey="h" href="manual.html">Home</a></td><td width="40%" align="right" valign="top"> 24.
+ Sybase Adaptive Server
+ </td></tr></table></div></body></html>
\ No newline at end of file
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_soliddb.html
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_sqlserver.html
==============================================================================
--- websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_sqlserver.html (added)
+++ websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_sqlserver.html Wed May 14 22:22:23 2014
@@ -0,0 +1,99 @@
+<html><head>
+ <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+ <title>17. Microsoft SQL Server</title><base href="display"><link rel="stylesheet" type="text/css" href="css/docbook.css"><meta name="generator" content="DocBook XSL-NS Stylesheets V1.76.1"><link rel="home" href="manual.html" title="Apache OpenJPA 2.3 User's Guide"><link rel="up" href="supported_databases.html" title="Appendix 2. Supported Databases"><link rel="prev" href="dbsupport_access.html" title="16. Microsoft Access"><link rel="next" href="dbsupport_foxpro.html" title="18. Microsoft FoxPro"></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">17.
+ Microsoft SQL Server
+ </th></tr><tr><td width="20%" align="left"><a accesskey="p" href="dbsupport_access.html">Prev</a> </td><th width="60%" align="center">Appendix 2.
+ Supported Databases
+ </th><td width="20%" align="right"> <a accesskey="n" href="dbsupport_foxpro.html">Next</a></td></tr></table><hr></div><div class="section" title="17. Microsoft SQL Server"><div class="titlepage"><div><div><h2 class="title" style="clear: both" id="dbsupport_sqlserver">17.
+ Microsoft SQL Server
+ </h2></div></div></div><div class="toc"><dl><dt><span class="section"><a href="dbsupport_sqlserver.html#dbsupport_sqlserver_issues">17.1.
+ Known issues with SQL Server
+ </a></span></dt></dl></div>
+
+ <div class="example"><a name="example_props_sqlserver"></a><p class="title"><b>Example 2.13.
+ Example properties for Microsoft SQL Server
+ </b></p><div class="example-contents">
+
+<pre class="programlisting">
+openjpa.ConnectionDriverName: com.microsoft.sqlserver.jdbc.SQLServerDriver
+openjpa.ConnectionURL: \
+ jdbc:sqlserver://SERVER_NAME:1433;DatabaseName=DB_NAME;selectMethod=cursor;sendStringParametersAsUnicode=false
+</pre>
+ </div></div><br class="example-break">
+ <div class="section" title="17.1. Known issues with SQL Server"><div class="titlepage"><div><div><h3 class="title" id="dbsupport_sqlserver_issues">17.1.
+ Known issues with SQL Server
+ </h3></div></div></div>
+
+ <div class="itemizedlist"><ul class="itemizedlist" type="disc"><li class="listitem">
+ <p>
+When using a Microsoft SQL Server JDBC Driver v1.2 or earlier, the
+ConnectionURL must always contain the <code class="literal">selectMethod=cursor
+</code> string, which is necessary for the driver to properly
+support large result sets.
+ </p>
+ </li><li class="listitem">
+ <p>
+When using a Microsoft SQL Server JDBC Driver v1.2 or earlier, the
+JDBC driver has bugs that manifest themselves when prepared statements
+are pooled. Please disable prepared statement pooling by including the
+<code class="literal">MaxCachedStatements=0</code> configuration property
+in your org.apache.openjpa.ConnectionFactoryProperties.
+ </p>
+ </li><li class="listitem">
+ <p>
+SQL Server date fields are accurate only to the nearest 3 milliseconds,
+possibly resulting in precision loss in stored dates.
+ </p>
+ </li><li class="listitem">
+ <p>
+Adding <code class="literal">sendStringParametersAsUnicode=false</code> to the
+ConnectionURL may significantly increase performance.
+ </p>
+ </li><li class="listitem">
+ <p>
+The Microsoft SQL Server driver only emulates batch updates. The DataDirect JDBC
+driver has true support for batch updates, and may result in a significant
+performance gain.
+ </p>
+ </li><li class="listitem">
+ <p>
+Floats and doubles may lose precision when stored.
+ </p>
+ </li><li class="listitem">
+ <p>
+<code class="literal">TEXT</code> columns cannot be used in queries.
+ </p>
+ </li><li class="listitem">
+ <p>
+When using a SQL Server instance that has been configured to be case-sensitive
+in schema names, you need to set the "schemaCase=preserve" parameter in the
+<a class="link" href="ref_guide_conf_jdbc.html#openjpa.jdbc.DBDictionary" title="6.2. openjpa.jdbc.DBDictionary">openjpa.jdbc.DBDictionary</a>
+property.
+ </p>
+ </li><li class="listitem">
+ <p>
+SQL Server 2005 does not support native sequences. If you would like to use
+generated values with SQL Server you should use GenerationType.IDENTITY,
+GenerationType.TABLE, or GenerationType.AUTO.
+ </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 Microsoft SQL Server driver will
+actually load all the data into memory at the same time.
+ </p>
+ </li><li class="listitem">
+ <p>
+The SQL Server 2008 DATETIME2 data type supports 7 digits sub-second precision.
+When DataDirect JDBC driver is used with SQL Server 2008, setTimestamp method call with
+a java.sql.Timestamp argument of more than 3 digits precision in a prepared statement
+will result in truncation. This may cause loss of data precision or
+optimistic lock exception if an entity uses Timestamp type as version field.
+ </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_access.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_foxpro.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">16.
+ Microsoft Access
+ </td><td width="20%" align="center"><a accesskey="h" href="manual.html">Home</a></td><td width="40%" align="right" valign="top"> 18.
+ Microsoft FoxPro
+ </td></tr></table></div></body></html>
\ No newline at end of file
Propchange: websites/production/openjpa/content/builds/2.3.0/apache-openjpa/docs/dbsupport_sqlserver.html
------------------------------------------------------------------------------
svn:mime-type = text/plain