Hi Please read this page to better report issues at the user form http://camel.apache.org/support.html
And why dont you just use a POJO to access the database, that is much easier. For example using spring JDBC. Because in your use case you need to bind multiple values to the SQL statement which is much easier from POJO. Otherwise iBatis is also an excellent SQL mapper. http://camel.apache.org/ibatis On Tue, Feb 16, 2010 at 10:04 AM, piryambada <[email protected]> wrote: > > Hi, > > > I am trying to insert some values in one table using camel sql component in > felix osgi . > My routing is like this > > > <to uri="bean:parsingService?method=parse"/> > <process ref="bookingProcessor"></process> > <when> > <simple>in.header.bookingList</simple> > <split> > <simple>in.body</simple> > <to uri="sql:insert into > bookinglist(bookinglist_id,datetime) > values(#,#)"/> > </split> > </when> > > My split is returning list like this[1,2009-10-10 10:10:10] but after split > it is not executing sql component. > But if i m givinng <to uri="sql:insert into > bookinglist(bookinglist_id,datetime) values(1,'2009-10-10 10:10:10')"/> like > this it is storing in db... > I also tried like <to uri="sql:insert into > bookinglist(bookinglist_id,datetime) values(#,'#')"/> but still it is not > working..,can anybody tell me where i m doing mistake..Plz reply soon.. > > > Thanks > Priyambada > > > > > -- > View this message in context: > http://old.nabble.com/camel-sql-insertion-is-not-working-in-osgi-tp27605294p27605294.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 Integration: http://fusesource.com Blog: http://davsclaus.blogspot.com/ Twitter: http://twitter.com/davsclaus
