newbie having problems with MySQL JDBC/JNDI Datasource example

Darryl Wagoner Tue, 01 Mar 2005 14:09:20 -0800

Greetings,

Not sure if this made it the first time. I didn't see it show up on the list

I am trying to get the example in the MySQL JDBC/JNDI HOWTO to work and I am missing something.

I get this error:  My webapp directory is /DBTest.

What am I missing?

thanks

-darryl


--- Error Page ---

*type* Exception report

*message*

*description* _The server encountered an internal error () that prevented it from fulfilling this request._

*exception*

javax.servlet.ServletException: Unable to get connection, DataSource invalid: 
"org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class 
'' for connect URL 'null'"
        
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:845)
        
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778)
        org.apache.jsp.testDB_jsp._jspService(org.apache.jsp.testDB_jsp:81)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

*root cause*

javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: 
"org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class 
'' for connect URL 'null'"
        
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:276)
        
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:159)
        
org.apache.jsp.testDB_jsp._jspx_meth_sql_query_0(org.apache.jsp.testDB_jsp:100)
        org.apache.jsp.testDB_jsp._jspService(org.apache.jsp.testDB_jsp:58)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


--- Server.xml ---
<?xml version='1.0' encoding='utf-8'?>
<!-- $Id$ -->
<Server>

<Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"/> <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListen er"/> <GlobalNamingResources> <Environment name="simpleValue" type="java.lang.Integer" value="30"/> <Resource auth="Container" description="User database that can be updated an d saved" name="UserDatabase" type="org.apache.catalina.UserDatabase" pathname="conf/tomcat-users.xml" factory="org.apache.catalina.users.MemoryUs erDatabaseFactory"/>

 </GlobalNamingResources>

<Service name="Catalina"> <Connector port="8080" redirectPort="8443" maxSpareThreads="75" maxThreads="150" minSpareThreads="25"> </Connector> <Connector port="8081" proxyName="dax.shecora.com" proxyPort="80" redirectPort="8443" maxSpareThreads="75" maxThreads="150" minSpareThreads="25"> </Connector> <Connector port="8009" protocol="AJP/1.3" protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" redirectPort="8443"> </Connector>

<Engine defaultHost="localhost" name="Catalina"> <Host appBase="webapps" name="localhost"> <Context path="/DBTest" docBase="DBTest" debug="5"> reloadable="true" crossContext="true"> <Resource name="TestDB" type="javax.sql.DataSource" password="javadude" driverClassName="com.mysql.jdbc.Driver" maxIdle="2" maxWait="5000" username="javauser" url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true" maxActive="4"/> </Context>


--- web.xml ---
<?xml version="1.0" encoding="ISO-8859-1"?>

<!DOCTYPE web-app
   PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
   "http://java.sun.com/dtd/web-app_2_3.dtd";>

<web-app xmlns="http://java.sun.com/xml/ns/j2ee"; xmlns:xsi="http://www.w3.org/20 01/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ ns/j2ee/web-app_2_4.xsd" version="2.4"> <description>MySQL Test App</description> <resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/TestDB</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </web-app>


--
Darryl Wagoner - WA1GON

"Evil triumphs when good men do nothing."  - Edmund Burke [1729-1797]

Join the TrustedQSL mailing list.  An Open Source solution.
Post message: [EMAIL PROTECTED] Subscribe:  [EMAIL PROTECTED] List owner:  
[EMAIL PROTECTED] http://www.trustedQSL.org

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

newbie having problems with MySQL JDBC/JNDI Datasource example

Reply via email to