Problem in getting the datasource for mysql

[Mike Thomson]

I am trying to get the mysql datasource from servlet.
I have configured the datasource in mysql-ds.xml as follows:

<datasources>
  <local-tx-datasource>
    <jndi-name>MySqlDS</jndi-name>
    <connection-url>jdbc:mysql://mysql-hostname:3306/mysql</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>root</user-name>
    <password>root</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
    <!-- should only be used on drivers after 3.22.1 with "ping" support
    <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
    -->
    <!-- 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 - MySQLValidConnectionChecker is preferred for newer drivers
    <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      -->
 
    <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>

Then, I configured web.xml and jboss-web.xml as follows:

   <resource-ref>
    <description>DB Connection</description>
     <res-ref-name>jdbc/test</res-ref-name>
     <res-type>javax.sql.DataSource</res-type>
     <res-auth>Container</res-auth>
  </resource-ref>

    <resource-ref>
        <res-ref-name>jdbc/test</res-ref-name>
        <jndi-name>jdbc/test</jndi-name>
    </resource-ref>

In servlet, I am trying to get the datasource as follows:

 Context context = new InitialContext();
 DataSource ds = (DataSource)context.lookup("java:comp/env/jdbc/test"); 

But I am getting the followin exception:

19:38:42,137 ERROR [STDERR] javax.naming.NamingException: Could not dereference object [Root exception is javax.naming.NameNotFoundException: jdbc not bound]
19:38:42,139 ERROR [STDERR] at org.jnp.interfaces.NamingContext.resolveLink(NamingContext.java:1215)
19:38:42,139 ERROR [STDERR] at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:758)
19:38:42,139 ERROR [STDERR] at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:774)
19:38:42,144 ERROR [STDERR] at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:627)
19:38:42,144 ERROR [STDERR] at javax.naming.InitialContext.lookup(Unknown Source)
19:38:42,144 ERROR [STDERR] at com.web.ComputeServlet.init(ComputeServlet.java:73)
19:38:42,144 ERROR [STDERR] at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)
19:38:42,144 ERROR [STDERR] at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:806)
19:38:42,145 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:129)
19:38:42,145 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
19:38:42,145 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
19:38:42,145 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
19:38:42,146 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
19:38:42,146 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
19:38:42,146 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
19:38:42,146 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
19:38:42,147 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
19:38:42,147 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
19:38:42,147 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
19:38:42,147 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
19:38:42,148 ERROR [STDERR] at java.lang.Thread.run(Unknown Source)
19:38:42,149 ERROR [STDERR] Caused by: javax.naming.NameNotFoundException: jdbc not bound
19:38:42,150 ERROR [STDERR] at org.jnp.server.NamingServer.getBinding(NamingServer.java:529)
19:38:42,151 ERROR [STDERR] at org.jnp.server.NamingServer.getBinding(NamingServer.java:537)
19:38:42,151 ERROR [STDERR] at org.jnp.server.NamingServer.getObject(NamingServer.java:543)
19:38:42,151 ERROR [STDERR] at org.jnp.server.NamingServer.lookup(NamingServer.java:267)
19:38:42,151 ERROR [STDERR] at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:667)
19:38:42,152 ERROR [STDERR] at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:627)
19:38:42,152 ERROR [STDERR] at javax.naming.InitialContext.lookup(Unknown Source)
19:38:42,152 ERROR [STDERR] at org.jnp.interfaces.NamingContext.resolveLink(NamingContext.java:1209)
19:38:42,152 ERROR [STDERR] ... 20 more

Please help on it. And alos, I have another doubt, when will the objects are registered with JNDI. During deployment time, will the jboss app. server register the objects with JNDI on referring web.xml and ejb-jar.xml?
[ January 03, 2009: Message edited by: Mike Thomson ]

[Jaikiran Pai]

<resource-ref>
        <res-ref-name>jdbc/test</res-ref-name>
        <jndi-name>jdbc/test</jndi-name>
    </resource-ref>

The jndi-name is incorrect here. It should point to the JNDI name of the datasource. So it should be:

        <jndi-name>java:MySqlDS</jndi-name>

In your servlet, you can then lookup the resource at java:comp/env/jdbc/test