Hello,

i am using camel 2.14.2-SNAPSHOT.

Into my transacted route are using this settings:

<bean id="transactionManager"
          
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
          <property name="dataSource" ref="mysql"></property>
</bean>

<bean id="PROPAGATION_REQUIRES_NEW"
class="org.apache.camel.spring.spi.SpringTransactionPolicy">
                <property name="transactionManager" ref="transactionManager"/>
                <property name="propagationBehaviorName"
value="PROPAGATION_REQUIRES_NEW"/>
</bean>

My routes are:
<route>
    <from uri="direct://myRouteOne" />
                        
    <camel:transacted ref="PROPAGATION_REQUIRES_NEW"/>

    <to uri="sql:MY INSERT QUERY 1" />

    <to uri="sql:MY INSERT QUERY 2" />

    <to uri="sql:MY INSERT QUERY 3" />
</route>

Can i insert a *programmatic commit* between QUERY 2 and QUERY 3? How do it
with SPRING DSL?

thankx



--
View this message in context: 
http://camel.465427.n5.nabble.com/SQL-Component-Transaction-manager-force-commit-tp5762948.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Reply via email to