4:01 p.m.
I just recently started playing with JBoss. I have been successful so far. But now I am
stuck on a datasource issue. I need to access a MySQL DB from a servlet to read/write xml
content.
Here is what I have so far:
mysql-ds.xml ?
<local-tx-datasource>
<jndi-name>jdbc/MySqlDS</jndi-name>
<use-java-context>false</use-java-context>
<connection-url>jdbc:mysql://localhost:3306/proxyServletDB</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
pword
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<type-mapping>mySQL</type-mapping>
</local-tx-datasource>
web.xml ?
<web-app>
<!-- JDBC DataSources (java:comp/env/jdbc) -->
<resource-ref>
The default DS
<res-ref-name>jdbc/MySqlDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
< ? >
</web-app>
jboss-web.xml ?
<jboss-web>
<resource-ref>
<res-ref-name>jdbc/MySqlDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<jndi-name>java:/MySqlDS</jndi-name>
</resource-ref>
</jboss-web>
Servlet ?
Context ctx = new InitialContext();
DataSource ds = DataSource)ctx.lookup("java:/comp/env/jdbc/MySqlDS");
I think these are the relevant files. I could access the datasource from the local jndi
namespace by using lookup(?java:/jdbc/MySqlDS?). But I need it to be global so that other
servlets, from other machines can use it. Which is when I added:
<use-java-context>false</use-java-context> to my mysql-ds.xml file so that the
default, local java:/ namespace won?t be used.
But now whenever the servlet is invoked I get the error that says MySqlDS not bound
(complete trace shown below).
Error I get when I try to invoke the servlet:
16:34:47,328 ERROR [STDERR] javax.naming.NamingException: Could not dereference object
[Root exception is javax.naming.N
ameNotFoundException: MySqlDS not bound]
16:34:47,328 ERROR [STDERR] at
org.jnp.interfaces.NamingContext.resolveLink(NamingContext.java:1067)
16:34:47,328 ERROR [STDERR] at
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:700)
16:34:47,328 ERROR [STDERR] at
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:716)
16:34:47,328 ERROR [STDERR] at
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:587)
16:34:47,328 ERROR [STDERR] at
javax.naming.InitialContext.lookup(InitialContext.java:351)
16:34:47,328 ERROR [STDERR] at ReadServlet.doGet(ReadServlet.java:28)
16:34:47,328 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
16:34:47,328 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
16:34:47,328 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterCha
in.java:252)
16:34:47,328 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
173)
16:34:47,328 ERROR [STDERR] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
16:34:47,328 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterCha
in.java:202)
16:34:47,328 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
173)
16:34:47,343 ERROR [STDERR] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
16:34:47,343 ERROR [STDERR] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
16:34:47,343 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValv
e.java:175)
16:34:47,343 ERROR [STDERR] at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
16:34:47,343 ERROR [STDERR] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
16:34:47,343 ERROR [STDERR] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
16:34:47,343 ERROR [STDERR] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
16:34:47,343 ERROR [STDERR] at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
16:34:47,343 ERROR [STDERR] at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
16:34:47,343 ERROR [STDERR] at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
(Http11BaseProtocol.java:664)
16:34:47,343 ERROR [STDERR] at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
16:34:47,343 ERROR [STDERR] at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:1
12)
16:34:47,343 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
16:34:47,343 ERROR [STDERR] Caused by: javax.naming.NameNotFoundException: MySqlDS not
bound
16:34:47,343 ERROR [STDERR] at
org.jnp.server.NamingServer.getBinding(NamingServer.java:529)
16:34:47,343 ERROR [STDERR] at
org.jnp.server.NamingServer.getBinding(NamingServer.java:537)
16:34:47,343 ERROR [STDERR] at
org.jnp.server.NamingServer.getObject(NamingServer.java:543)
16:34:47,343 ERROR [STDERR] at
org.jnp.server.NamingServer.lookup(NamingServer.java:296)
16:34:47,343 ERROR [STDERR] at
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:625)
16:34:47,343 ERROR [STDERR] at
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:587)
16:34:47,343 ERROR [STDERR] at
javax.naming.InitialContext.lookup(InitialContext.java:351)
16:34:47,343 ERROR [STDERR] at
org.jnp.interfaces.NamingContext.resolveLink(NamingContext.java:1061)
16:34:47,343 ERROR [STDERR] ... 25 more
service=jndiview ?
+- jdbc (class: org.jnp.interfaces.NamingContext)
| +- MySqlDS (class: javax.sql.DataSource)
Any ideas/suggestions? I?ve been stuck on this thing for almost 3 days now.
Thanks!
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3961642#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...