[
https://issues.apache.org/jira/browse/CAMEL-21845?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17939989#comment-17939989
]
Benjamin Graf edited comment on CAMEL-21845 at 4/1/25 9:21 AM:
---------------------------------------------------------------
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. Maybe
commit should first evaluate if autocommit was false from beginning?
was (Author: graben):
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)
