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.

Reply via email to