[jboss-user] [JNDI/Naming/Network] - MSSQLDS has no valid JNDI binding. Check the jboss-web/resou
Hi,
I am facing a problem when I want to deploy my application in the jboss-4.2.1.GA.
16:37:36,336 INFO [ConnectionFactoryBindingService] Bound ConnectionManager
'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name
'java:JmsXA'
16:37:36,508 INFO [ConnectionFactoryBindingService] Bound ConnectionManager
'jboss.jca:service=DataSourceBinding,name=MSSQLDS' to JNDI name
'java:MSSQLDS'
================================================
16:37:36,696 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console,
warUrl=.../deploy/jmx-console.war/
16:38:03,614 INFO [TomcatDeployer] deploy, ctxPath=/uc,
warUrl=.../tmp/deploy/tmp25368uc-exp.war/
================================================
16:38:03,645 WARN [ServiceController] Problem starting service
jboss.web.deployment:war=uc.war,id=1475114874
org.jboss.deployment.DeploymentException: Error during deploy; - nested throwable:
(javax.naming.NamingException: resource-ref: MSSQLDS has no valid JNDI binding. Check the
jboss-web/resource-ref.)
at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:384)
at org.jboss.web.WebModule.startModule(WebModule.java:83)
at org.jboss.web.WebModule.startService(WebModule.java:61)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
-----
----
---=-
I have my mssql-ds.xml file containg the MSSQLDS binding in the
C:\boss-4.2.1.GA\server\default\deploy folder.
Entry in the mssql-ds.xml is below
==============================================
<local-tx-datasource>
<jndi-name>MSSQLDS</jndi-name>
<!--use-java-context>false</use-java-context-->
<!--connection-url>jdbc:microsoft:sqlserver://LAPTOPIB132;DatabaseName=rfid_ucprn</connection-url-->
<connection-url>jdbc:microsoft:sqlserver://10.236.70.221;DatabaseName=rfid_ucprn</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>sa</user-name>
admin
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>10</idle-timeout-minutes>
<!-- 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)
-->
<type-mapping>MS SQLSERVER2000</type-mapping>
</local-tx-datasource>
===============================================
Can any body help me ?
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4073948#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...