dynamic query using camel JPA binding

[harish0611]

Hi,

I have referred switchyard quick start example to persist and query db entities which worked fine.

<sca:reference name="QueryService" multiplicity="0..1" promote="DatalayerServiceBean/QueryService">

      <sca:interface.java interface="com.nielsen.engineering.mediaworks.service.query.QueryService"/>

      <sql:binding.sql>

        <operationSelector operationName="queryDb"/>

  <sql:contextMapper/>

        <sql:query>SELECT * FROM Table1</sql:query>

        <sql:dataSourceRef>java:jboss/datasources/mmds</sql:dataSourceRef>

      </sql:binding.sql>

    </sca:reference>

in above switchyard.xml extract sql:query is hardcoded in configuration file. I want to test how to send sql query dynamically. Do we have any place holder for sql query ? or is their any way to set the sql:query element dynamically from java class ?

Kindly direct me to some example where we do

1. updating specific db column in a table,

2. Sending sql query dynamically

Thanks in Advance..

[kcbabo]

You mention the Camel JPA binding in the title of your post, but the example provided used Camel SQL.  Do you have a requirement to use one or the other?

I have not tested this locally, but it appears the Camel SQL component supports using a header 'CamelSqlQuery' to override the SQL query specified in the endpoint:

http://grepcode.com/file/repo1.maven.org/maven2/org.apache.camel/camel-sql/2.10.4/org/apache/camel/component/sql/SqlProducer.java?av=f#45

What implementation are you using to invoke this reference (Bean, Camel, ...)?  If it's a Camel route, then just set the header using setHeader in your route definition.  If it's a Bean implementation, then you'll need to use a ReferenceInvoker:

Bean - SwitchYard - Project Documentation Editor

hth,

keith