[jira] [Comment Edited] (OAK-4027) Support batch updates in Oracle

["Tomek Rękawek (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OAK-4027?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15156849#comment-15156849 ] 

Tomek Rękawek edited comment on OAK-4027 at 2/22/16 12:39 PM:
--------------------------------------------------------------

Indeed, the [ojdbc6.jar in version 12.1.0.1|http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html] behaves correctly and passess the {{RDBOddity.batchUpdateResult()}} test from OAK-3938.


was (Author: tomek.rekawek):
Indeed, the ojdbc6.jar in version 12.1.0.1 behaves correctly and passess the {{RDBOddity.batchUpdateResult()}} test from OAK-3938.

> Support batch updates in Oracle
> -------------------------------
>
>                 Key: OAK-4027
>                 URL: https://issues.apache.org/jira/browse/OAK-4027
>             Project: Jackrabbit Oak
>          Issue Type: Improvement
>          Components: rdbmk
>            Reporter: Tomek Rękawek
>             Fix For: 1.6
>
>
> The batch updates introduced in OAK-2066 are disable for the Oracle, because of the OAK-3938. It seems that Oracle 12.1 and latter behave correctly:
> {quote}
> Starting from Oracle Database 12c Release 1 (12.1), the executeBatch method has been improved so that it returns an int array of size that is the same as the number of records in the batch and each item in the return array is the number of database table rows affected by the corresponding record of the batch. 
> {quote}
> ([source|https://docs.oracle.com/database/121/JJDBC/oraperf.htm#JJDBC28767])
> Please investigate this and re-enable batch updates on Oracle >= 12.1



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)