JBoss Community

Jboss6: Unable to get managed connection for jdbc with Spring

created by amber jboss1999 in Datasource Configuration - View the full discussion

I am migrating an exisiting web app (war) from apache tomcat 6 to jboss6.

I keep getting:

DEPLOYMENTS IN ERROR:

  Deployment "vdpDS" is in error due to the following reason(s): ** NOT FOUND Depends on 'vdpDS' **

 

1./WEB-INF/applicationContext:

<jee:jndi-lookup id="dataSource" jndi-name="java:comp/env/vdpDS" resource-ref="true" expected-type="javax.sql.DataSource" />

 

2.WEB-INF/web.xml

<resource-ref>

        <res-ref-name>vdpDS</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
        <res-sharing-scope>Shareable</res-sharing-scope>
    </resource-ref>

 

3.WEB-INF/jboss-web.xml

<jboss-web>

<resource-ref>

<res-ref-name>vdpDS</res-ref-name>

<jndi-name>vdpDS</jndi-name>

</resource-ref>

</jboss-web>

 

4. i think this is for tomcat, but it's there anyway:

META-INF/context.xml

<context>

    <ResourceLink global="vdpDS" name="java:comp/env/vdpDS" type="javax.sql.DataSource"/>

</context>

 

5. my vdpDS-ds.xml, under deploy/<vdpDS> subfolder:

<local-tx-datasource>

                        <jndi-name>vdpDS</jndi-name>

                        <driver-class>com.inet.tds.TdsDriver</driver-class>-->

                        <connection-url>jdbc:jtds:sqlserver://server:port;database=db</connection-url>

                        <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>

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

                        <password>pwd</password>

        </local-tx-datasource>

 

6. I also dropped the jdbc.jar in the lib/<vdpDS> subfolder

subfolder, using jtds1.2.3.jar

 

This setup was working for tomcat6.

Can someone help me solve this datasource not found error, please?



Reply to this message by going to Community

Start a new discussion in Datasource Configuration at Community