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]
