You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openjpa.apache.org by jr...@apache.org on 2009/10/02 18:20:01 UTC
svn commit: r821077 -
/openjpa/trunk/openjpa-project/src/doc/manual/supported_databases.xml
Author: jrbauer
Date: Fri Oct 2 16:20:01 2009
New Revision: 821077
URL: http://svn.apache.org/viewvc?rev=821077&view=rev
Log:
OPENJPA-1333 Updated db support docs with potential solutions for limited batch support of Oracle drivers.
Modified:
openjpa/trunk/openjpa-project/src/doc/manual/supported_databases.xml
Modified: openjpa/trunk/openjpa-project/src/doc/manual/supported_databases.xml
URL: http://svn.apache.org/viewvc/openjpa/trunk/openjpa-project/src/doc/manual/supported_databases.xml?rev=821077&r1=821076&r2=821077&view=diff
==============================================================================
--- openjpa/trunk/openjpa-project/src/doc/manual/supported_databases.xml (original)
+++ openjpa/trunk/openjpa-project/src/doc/manual/supported_databases.xml Fri Oct 2 16:20:01 2009
@@ -957,10 +957,21 @@
<listitem>
<para>
Oracle corp's JDBC driver for Oracle has only limited support for batch updates.
-The result for OpenJPA is that in some cases, the exact object that failed an
-optimistic lock check cannot be determined, and OpenJPA will throw an
-<classname>OptimisticVerificationException</classname> with more failed objects
-than actually failed.
+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 <classname>OptimisticException</classname> 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.
+ <example id="dbsupport_oracle_disable_batch_updates">
+ <title>
+ Property to disable statement batching for Oracle
+ </title>
+<programlisting>
+openjpa.jdbc.DBDictionary: oracle(batchLimit=0)
+</programlisting>
+ </example>
</para>
</listitem>
<listitem>