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.
>