0 Replies Latest reply on Aug 14, 2007 7:53 AM by shankha Bhattacharya

    MSSQLDS has no valid JNDI binding. Check the jboss-web/resou

    shankha Bhattacharya Newbie

      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 ?