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-tp20538155p20591502.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.
