Can you post the entire configuration from servicemix.xml? How did you specify the "xmlEnvelope", "rowsXmlEnvelope" and "rowXmlEnvelope" property?
Berndt Sevcik wrote: > > With your help the setup is now working without query Parameters. When I > add the following lines to servicemix.xml with XPath: > > <property name="query" value="SELECT * FROM user WHERE SecondName like > $name" /> > ... > <property name="queryParams"> > <list> > <bean > class="org.spagic.smx.components.jdbcquery.QueryParameterConfig" > > <property name="placeHolder" value="name" /> > <property name="outputParam" value="TRUE" /> > <property name="xpath" value="/queryConfig/name" > /> > <property name="paramType" > value="java.lang.String" /> > </bean> > </list> > </property> > > I get always the following exception: > > 17:06:32,515 | WARN | > pool-flow.seda.myJdbcQueryadvJdbcDatasource2-thread-2 | FileComponent > > | icemix.file.FilePollerEndpoint 389 | Message in file > C:\Projects\SimpleJDBC\poller\input.xml could not be handled successfully: > java.io.IOException: Stream closed > javax.xml.transform.TransformerException: java.io.IOException: Stream > closed > at > org.apache.xalan.transformer.TransformerIdentityImpl.transform(TransformerIdentityImpl.java:505) > at > org.apache.servicemix.jbi.jaxp.SourceTransformer.toResult(SourceTransformer.java:125) > at > org.apache.servicemix.jbi.jaxp.SourceTransformer.toResult(SourceTransformer.java:103) > at > org.apache.servicemix.jbi.jaxp.SourceTransformer.toString(SourceTransformer.java:140) > at > org.apache.servicemix.jbi.jaxp.SourceTransformer.contentToString(SourceTransformer.java:161) > at > org.spagic.smx.components.jdbcquery.JDBCAdvancedQueryComponent.transform(JDBCAdvancedQueryComponent.java:147) > at > org.apache.servicemix.components.util.TransformComponentSupport.onMessageExchange(TransformComponentSupport.java:71) > at > org.apache.servicemix.jbi.messaging.DeliveryChannelImpl.processInBound(DeliveryChannelImpl.java:620) > at > org.apache.servicemix.jbi.nmr.flow.AbstractFlow.doRouting(AbstractFlow.java:172) > at > org.apache.servicemix.jbi.nmr.flow.seda.SedaFlow.doRouting(SedaFlow.java:168) > 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) > > My input file looks like this: > <?xml version="1.0" encoding="UTF-8"?> > <queryConfig> > <name>Sevcik</name> > </queryConfig> > > Is there an error in my XPath? Any other idea? Thanks in advance. > > Berndt > -- > 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 > > > > -----Ursprüngliche Nachricht----- > Von: subh [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 26. November 2008 16:21 > An: [email protected] > Betreff: Re: AW: Advanced JDBC by Spargic > > > Here you go.. > > Servicemix.xml > ++++++++++++ > > <bean id="athenaPricingDS" > class="org.springframework.jndi.JndiObjectFactoryBean"> > <property name="jndiName" value="java:comp/env/jdbc/athenaPricingDB"/> > </bean> > > <sm:activationSpec componentName="jdbcPricingService" > service="athena:jdbcPricingService" > destinationService="athena:echoService"> > <sm:component> > <bean > class="org.spagic.smx.components.jdbcstore.JDBCStoreProcedureComponent"> > <property name="connConfig"> > <bean class="org.spagic.smx.components.jdbcquery.JDBCConnectionConfig"> > <property name="datasource" ref="athenaPricingDS"/> > </bean> > </property> > <property name="queryConfig"> > <bean class="org.spagic.smx.components.jdbcquery.JDBCQueryConfig"> > <property name="query" value="{call > COMMON_PRICE_DATA.processPrices($priceFeedCode, $priceFeedOption, > $processStart)}" /> > <property name="enrichMessage" value="false" /> > <property name="xmlEnvelope" value="" /> > <property name="rowsXmlEnvelope" value="payload"/> > <property name="rowXmlEnvelope" value="pricefeed"/> > <property name="queryParams"> > <list> > <bean class="org.spagic.smx.components.jdbcquery.QueryParameterConfig" > > <property name="placeHolder" value="priceFeedCode" /> > <property name="outputParam" value="false" /> > <property name="xpath" value="/payload/pricefeed/priceFeedCode" /> > <property name="paramType" value="java.lang.String" /> > </bean> > <bean class="org.spagic.smx.components.jdbcquery.QueryParameterConfig" > > <property name="placeHolder" value="priceFeedOption" /> > <property name="outputParam" value="false" /> > <property name="xpath" value="/payload/pricefeed/priceFeedOption" /> > <property name="paramType" value="java.lang.String" /> > </bean> > <bean class="org.spagic.smx.components.jdbcquery.QueryParameterConfig" > > <property name="placeHolder" value="processStart" /> > <property name="outputParam" value="false" /> > <property name="xpath" value="/payload/pricefeed/processStart" /> > <property name="paramType" value="java.lang.String" /> > </bean> > </list> > </property> > </bean> > </property> > </bean> > </sm:component> > </sm:activationSpec> > </sm:activationSpecs> > </sm:container> > > Jndi.xml > +++++++ > > <entry key="java:comp/env/jdbc/athenaPricingDB"> > <bean > class="org.springframework.jdbc.datasource.DriverManagerDataSource"> > <property name="driverClassName" > value="oracle.jdbc.driver.OracleDriver"/> > <property name="url" > value="jdbc:oracle:thin:@10.11.1.41:1521:DB03"/> > <property name="username" value="PRICING_APP"/> > <property name="password" value="PRICING_APP"/> > </bean> > </entry> > > And you can invoke this service, e.g., from a file poller, xbean below > > <file:poller service="athena:pricingFilePoller" > endpoint="toFtpPoller" > targetService="athena:jdbcPricingService" > file="file:PriceFeeds" > period="40000" > delay = "20000" > > <property name="filter"> > <bean class="org.apache.commons.io.filefilter.WildcardFilter"> > <constructor-arg value="*.xml" /> > </bean> > </property> > </file:poller> > > Rgds > subh > > > Berndt Sevcik wrote: >> >> >> 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. >> >> >> > > -- > View this message in context: > http://www.nabble.com/Advanced-JDBC-by-Spargic-tp20538155p20702669.html > Sent from the ServiceMix - User mailing list archive at Nabble.com. > > > -- View this message in context: http://www.nabble.com/Advanced-JDBC-by-Spargic-tp20538155p20857110.html Sent from the ServiceMix - User mailing list archive at Nabble.com.
