Accessing data base from camel route

[joby.kj]

Hi All,

          We need to validate the camel "from uri " before proceeding to " to uri" . For this write a bean class and configured data source in camel context .  how can we perform sql statements from this bean class and comparing these sql result set with some values from the original " form uri " values ?

1) Camel route

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" >

  <property name="driverClassName" value="org.postgresql.Driver"/>

  <property name="url" value="jdbc:postgresql://localhost:5432/mydb"/>

  <property name="username" value=""/>

  <property name="password" value=""/>

   <property name="initialSize" value="20" />

   <property name="maxActive" value="30" />

</bean>

<bean id="SimpleProcessor" class="com.test.SimpleProcessor"/>

   <camelContext xmlns="http://camel.apache.org/schema/spring">

       <route id="proxy">

         <from uri="cxf:https://localhost:9091/testProxy?serviceClass=com.test.MyService"/>

         <bean ref="SimpleProcessor" />

          <to uri="cxf:http://localhost:8080/services/myService?serviceClass=com.test.MyService"/>

         </route>

   </camelContext>

2) SimpleProcessor.java

public class SimpleProcessor implements Processor {

     @Override

        public void process(Exchange exchange) {

        int id=100;

          // Here need to execute some sql  statement say , select * from customer where id='id'

     }

Thanks

[davsclaus]

If you want to access a database from a Camel Processor then its just regular Java code. So you can do any kind of Java code to do that.

You can also use some of the Camel database components to help with that such as camel-sql, camel-jdbc etc.

http://camel.apache.org/sql-component

http://camel.apache.org/jdbc

And from the Camel Processor you can use Camel's ProducerTemplate to use these Camel components easier.

http://camel.apache.org/producertemplate.html

[joby.kj]

Thank You