Hi, priyambada, me also facing same issue , if u get any solution please reply .
Thanks, Nagendra. Claus Ibsen-2 wrote: > > 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 > > -- View this message in context: http://old.nabble.com/camel-sql-insertion-is-not-working-in-osgi-tp27605294p27634404.html Sent from the Camel - Users mailing list archive at Nabble.com.
