Data not rollbacked from DB - camel-jdbc

Hi, I have created a transactional route in camel where I use camel-jdbc component but the data are not rollbacked from DB when an error occurs. Is there something wrong in my config ? Here is the config beans xmlns=http://www.springframework.org/schema/beans; xmlns:xsi=http://www.w3

Re: Data not rollbacked from DB - camel-jdbc

Hi Charles, You route is a bit interesting, you just throw the exception after the exchange is sent to the camel-jdbc endpoint. Can you tell me why did you do that ? Willem On 3/22/11 11:59 PM, Charles Moulliard wrote: Hi, I have created a transactional route in camel where I use camel

Re: why camel-jdbc do not return an ArrayList

Oh,Thank you. Call getIn() can return ArrayList. I write getOut because http://camel.apache.org/jdbc.html says faint... -- View this message in context: http://camel.465427.n5.nabble.com/why-camel-jdbc-do-not-return-an-ArrayList-tp3406057p3406254.html Sent from the Camel - Users

Re: why camel-jdbc do not return an ArrayList

-- View this message in context: http://camel.465427.n5.nabble.com/why-camel-jdbc-do-not-return-an-ArrayList-tp3406057p3406254.html Sent from the Camel - Users mailing list archive at Nabble.com. -- Claus Ibsen - FuseSource Email: cib...@fusesource.com Web: http://fusesource.com

why camel-jdbc do not return an ArrayList

this message in context: http://camel.465427.n5.nabble.com/why-camel-jdbc-do-not-return-an-ArrayList-tp3406057p3406057.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: why camel-jdbc do not return an ArrayList

Hi Bill, Which version of Camel are you using? I just checked the camel-jdbc code, the result should be ListMapString, Object. You need to use exchange.getOut().getBody().getClass() to print the class of message body. On 3/2/11 11:43 AM, Bill wrote: Hi, the docs says that the jdbc

Re: why camel-jdbc do not return an ArrayList

); } so It return a new JmsMessage(null, binding) -- View this message in context: http://camel.465427.n5.nabble.com/why-camel-jdbc-do-not-return-an-ArrayList-tp3406057p3406157.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: why camel-jdbc do not return an ArrayList

JmsMessage(null, binding) -- View this message in context: http://camel.465427.n5.nabble.com/why-camel-jdbc-do-not-return-an-ArrayList-tp3406057p3406157.html Sent from the Camel - Users mailing list archive at Nabble.com. -- Willem -- FuseSource Web: http

Re: prepared statements in camel-jdbc?

Thanks Christian, looks like the camel-sql is a better fit than the camel-jdbc component. It handles the prepared statements the way i needed it. The prepared statement is safer than manually constructing the sql statement in a bean because I create the sql statement string based

Re: prepared statements in camel-jdbc?

Hi Tommy, no, currently the camel-jdbc component (in the JdbcProducer) only support classic statement: Statement stmt = conn.createStatement(); Feel free to create a Jira to enhance the JDBC component to support PreparedStatement. We will pick the task and implement the new feature

Re: prepared statements in camel-jdbc?

On Mon, Dec 27, 2010 at 7:59 AM, Tommy Chheng tommy.chh...@gmail.com wrote: Is it possible to use jdbc's prepared statements with camel-jdbc? It's more for a matter of preventing sql injection than performance. No its not possible. However if you want to help improve camel-jdbc feel free

Re: prepared statements in camel-jdbc?

Hello Tommy! I didn't understand how the prepared statement can be an improvement here (preventing sql injection) when the sql is constructed in your bean. Could you please explain in more detail what do you want. At present, the camel-jdbc component expects a sql query or sql update

prepared statements in camel-jdbc?

Is it possible to use jdbc's prepared statements with camel-jdbc? It's more for a matter of preventing sql injection than performance. My route is using a bean to transform an xml data input into a insert statement like this: from(direct:xmlInput). bean(classOf[xmlTransformToSql]). log

Re: camel jdbc and splitter

, Marcin -- View this message in context: http://old.nabble.com/camel-jdbc-and-splitter-tp26230505p26230505.html Sent from the Camel - Users mailing list archive at Nabble.com. -- Claus Ibsen Apache Camel Committer Author of Camel in Action: http://www.manning.com/ibsen/ Open Source

Re: camel jdbc and splitter

just do from(jdbc:xxx).split(body()).to(); Thanks, Marcin -- View this message in context: http://old.nabble.com/camel-jdbc-and-splitter-tp26230505p26230505.html Sent from the Camel - Users mailing list archive at Nabble.com. -- Claus Ibsen Apache Camel Committer Author

Re: porting camel routers (camel-jdbc) to servicemix4.0

Thanks for the quick answers FYI, I found and installed commons-dbcp and spring-jdbc using features/list and features/install (without adding new features urls, I use smx 4.0) but, as I said, I have the same error messages In the meanwhile I'll keep my old camel-jdbc-spring projects

Re: porting camel routers (camel-jdbc) to servicemix4.0

Hi Gert, I just found there is no spring-jdbc or common dbcp bundle below the camel-jdbc feature. Maybe we should consider reuse the spring-jdbc bundle or add the commons-dbcp into ServiceMix bundle repository. Willem Gert Vanthienen wrote: Matteo, Could you try adding an OSGi import

porting camel routers (camel-jdbc) to servicemix4.0

) [ 67] [Active ] [ ] [ 60] camel-spring (1.6.0) [ 159] [Active ] [ ] [ 60] camel-ognl (1.6.0) [ 160] [Active ] [ ] [ 60] camel-jms (1.6.0) [ 162] [Active ] [ ] [ 60] camel-quartz (1.6.0) [ 164] [Active ] [ ] [ 60] camel-jdbc (1.6.0) [ 170

Re: porting camel routers (camel-jdbc) to servicemix4.0

) [ 159] [Active     ] [       ] [   60] camel-ognl (1.6.0) [ 160] [Active     ] [       ] [   60] camel-jms (1.6.0) [ 162] [Active     ] [       ] [   60] camel-quartz (1.6.0) [ 164] [Active     ] [       ] [   60] camel-jdbc (1.6.0) [ 170] [Active     ] [       ] [   60] camel-velocity (1.6.0

<    1   2