Re: [SQL COMPONENT] mysql transaction
Hi Read about transactions here http://camel.apache.org/transactional-client.html On Thu, Jan 8, 2015 at 3:58 PM, fabrizio.spataro wrote: > Hello, > > using spring DSL and tag i have this error: > > *org.apache.camel.NoSuchBeanException: No bean could be found in the > registry of type: PlatformTransactionManager* > > So.. i don't have any transactionManager. My connection is a simple mysql > connection like: > > class="org.springframework.jdbc.datasource.DriverManagerDataSource"> > > ... > ... > > > can you help me? > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/SQL-COMPONENT-mysql-transaction-tp576p5761462.html > Sent from the Camel - Users mailing list archive at Nabble.com. -- Claus Ibsen - Red Hat, Inc. Email: cib...@redhat.com Twitter: davsclaus Blog: http://davsclaus.com Author of Camel in Action: http://www.manning.com/ibsen hawtio: http://hawt.io/ fabric8: http://fabric8.io/
Re: [SQL COMPONENT] mysql transaction
Hi uses TtransactionTemplate from spring-tx jar/bundle. Try adding it to classpath/maven-dependencies. regards Grzegorz p.s. I'll check your example tomorrow morning CET 2015-01-08 15:58 GMT+01:00 fabrizio.spataro : > Hello, > > using spring DSL and tag i have this error: > > *org.apache.camel.NoSuchBeanException: No bean could be found in the > registry of type: PlatformTransactionManager* > > So.. i don't have any transactionManager. My connection is a simple mysql > connection like: > > > class="org.springframework.jdbc.datasource.DriverManagerDataSource"> > > ... > ... > > > can you help me? > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/SQL-COMPONENT-mysql-transaction-tp576p5761462.html > Sent from the Camel - Users mailing list archive at Nabble.com. >
Re: [SQL COMPONENT] mysql transaction
Hello, using spring DSL and tag i have this error: *org.apache.camel.NoSuchBeanException: No bean could be found in the registry of type: PlatformTransactionManager* So.. i don't have any transactionManager. My connection is a simple mysql connection like: ... ... can you help me? -- View this message in context: http://camel.465427.n5.nabble.com/SQL-COMPONENT-mysql-transaction-tp576p5761462.html Sent from the Camel - Users mailing list archive at Nabble.com.
Re: [SQL COMPONENT] mysql transaction
Have a look at [1].
from("direct:start")
.transacted("PROPAGATION_REQUIRED")
.to("sql:INSERT ...")
.to("sql:INSERT ...");
[1]
https://github.com/muellerc/camel-in-transaction/blob/master/src/test/java/org/apache/cmueller/camel/samples/camelone/jdbc/JdbcTransactionSampleTest.java
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 Mon, Dec 29, 2014 at 10:55 AM, fabrizio.spataro <
fabrizio.spat...@bizmate.it> wrote:
> Hello,
>
> i would use sql component (http://camel.apache.org/sql-component.html)
> into
> a transactional scenario.
>
> For example:
>
> 0) begin
> 1) insert
> 2) insert
> 3) commit
>
> I am using mysql.
>
> What is the best strategy to do it using camel's component?
>
> Tnkx
>
>
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/SQL-COMPONENT-mysql-transaction-tp576.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>
