Hi,
I am a new bee to servicemix,and In the process of evaluating servicemix.
Here is my task, I am trying to execute a simple query to apache derby
database, from servicemix by invoking a jms client.
I serached this forumn and could not figure out how this is beeing done.I am
abl to run the loanbroker example. so i am using the same example for my
task.
here is the step i followed :
1. configured the apache-derby db. and when i start the servicemix it
recoganizes the apache derby driver.
INFO - JBIContainer - ServiceMix JBI Container
(ServiceMix) started
INFO - JDBCAdapterFactory - Database driver recognized:
[apache_derby_embedded_jdbc_driver]
2. modified the servicemix.xml under
C:\servicemix\apache-servicemix-3.2-incubating-SNAPSHOT\conf folder
<audit:jdbcAuditor container="#jbi" autoStart="true">
<audit:dataSource>
<bean class="org.apache.derby.jdbc.EmbeddedDataSource">
<property name="databaseName" value="servicemixDB"/>
<property name="createDatabase" value="create"/>
</bean>
</audit:dataSource>
</audit:jdbcAuditor>
since i am using apache-derby what code snippet need to add in the jndi.xml
file in the same folder?
1. created loan-broker-lw-su
added the jdbc component. I am using the default jdbcComponent.java file
2. created loan-broker-jms-su
added the binding component . Here is the code for xbean.xml
<jms:endpoint service="countryname:JdbcToResponseService"
endpoint="broker"
targetService="countryname:JdbcToResponseService"
defaultOperation="sns:Hello"
role="consumer"
soap="true"
connectionFactory="#jmsFactory"
destinationStyle="queue"
jmsProviderDestinationName="demo.org.servicemix.source"
defaultMep="http://www.w3.org/2004/08/wsdl/in-out"; />
3. created loan-broker-sa
4. src filder which contains the jms client.
jms client sents a request (example: countrycode = "AR") as parameter to
execute the query SELECT COUNTRY_NAME FROM COUNTRY_CODES WHERE
COUNTRY_CODE='AR'";
I am not sure how we can call the jms clent to invoke the jdbc component and
execute the query?. I appreciate if anyone here to guide me (with examples )
how to accomplish the above task in servicemix.
thanks
joel
--
View this message in context:
http://www.nabble.com/connect-to-apache-derby-DB-from-servicemix-by-invoking-a-jms-client-tf3954323s12049.html#a11219546
Sent from the ServiceMix - Dev mailing list archive at Nabble.com.
