[
https://issues.apache.org/jira/browse/CAMEL-21845?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17939989#comment-17939989
]
Benjamin Graf commented on CAMEL-21845:
---------------------------------------
Hi [~davsclaus], how is this feature meant to work with XA transactions. I need
to set batchAutoCommitDisabled to false to work, which is semantically odd.
Otherwise it tries to commit in between transaction causing an exception.
> camel-sql - Improve performance of batch inserts
> ------------------------------------------------
>
> Key: CAMEL-21845
> URL: https://issues.apache.org/jira/browse/CAMEL-21845
> Project: Camel
> Issue Type: Improvement
> Components: camel-sql
> Affects Versions: 4.10.0
> Reporter: Claus Ibsen
> Assignee: Claus Ibsen
> Priority: Major
> Fix For: 4.10.2, 4.11.0
>
>
> We can make this faster by make the entire executeBatch done via auto commit
> turned off, and manually commit at end of batch.
> We can make some option to turn this on|off, as it can dependt a bit on JDBC
> driver and database how that works.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
