Have a look at [1].
from("direct:start")
.transacted("PROPAGATION_REQUIRED")
.to("sql:INSERT ...")
.to("sql:INSERT ...");
[1]
https://github.com/muellerc/camel-in-transaction/blob/master/src/test/java/org/apache/cmueller/camel/samples/camelone/jdbc/JdbcTransactionSampleTest.java
Best,
Christian
-----------------
Software Integration Specialist
Apache Member
V.P. Apache Camel | Apache Camel PMC Member | Apache Camel committer
Apache Incubator PMC Member
https://www.linkedin.com/pub/christian-mueller/11/551/642
On Mon, Dec 29, 2014 at 10:55 AM, fabrizio.spataro <
[email protected]> wrote:
> Hello,
>
> i would use sql component (http://camel.apache.org/sql-component.html)
> into
> a transactional scenario.
>
> For example:
>
> 0) begin
> 1) insert
> 2) insert
> 3) commit
>
> I am using mysql.
>
> What is the best strategy to do it using camel's component?
>
> Tnkx
>
>
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/SQL-COMPONENT-mysql-transaction-tp5761111.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>
