Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Received-SPF: pass (hermes.apache.org: domain of
 parsonstechnical@earthlink.net designates 209.86.89.69 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=simple;
  s=test1; d=earthlink.net;
  h=Message-ID:From:To:References:Subject:Date:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Priority:X-MSMail-Priority:X-Mailer:X-MimeOLE;
  b=Qthh3Gm6z1ZMScmN3pP5esoXBiTPfmbMWQDUFBl7BZSdI2JYr5QQBQs3IN2gk7Mh;
Message-ID: <03cd01c51ead$d24ca120$7a01a8c0@ptslaptop>
From: "Parsons Technical Services" <parsonstechnical@earthlink.net>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
References: <20050301172600.88380.qmail@web31009.mail.mud.yahoo.com>
        <4224E80C.8090107@mason-nh.net>
Subject: Re: newbie having problems with MySQL JDBC/JNDI Datasource example
Date: Tue, 1 Mar 2005 17:27:09 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit

Resource Link

http://jakarta.apache.org/tomcat/tomcat-5.0-doc/config/globalresources.html

http://jakarta.apache.org/tomcat/tomcat-5.0-doc/config/context.html#Resource%20Links

Doug


----- Original Message ----- 
From: "Darryl Wagoner" <darryl-prv@mason-nh.net>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Sent: Tuesday, March 01, 2005 5:09 PM
Subject: newbie having problems with MySQL JDBC/JNDI Datasource example


> 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: TrustedQSL@yahoogroups.com Subscribe: 
> TrustedQSL-subscribe@yahoogroups.com List owner: 
> TrustedQSL-owner@yahoogroups.com http://www.trustedQSL.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org