openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeremy Bauer (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-743) OptimisticLockException persisting collection containing Lob fields with Oracle
Date Fri, 10 Oct 2008 13:53:44 GMT
OptimisticLockException persisting collection containing Lob fields with Oracle
-------------------------------------------------------------------------------

                 Key: OPENJPA-743
                 URL: https://issues.apache.org/jira/browse/OPENJPA-743
             Project: OpenJPA
          Issue Type: Bug
          Components: jdbc
    Affects Versions: 1.2.0
         Environment: OpenJPA 1.2.0, Oracle 10g ojdbc14.jar, version 10.2.0.1.0
            Reporter: Jeremy Bauer
            Assignee: Jeremy Bauer


Persisting an object graph with an entity containing a persistent collection of objects which
contain a Lob field may fail on Oracle if statement batching is enabled.  The failure will
depend on the order of operations, which can be somewhat intermittent.  If more than one insert
into the table containing the Lob column are batched together and there is a mix of null and
non-null data value parameters, the batch insert operation will fail with an OptimisticLockException.
 

A simple (but not especially performance friendly) way to work around the problem is to disable
statement batching via: 
<property name="openjpa.jdbc.DBDictionary" value="oracle(batchLimit=0)"/>  Otherwise,
if possible, make sure all Lob fields are set to a non-null value.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message