JBoss Community

hello all,

i am converting older webshere, spring and ibatis services to jboss 5.1.

i have my web services deployed but when i fire my test calls (using soapUI) at the service, i get the following error (see way below).

any help would be greatly appreciated.

thx

mark

here is my db2-ds.xml file (pulled from the examples and modified) that is deployed in the $JBOSS_HOME/server/default/deploy dir

<?xml version="1.0" encoding="UTF-8"?>

<!-- ===================================================================== -->

<!--                                                                       -->

<!--  JBoss Server Configuration                                           -->

<!--                                                                       -->

<!-- ===================================================================== -->

<!-- See http://www.jboss.org/community/wiki/Multiple1PC for information about local-tx-datasource -->

<!-- $Id: db2-ds.xml 88948 2009-05-15 14:09:08Z jesper.pedersen $ -->

<datasources>

  <local-tx-datasource>

        <jndi-name>jdbc/MembershipDB</jndi-name>

    <connection-url>jdbc:db2://blah.blah.com:9999/DB91</connection-url>

    <!-- DB2 Universal Driver Note connection URL is in form of

         jdbc:db2://host:port:dbname

         Default port for Type 4 driver is 50000

         Note, host and port must be specified if using Type 4 driver. And be forewarned, no native

         XA support is provided with Type 4; you must set a DB property calling for Type 2 to get XA

      <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>

      <connection-url>jdbc:db2://[hostname]:[port]/databasename"</connection-url>

      Please see http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0512kokkat/

      or the DB2 JDBC application developers manual.

    --> 

        <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>

        <!--

    <driver-class>COM.ibm.db2.jdbc.app.DB2Driver</driver-class>

        -->

    <user-name>someuser</user-name>

    <password>somepassword</password>

    <min-pool-size>0</min-pool-size>

    <!-- New org.jboss.resource.adapter.jdbc.vendor.DB2ExceptionSorter

    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.DB2ExceptionSorter</exception-sorter-class-name>

    -->

    <!-- sql to call when connection is created

    <new-connection-sql>some arbitrary sql</new-connection-sql>

    -->

    <!-- sql to call on an existing pooled connection when it is obtained from pool

    <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>

    -->

  <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->

      <metadata>

         <type-mapping>DB2</type-mapping>

      </metadata>

  </local-tx-datasource>

here are the libs that i am deploying in $JBOSS_HOME/server/default/lib

-rw-r--r-- 1 mark users 3352093 Oct  9 08:24 db2jcc.jar

-rw-r--r-- 1 mark users   23709 Oct  9 08:24 db2jcc_javax.jar

-rw-r--r-- 1 mark users    2068 Oct  9 08:24 db2jcc_license_cisuz.jar

-rw-r--r-- 1 mark users     673 Oct  9 08:24 db2jcc_license_c.jar

-rw-r--r-- 1 mark users    1015 Oct  9 08:24 db2jcc_license_cu.jar

these same libs are being deployed in the .war file

3352093  10-09-2012 09:30   WEB-INF/lib/db2jcc.jar

    23709  10-09-2012 09:30   WEB-INF/lib/db2jcc_javax.jar

      673  10-09-2012 09:30   WEB-INF/lib/db2jcc_license_c.jar

     2068  10-09-2012 09:30   WEB-INF/lib/db2jcc_license_cisuz.jar

     1015  10-09-2012 09:30   WEB-INF/lib/db2jcc_license_cu.jar

here is my beans.xml file

   0  10-09-2012 09:30   WEB-INF/classes/resources/

        0  10-09-2012 09:30   WEB-INF/classes/resources/ibatis/

    11254  10-09-2012 09:30   WEB-INF/classes/resources/ibatis/MembershipMap.xml

      557  10-09-2012 09:30   WEB-INF/classes/resources/ibatis/SqlMapConfig.xml

     3313  10-09-2012 09:30   WEB-INF/classes/resources/ibatis/SubscriptionMap.xml

       14  10-09-2012 09:30   WEB-INF/classes/resources/ibatis/databaseConfig.properties

        0  10-09-2012 09:30   WEB-INF/classes/resources/spring/

     1008  10-09-2012 09:30   WEB-INF/classes/resources/spring/BusinessObject.xml

      657  10-09-2012 09:30   WEB-INF/classes/resources/spring/DataAccessObject.xml

      480  10-09-2012 09:30   WEB-INF/classes/resources/spring/Manager.xml

      582  10-09-2012 09:30   WEB-INF/classes/resources/spring/MembershipBusinessObject.xml

      859  10-09-2012 09:30   WEB-INF/classes/resources/spring/MembershipDataAccessObject.xml

      991  10-09-2012 09:30   WEB-INF/classes/resources/spring/MembershipManager.xml

     4865  10-09-2012 09:30   WEB-INF/classes/resources/spring/beans.xml

