Woops, my bad, that's not it, I should have read the entire message :( Drew.
On Tue, 2005-03-01 at 18:51, Drew Jorgenson wrote: > 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'" > > what is your connection URL? it doesn't seem like you're supplying one > to the driver. If you're passing it as a string, make sure it's not > null. > > Drew. > > On Tue, 2005-03-01 at 17:31, Parsons Technical Services wrote: > > What version are you running of Tomcat? > > > > Did you put in your resource link? > > > > Doug > > > > > > ----- Original Message ----- > > From: "Darryl Wagoner" <[EMAIL PROTECTED]> > > 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: [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] > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
