[jboss-user] [JNDI/Naming/Network] - MSSQLDS has no valid JNDI binding. Check the jboss-web/resou

[shankha]

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#4073948

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4073948