[jira] Resolved: (OPENJPA-1333) Oracle driver returns incorrect update count on batched insert

["Jeremy Bauer (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OPENJPA-1333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jeremy Bauer resolved OPENJPA-1333.
-----------------------------------

       Resolution: Fixed
    Fix Version/s: 2.0.0-M3

This problem can be corrected by:

- Disabling statement batching by setting the batchLimit to zero.  This has performance implications but produces the correct behavior on the version 10 JDBC driver.  Statement batching can be disabled by setting the following persistence property:

<property name="openjpa.jdbc.DBDictionary" value="batchLimit=0"/>

or

- Using version 11.2.0.1 of the Oracle JDBC driver.  The issue is corrected in this level of JDBC driver.

> Oracle driver returns incorrect update count on batched insert
> --------------------------------------------------------------
>
>                 Key: OPENJPA-1333
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1333
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc
>    Affects Versions: 2.0.0-M3
>         Environment: Oracle 10g Server.  Oracle 10.2.0.4 JDBC driver.
>            Reporter: Jeremy Bauer
>            Assignee: Jeremy Bauer
>             Fix For: 2.0.0-M3
>
>
> The org.apache.openjpa.persistence.kernel.TestProxies2 jUnit test fails with an OptimisticLockException when using the 10.2.0.4 Oracle JDBC driver.  The source of the failure is that one of the batched insert operations is returning an update count that is less than expected.  There is are no SQL exception or SQL warnings.

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