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

Reply via email to