Is it possible to post the full working configuration including the servicemix.xml, jndi.xml and the pom.xml file of the SU?
Thanks in advance. Berndt -----Ursprüngliche Nachricht----- Von: subh [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 20. November 2008 03:34 An: [email protected] Betreff: Re: Advanced JDBC by Spargic Just to let you know, I got it working. I was not using the xpath properly. anyways, thanks for looking subh wrote: > > Hi, > > I am trying to use the Advanced JDBC Component by Spagic to call a SP. I > have configured the component as below > > <sm:activationSpec componentName="jdbcPricingService" > service="myesb:jdbcPricingService" destinationService="myesb:echoService"> > <sm:component> > <bean > class="org.spagic.smx.components.jdbcstore.JDBCStoreProcedureComponent"> > <property name="connConfig"> > <bean class="org.spagic.smx.components.jdbcquery.JDBCConnectionConfig"> > <!-- <property name="databaseVendor" value="MySQL" /> --> > <property name="datasource" ref="pricingDS"/> > </bean> > </property> > <property name="queryConfig"> > <bean class="org.spagic.smx.components.jdbcquery.JDBCQueryConfig"> > <property name="query" value="{call payment($paymentAmount, $sellerId)}" > /> > <property name="enrichMessage" value="FALSE" /> > <property name="xmlEnvelope" value="store-results" /> > <property name="queryParams"> > <list> > <bean class="org.spagic.smx.components.jdbcquery.QueryParameterConfig" > > <property name="placeHolder" value="paymentAmount" /> > <property name="outputParam" value="TRUE" /> > <!-- <property name="XPath" value="null" /> --> > <property name="paramType" value="java.lang.String" /> > </bean> > <bean class="org.spagic.smx.components.jdbcquery.QueryParameterConfig" > > <property name="placeHolder" value="sellerId" /> > <property name="outputParam" value="TRUE" /> > <!-- <property name="XPath" value="null" /> --> > <property name="paramType" value="java.lang.String" /> > </bean> > </list> > </property> > </bean> > </property> > </bean> > </sm:component> > </sm:activationSpec> > > As you can see, my SP needs 2 params ($paymentAmount, $sellerId), I would > like to know how could I pass these params while calling this component. > If I pass them as > > <?xml version="1.0" encoding="UTF-8"?> > <queryConfig> > <paymentAmount>100</paymentAmount> > <sellerId>1</sellerId> > </queryConfig> > > I get the following error > > ERROR > ====== > > DEBUG - SedaQueue - > [EMAIL PROTECTED] dequeued > exchange: InOnly[ > id: ID:10.30.9.159-11db6eca25c-11:13 > status: Active > role: provider > service: {http://com.mycompany.myesb/esb}jdbcPricingService > endpoint: jdbcPricingService > in: <?xml version="1.0" encoding="UTF-8"?><queryConfig> > <paymentAmount>100</paymentAmount> > <sellerId>1</sellerId> > </queryConfig> > ] > DEBUG - DeliveryChannelImpl - Send > ID:10.30.9.159-11db6eca25c-11:13 in DeliveryChannel{jdbcPricingService} > DEBUG - SecuredBroker - send exchange with secure broker > DEBUG - SedaFlow - Called Flow send > DEBUG - SedaQueue - > [EMAIL PROTECTED] dequeued > exchange: InOnly[ > id: ID:10.30.9.159-11db6eca25c-11:13 > status: Error > role: consumer > service: {http://com.mycompany.myesb/esb}jdbcPricingService > endpoint: jdbcPricingService > in: <?xml version="1.0" encoding="UTF-8"?><queryConfig> > <paymentAmount>100</paymentAmount> > <sellerId>1</sellerId> > </queryConfig> > error: java.lang.NullPointerException > ] > DEBUG - DeliveryChannelImpl - Notifying exchange > ID:10.30.9.159-11db6eca25c-11:13(14e7ecf) in > DeliveryChannel{servicemix-file} from processInboundSynchronousEx > change > DEBUG - DeliveryChannelImpl - Notified: > ID:10.30.9.159-11db6eca25c-11:13(14e7ecf) in > DeliveryChannel{servicemix-file} from sendSync > ERROR - FileComponent - Failed to process file: > PriceFeeds\TestJDBC.xml. Reason: java.lang.NullPointerException > java.lang.NullPointerException > at java.lang.StringBuffer.<init>(StringBuffer.java:104) > at > org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:347) > at > org.spagic.smx.components.jdbcstore.NewStoreProcedureRunner.call(NewStoreProcedureRunner.java:77) > at > org.spagic.smx.components.jdbcstore.JDBCStoreProcedureComponent.transform(JDBCStoreProcedureComponent.java:92) > at > org.apache.servicemix.components.util.TransformComponentSupport.onMessageExchange(TransformComponentSupport.java:71) > at > org.apache.servicemix.jbi.messaging.DeliveryChannelImpl.processInBound(DeliveryChannelImpl.java:610) > at > org.apache.servicemix.jbi.nmr.flow.AbstractFlow.doRouting(AbstractFlow.java:172) > at > org.apache.servicemix.jbi.nmr.flow.seda.SedaFlow.doRouting(SedaFlow.java:167) > at > org.apache.servicemix.jbi.nmr.flow.seda.SedaQueue$1.run(SedaQueue.java:134) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) > at java.lang.Thread.run(Thread.java:595) > > Will appreciate any help. > > rgds > subh > > > Berndt Sevcik wrote: >> >> I try to use the Advanced JDBC Component by Spargic in Servicemix. When I >> deploy the Component I get the following error: >> < >> loc-message>org.springframework.beans.factory.parsing.BeanDefinitionParsingException: >> Configuration problem: Class that bean class >> [org.spagic.smx.components.jdbcquery.JDBCAdvancedQueryComponent] depends >> on not found >> Offending resource: file >> [C:\apache-servicemix-3.2.2\data\smx\service-assemblies\tutorial-jdbc-sa\version_20\sus\servicemix-lwcontainer\tutorial-adv_jdbc-su\servicemix.xml] >> Bean ''; nested exception is java.lang.NoClassDefFoundError: >> org/springframework/jdbc/CannotGetJdbcConnectionException</loc-message> >> >> Has someone an idea? In the following the steps I have done to configure >> it. >> >> First I copied: >> commons-dbutils-1.1.jar and mysql-connector-java-5.0.7-bin.jar to the >> lib/ directory >> and spagic-advanced-jdbc-2.3.0.jar to the lib/optional directory of >> Servicemix (like in Spagic). >> >> In jndi.xml I added: >> <entry key="java:comp/env/jdbc/servicemixDB"> >> <!-- <bean id="mysql-ds" >> class="org.springframework.jdbc.datasource.DriverManagerDataSource"> --> >> <bean id="mysql-ds" >> class="org.apache.commons.dbcp.BasicDataSource"> >> <property name="driverName" value="com.mysql.jdbc.Driver"/> >> <property name="url" value="jdbc:mysql://localhost/NameInfo"/> >> <property name="user" value="user"/> >> <property name="password" value="password"/> >> </bean> >> </entry> >> >> Then I created a servicemix.xml file that looks like this: >> <beans xmlns:sm="http://servicemix.apache.org/config/1.0"; >> xmlns:foo="http://servicemix.apache.org/foo"; >> xmlns="http://www.springframework.org/schema/beans"; >> xmlns:xsi="http://http://www.w3.org/2001/XMLSchema-instance"; >> xsi:schemaLocation="http://servicemix.apache.org/config/1.0 >> http://servicemix.apache.org/schema/servicemix-core-3.2.2.xsd >> http://www.springframework.org/schema/beans >> http://www.springframework.org/schema/beans/spring-beans-2.0.xsd";> >> >> <!-- This is the Spring configuration of a datasource defined in >> SERVICE_MIX_HOME/conf/jndi.xml --> >> <bean id="mySql" >> class="org.springframework.jndi.JndiObjectFactoryBean"> >> <property name="jndiName" value="java:comp/env/jdbc/servicemixDB"/> >> </bean> >> >> <classpath> >> <location>.</location> >> </classpath> >> >> >> <sm:serviceunit id="jbi"> >> <!-- Put lw components here --> >> <!-- Note that JDBC Endpoint declare a property ref to the >> dataSource defined by the bean above --> >> <!-- ####################### myJDBCdbAndrea >> ######################## --> >> <sm:activationSpecs> >> <sm:activationSpec componentName="myJdbcQueryadvJdbcDatasource2" >> service="foo:myJdbcQueryadvJdbcDatasource2" >> destinationService="foo:myScreenOutputadvJdbcDatasource2"> >> <sm:component> >> <bean >> class="org.spagic.smx.components.jdbcquery.JDBCAdvancedQueryComponent"> >> <property name="connConfig"> >> <bean >> class="org.spagic.smx.components.jdbcquery.JDBCConnectionConfig"> >> <property name="datasource" ref="mysql"/> >> </bean> >> </property> >> <property name="queryConfig"> >> <bean >> class="org.spagic.smx.components.jdbcquery.JDBCQueryConfig"> >> <property name="query" value="SELECT * FROM user where >> SecondName like $name" /> >> <property name="enrichMessage" value="TRUE" /> >> <property name="xmlEnvelope" value="Customer" /> >> <property name="queryParams"> >> <list> >> <bean >> class="org.spagic.smx.components.jdbcquery.QueryParameterConfig" > >> <property name="placeHolder" value="name" /> >> <property name="outputParam" value="FALSE" /> >> <property name="XPath" >> value="/nameinfo/givenName" /> >> <property name="paramType" >> value="java.lang.String" /> >> </bean> >> </list> >> </property> >> </bean> >> </property> >> </bean> >> </sm:component> >> </sm:activationSpec> >> </sm:activationSpecs> >> </sm:serviceunit> >> >> </beans> >> >> With mvn install I created my Service Assembly. >> >> -- >> Dipl.-Ing. Berndt Sevcik >> TU Wien >> Institut für Computertechnik >> Gußhausstraße 27-29/384 - 1040 Wien >> Tel.: +43 1 58801 38436 >> Mail: [EMAIL PROTECTED] >> URL: http://www.ict.tuwien.ac.at >> >> >> >> >> > > -- View this message in context: http://www.nabble.com/Advanced-JDBC-by-Spargic-tp20538155p20593965.html Sent from the ServiceMix - User mailing list archive at Nabble.com.
