Hi,
I have created a transactional route in camel where I use camel-jdbc
component but the data are not rollbacked from DB when an error
occurs. Is there something wrong in my config ?
Here is the config
http://www.springframework.org/schema/beans";
xmlns:xsi="http://www.w3.org/2001/XMLS
Hi Charles,
You route is a bit interesting, you just throw the exception after the
exchange is sent to the camel-jdbc endpoint.
Can you tell me why did you do that ?
Willem
On 3/22/11 11:59 PM, Charles Moulliard wrote:
Hi,
I have created a transactional route in camel where I use camel-jdbc
I did that to simulate an error and check if the rollback will occur.
REMARK : If I use the same camel routes but use SQL component instead of
JDBC, then it works !!!
On 23/03/11 04:59, Willem Jiang wrote:
Hi Charles,
You route is a bit interesting, you just throw the exception after the
ex
Hi Charles,
I just went through the code of camel-jdbc and camel-sql.
camel-sql is use the JdbcTemplate which can interact with the Spring
transaction manage rightly.
camel-jdbc just create a statment object base on the data source, that
could explain why the rollback doesn't work for you.
Wi
Hi Willem,
You confirm what I was suspected --> camel-jdbc is not a transactional
component.
Regards,
Charles
On Wed, Mar 23, 2011 at 8:22 AM, Willem Jiang wrote:
> Hi Charles,
>
> I just went through the code of camel-jdbc and camel-sql.
> camel-sql is use the JdbcTemplate which can interac
Want we let it as it is? Or should we raise a JIRA for it and fix it?
I would prefer to raise a JIRA for it...
Christian
On Wed, Mar 23, 2011 at 8:25 AM, Charles Moulliard wrote:
> Hi Willem,
>
> You confirm what I was suspected --> camel-jdbc is not a transactional
> component.
>
> Regards,
>
>
Hi Christian,
Your are right, we should raise a ticket to decide what to do :
improve the component or update the wiki page to warn users.
BTW, If we decided to improve the component, than a decision should be
take about merging jdbc and sql component to keep only one !
Regards,
Charles Moullia