Hi You need to the route to start with a <from>
<route> <from uri="timer:foo?period=5000"/> <setBody> <constant>select * from GEO_FEATURE</constant> </setBody> <to uri="jdbc:dataSource"/> <to uri="log:response"/> </route> eg you can also see this by the examples on the jdbc doc page http://camel.apache.org/jdbc On Thu, May 2, 2013 at 10:20 AM, skysw...@gmail.com <skysw...@gmail.com> wrote: > Hi everyone, > > I want to do some search in Oracle 11g with the following xml. > > <bean id="dataSource" > class="org.springframework.jdbc.datasource.DriverManagerDataSource"> > <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/> > <property name="url" value="jdbc:oracle:thin:@ip:port:dbname" /> > <property name="username" value="xxx" /> > <property name="password" value="xxx" /> > </bean> > > <route> > <setBody> > <constant>select * from GEO_FEATURE</constant> > </setBody> > <to uri="jdbc:dataSource"/> > </route> > > However I got response and no error log, is there any possible reason or > some suggested debug method for me? > > Thanks a lot! -- Claus Ibsen ----------------- Red Hat, Inc. FuseSource is now part of Red Hat Email: cib...@redhat.com Web: http://fusesource.com Twitter: davsclaus Blog: http://davsclaus.com Author of Camel in Action: http://www.manning.com/ibsen