<beans xmlns="http://www.springframework.org/schema/beans"

        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"                                                                                                                                                    

        xmlns:jaxws="http://cxf.apache.org/jaxws"

        xsi:schemaLocation="                                                                                                                                                                                     

http://www.springframework.org/schema/beans                                                                                                                                                                      

http://www.springframework.org/schema/beans/spring-beans.xsd

http://cxf.apache.org/jaxws

http://cxf.apache.org/schemas/jaxws.xsd">                                                                                                                                                                        

        <import resource="classpath:META-INF/cxf/cxf.xml" />

        <import resource="classpath:META-INF/cxf/cxf-extension-soap.xml" />                                                                                                                                      

        <import resource="classpath:META-INF/cxf/cxf-servlet.xml" />

        <jaxws:endpoint id="membershipServiceEndPoint"                                                                                                                                                           

                implementor="#membershipService" address="/MembershipService">                                                                                                                                   

                <jaxws:properties>

                        <entry key="schema-validation-enabled" value="true" />

                </jaxws:properties>

        </jaxws:endpoint>

   <bean id="dataSourceMySql" class="org.springframework.jndi.JndiObjectFactoryBean">

        <property name="jndiName" value="java:jdbc/SubscriptionDataSource"/>

        <property name="lookupOnStartup" value="false"/>

        <property name="cache" value="false"/>

        <property name="proxyInterface" value="javax.sql.DataSource"/>

        </bean>

   <bean id="membershipDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">

        <property name="jndiName" value="java:jdbc/MembershipDB"/>

        <property name="lookupOnStartup" value="false"/>

        <property name="cache" value="false"/>

        <property name="proxyInterface" value="javax.sql.DataSource"/>

    </bean>

        <bean id="transactionManager"

                class="org.springframework.jdbc.datasource.DataSourceTransactionManager"

                autowire="byName">

                <property name="dataSource">

                        <ref bean="dataSourceMySql" />

                </property>

        </bean>

        <bean id="transactionManagerDB2"

                class="org.springframework.jdbc.datasource.DataSourceTransactionManager"

                autowire="byName">

                <property name="dataSource">

                        <ref bean="membershipDataSource" />

                </property>

        </bean>

        <bean id="attributeSource"

                class="org.springframework.transaction.interceptor.NameMatchTransactionAttributeSource">

                <property name="properties">

                        <props>

                                <prop key="*">

                                        PROPAGATION_REQUIRED,ISOLATION_DEFAULT,-Exception

                                </prop>

                        </props>

                </property>

        </bean>

        <bean id="sqlMapClient"

                class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"

                abstract="false" autowire="byName">

                <property name="configLocation">

                        <value>classpath:resources/ibatis/SqlMapConfig.xml</value>

                </property>

                <property name="useTransactionAwareDataSource">

                        <value>true</value>

                </property>

                <property name="dataSource">

                        <ref bean="dataSourceMySql" />

                </property>

        </bean>

        <bean id="DB2MapClient"

                class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"

                abstract="false" autowire="byName">

                <property name="configLocation">

                        <value>classpath:resources/ibatis/SqlMapConfig.xml</value>

                </property>

                <property name="useTransactionAwareDataSource">

                        <value>true</value>

                </property>

                <property name="dataSource">

                        <ref bean="membershipDataSource" />

                </property>

        </bean>

        <bean id="subscriptionService"

                class="com.sears.hs.subscription.service.SubscriptionService">

                <property name="subscriptionManager" ref="subscriptionManager" />

        </bean>

        <bean id="membershipService"

                class="com.sears.hs.subscription.service.MembershipService">

                <property name="membershipManager" ref="membershipManager" />

        </bean>

        <import resource="Manager.xml" />

        <import resource="BusinessObject.xml" />

        <import resource="DataAccessObject.xml" />

        <import resource="MembershipManager.xml" />

        <import resource="MembershipBusinessObject.xml" />

        <import resource="MembershipDataAccessObject.xml" />

</beans>

finally here is the error that i am receiving:

org.springframework.aop.AopInvocationException: AOP configuration seems to be invalid: tried calling method [public abstract java.sql.Connection javax.sql.DataSource.getConnection() throws java.sql.SQLException] on target [org.jboss.resource.adapter.jdbc.WrapperDataSource@14e6e7d]; nested exception is java.lang.IllegalArgumentException: object is not an instance of declaring class

09:42:13,845 INFO  [STDOUT] ache.cxf.transport.servlet.AbstractCXFServlet.invoke(AbstractCXFServlet.java:142)

Caused by: java.lang.IllegalArgumentException: object is not an instance of declaring class