Re: Camel transacted route from JMS to JDBC

2015-04-09 Thread Christian Müller
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.alva...@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.



Camel transacted route from JMS to JDBC

2015-03-20 Thread Cecilio Alvarez
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.