You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@camel.apache.org by Cecilio Alvarez <ce...@hotmail.com> on 2015/03/20 17:17:33 UTC
Camel transacted route from JMS to JDBC
Hello
I tried to create a transacted route, but after 7 retries the message is
discarded and if the process is killed the message is lost.
Setting the transacted parameter, the vm connector is repeatedly
starting/stopping. Why happens this?
<route id="SQLInsert">
<from uri="activemq:in.Q?transacted=true"/>
<transacted/>
<to uri="sql:insert into table values(:#${body})?dataSource=testDB"/>
</route>
Beans
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="testDB"/>
</bean>
<bean id="PROPAGATION_REQUIRED"
class="org.apache.camel.spring.spi.SpringTransactionPolicy">
<property name="transactionManager" ref="transactionManager"/>
<property name="propagationBehaviorName" value="PROPAGATION_REQUIRED"/>
</bean>
Is there a better way of doing this?
Any help will be appreciated.
Thanks!
--
View this message in context: http://camel.465427.n5.nabble.com/Camel-transacted-route-from-JMS-to-JDBC-tp5764486.html
Sent from the Camel - Users mailing list archive at Nabble.com.
Re: Camel transacted route from JMS to JDBC
Posted by Christian Müller <ch...@gmail.com>.
Your configuration is not correct. Have a look at
https://github.com/muellerc/camel-in-transaction
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 Fri, Mar 20, 2015 at 5:17 PM, Cecilio Alvarez <
cecilio.alvarez@hotmail.com> wrote:
> Hello
>
> I tried to create a transacted route, but after 7 retries the message is
> discarded and if the process is killed the message is lost.
> Setting the transacted parameter, the vm connector is repeatedly
> starting/stopping. Why happens this?
>
> <route id="SQLInsert">
> <from uri="activemq:in.Q?transacted=true"/>
> <transacted/>
> <to uri="sql:insert into table
> values(:#${body})?dataSource=testDB"/>
> </route>
>
> Beans
>
> <bean id="transactionManager"
> class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
> <property name="dataSource" ref="testDB"/>
> </bean>
>
> <bean id="PROPAGATION_REQUIRED"
> class="org.apache.camel.spring.spi.SpringTransactionPolicy">
> <property name="transactionManager" ref="transactionManager"/>
> <property name="propagationBehaviorName"
> value="PROPAGATION_REQUIRED"/>
> </bean>
>
> Is there a better way of doing this?
>
> Any help will be appreciated.
> Thanks!
>
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/Camel-transacted-route-from-JMS-to-JDBC-tp5764486.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>