Re: newbie having problems with MySQL JDBC/JNDI Datasource example
No problem. Amazing what an extra set of eyes will catch, isn't it? Enjoy! David Darryl Wagoner wrote: David, I have been looking at this off and on for weeks and could not see the problem. I changed the context to be jdbc/TestDB and it worked. Thank you very much David Smith wrote: In your context definition, you have In your web.xml, you have jdbc/TestDB These two need to match. If one is jdbc/TestDB, so must the other. --David - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: newbie having problems with MySQL JDBC/JNDI Datasource example
David, I have been looking at this off and on for weeks and could not see the problem. I changed the context to be jdbc/TestDB and it worked. Thank you very much David Smith wrote: In your context definition, you have In your web.xml, you have jdbc/TestDB These two need to match. If one is jdbc/TestDB, so must the other. --David -- 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]
Re: newbie having problems with MySQL JDBC/JNDI Datasource example
In your context definition, you have In your web.xml, you have jdbc/TestDB These two need to match. If one is jdbc/TestDB, so must the other. --David Darryl Wagoner wrote: 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 --- name="UserDatabase" type="org.apache.catalina.UserDatabase" pathname="conf/tomcat-users.xml" factory="org.apache.catalina.users.MemoryUs erDatabaseFactory"/> redirectPort="8443" maxSpareThreads="75" maxThreads="150" minSpareThreads="25"> protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" redirectPort="8443"> reloadable="true" crossContext="true"> driverClassName="com.mysql.jdbc.Driver" maxIdle="2" maxWait="5000" username="javauser" url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true" maxActive="4"/> --- web.xml --- http://java.sun.com/dtd/web-app_2_3.dtd";> 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"> MySQL Test App DB Connection jdbc/TestDB javax.sql.DataSource Container - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: newbie having problems with MySQL JDBC/JNDI Datasource example
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" > > 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 --- > > > > > > > > > > > > > > > > > className="org.apache.catalina.mbeans.ServerLifecycleListener"/> > > > > > className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListen > > > er"/> > > > > > > > > > > >name="UserDatabase" type="org.apache.catalina.UserDatabase" > > >pathname="conf/tomcat-users.xml" > > > factory="org.apache.catalina.users.MemoryUs > > > erDatabaseFactory"/> > > > > > > > > > > &
Re: newbie having problems with MySQL JDBC/JNDI Datasource example
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" > 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 --- > > > > > > > > > > > className="org.apache.catalina.mbeans.ServerLifecycleListener"/> > > > className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListen > > er"/> > > > > > > >name="UserDatabase" type="org.apache.catalina.UserDatabase" > >pathname="conf/tomcat-users.xml" > > factory="org.apache.catalina.users.MemoryUs > > erDatabaseFactory"/> > > > > > > > > > > > maxThreads="150" minSpareThreads="25"> > > > > >redirectPort="8443" maxSpareThreads="75" maxThreads="150" > > minSpareThreads="25"> > > > > >protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" > > redirectPort="8443"> > > > > > > > > > > > > reloadable="true" crossContext="true"> > > > password="javadude" > > driverClassName=&qu
Re: newbie having problems with MySQL JDBC/JNDI Datasource example
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" 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 --- name="UserDatabase" type="org.apache.catalina.UserDatabase" pathname="conf/tomcat-users.xml" factory="org.apache.catalina.users.MemoryUs erDatabaseFactory"/> redirectPort="8443" maxSpareThreads="75" maxThreads="150" minSpareThreads="25"> protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" redirectPort="8443"> reloadable="true" crossContext="true"> driverClassName="com.mysql.jdbc.Driver" maxIdle="2" maxWait="5000" username="javauser" url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true" maxActive="4"/> --- web.xml --- http://java.sun.com/dtd/web-app_2_3.dtd";> 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"> MySQL Test App DB Connection jdbc/TestDB javax.sql.DataSource Container -- 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]
Re: newbie having problems with MySQL JDBC/JNDI Datasource example
>Sounds like it can't find the driver. Do you have the Connector/J jar installed in the correct place? Should be in common/lib. I think so! I have $CATALINA/common/lib/mysql-connector-java-3.0.16-ga-bin.jar which I believe to be the correct. I just downloaded and installed 3.1 with same result. thanks -- 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]
Re: newbie having problems with MySQL JDBC/JNDI Datasource example
Parsons Technical Services wrote: 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" <[EMAIL PROTECTED]> To: "Tomcat Users List" 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) Sounds like it can't find the driver. Do you have the Connector/J jar installed in the correct place? Should be in common/lib. -- Justin Crabtree Java Programmer Ozarks Technical Community College 447-7533 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: newbie having problems with MySQL JDBC/JNDI Datasource example
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" <[EMAIL PROTECTED]> To: "Tomcat Users List" 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 --- name="UserDatabase" type="org.apache.catalina.UserDatabase" pathname="conf/tomcat-users.xml" factory="org.apache.catalina.users.MemoryUs erDatabaseFactory"/> redirectPort="8443" maxSpareThreads="75" maxThreads="150" minSpareThreads="25"> protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" redirectPort="8443"> reloadable="true" crossContext="true"> driverClassName="com.mysql.jdbc.Driver" maxIdle="2" maxWait="5000" username="javauser" url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true" maxActive="4"/> --- web.xml --- http://java.sun.com/dtd/web-app_2_3.dtd";> 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"> MySQL Test App DB Connection jdbc/TestDB javax.sql.DataSource Container -- 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]
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 --- name="UserDatabase" type="org.apache.catalina.UserDatabase" pathname="conf/tomcat-users.xml" factory="org.apache.catalina.users.MemoryUs erDatabaseFactory"/> redirectPort="8443" maxSpareThreads="75" maxThreads="150" minSpareThreads="25"> protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" redirectPort="8443"> reloadable="true" crossContext="true"> driverClassName="com.mysql.jdbc.Driver" maxIdle="2" maxWait="5000" username="javauser" url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true" maxActive="4"/> --- web.xml --- http://java.sun.com/dtd/web-app_2_3.dtd";> 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"> MySQL Test App DB Connection jdbc/TestDB javax.sql.DataSource Container -- 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]
