[SQL Component] Transaction manager force commit
Hello, i am using camel 2.14.2-SNAPSHOT. Into my transacted route are using this settings: My routes are: 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.
Re: [SQL Component] Transaction manager force commit
Hello Fabrizio Do you really need to? is for having single transaction for releated DML statements. If you really need to have commit after each INSERT you can remove and configure your datasource to return connections with autocommit set to true. But I can't imagine where it's needed. regards Grzegorz Grzybek 2015-02-19 15:20 GMT+01:00 fabrizio.spataro : > Hello, > > i am using camel 2.14.2-SNAPSHOT. > > Into my transacted route are using this settings: > > > class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> > > > > class="org.apache.camel.spring.spi.SpringTransactionPolicy"> > ref="transactionManager"/> > value="PROPAGATION_REQUIRES_NEW"/> > > > My routes are: > > > > > > > > > > > > > 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. >
Re: [SQL Component] Transaction manager force commit
Hello everyone, To force commit you just typing ** King Regards! -- View this message in context: http://camel.465427.n5.nabble.com/SQL-Component-Transaction-manager-force-commit-tp5762948p5763193.html Sent from the Camel - Users mailing list archive at Nabble.com.