[jboss-user] [Datasource Configuration] - Jboss6: Unable to get managed connection for jdbc with Spring

[amber jboss1999]

amber jboss1999 [http://community.jboss.org/people/amberjboss1999] created the discussion

"Jboss6: Unable to get managed connection for jdbc with Spring"

To view the discussion, visit: http://community.jboss.org/message/603536#603536

--------------------------------------------------------------
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
[http://community.jboss.org/message/603536#603536]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110504/0647a153/attachment.html