camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From NES <nes...@gmail.com>
Subject Re: Use same db connection
Date Tue, 29 Mar 2016 12:36:57 GMT
I resolve this problem by using Transactional Client.

<route>
    <from uri="direct:foo" />
    <transacted />
    <to uri="sql:INSERT INTO TEST_TBL (INSERT_DATE)
VALUES(NOW())?dataSource=dataSource" />
    <to uri="sql:SELECT LAST_INSERT_ID()?dataSource=dataSource" />
</route>

This route runs as expected so far.

if you tell me more efficient solution, I would appreciate.



--
View this message in context: http://camel.465427.n5.nabble.com/Use-same-db-connection-tp5779853p5779949.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Mime
View raw message