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.