Did you by chance miss any quotes while correcting the typo of the displayed text?
Vijaya -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Vuyk Sent: Wednesday, June 07, 2006 5:38 PM To: users@tomcat.apache.org Subject: Re: Random NullPointerException when trying to connect to Datasource Still wondering if anyone has any thoughts on this. I appreciate any help. Brian On 6/6/06, Brian Vuyk <[EMAIL PROTECTED]> wrote: > I feel compelled to also mention that I have rebooted the system, with > still the same effect. > > On 6/6/06, Brian Vuyk <[EMAIL PROTECTED]> wrote: > > Hello. > > > > > > I am currently developing a JSP webapp for my employer, andhave run > > into a couple of serious problems. > > > > Randomly, tomcat seems to be losing it's ability to connect to the > > mySQL server running on the same server as Tomcat. > > > > Scenario: > > > > This morning I was using the webapp no problem. I made a small change > > to correct a typo in some displayed text, and then re-deployed the > > webapp. Upon attempting to log into the webapp I was unable to connect > > to the database. I recieved the below error. > > > > Steps Taken: > > > > I have restarted both Tomcat and mySQL, with no change. I have double > > checked my source code, and I do not think the issue is with the > > source itself. I have attempted re-deploying the webapp, including an > > archived, known good version. The result was the same exception posted > > above. > > > > I can log into the mySQL database from the command-line without any > > issue at all. > > > > Thank you in advance for any help. > > > > Brian Vuyk > > > > Tomcat error taken from logs.... > > ---------------------------------------------------------------------- > > 2006-06-06 05:06:42 StandardWrapperValve[jsp]: Servlet.service() for > > servlet jsp threw exception > > javax.servlet.jsp.JspException: Unable to get connection, DataSource > > invalid: "java.lang.NullPointerException" > > at org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection (QueryTagSupport.java:276) > > at org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(Qu eryTagSupport.java:159) > > at org.apache.jsp.jsp.authenticate_jsp._jspx_meth_sql_query_0(authenticate_ jsp.java:286) > > at org.apache.jsp.jsp.authenticate_jsp._jspService(authenticate_jsp.java:11 0) > > at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja va:324) > > at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) > > at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:237) > > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:157) > > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:214) > > at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo ntext.java:104) > > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 20) > > at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardCon textValve.java:198) > > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:152) > > at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo ntext.java:104) > > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 20) > > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :137) > > at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo ntext.java:104) > > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :117) > > at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo ntext.java:102) > > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 20) > > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:109) > > at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo ntext.java:104) > > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 20) > > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) > > at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) > > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:79 9) > > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC onnection(Http11Protocol.java:705) > > at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:57 7) > > at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .java:683) > > at java.lang.Thread.run(Thread.java:595) > > ------------------------------------------------------------------------ ------------------------ > > > > > > Version Information: > > ------------------------------------------------------------------------ ----------- > > Tomcat 5.5.17 > > ------------------------------------------------------------------------ ----------- > > mySQL: > > mysql> status > > -------------- > > mysql Ver 14.7 Distrib 4.1.19, for pc-linux-gnu (i686) using readline 5.1 > > > > Connection id: 1 > > Current database: > > Current user: [EMAIL PROTECTED] > > SSL: Not in use > > Current pager: /usr/bin/less > > Using outfile: '' > > Using delimiter: ; > > Server version: 4.1.19-log > > Protocol version: 10 > > Connection: Localhost via UNIX socket > > Server characterset: utf8 > > Db characterset: utf8 > > Client characterset: utf8 > > Conn. characterset: utf8 > > UNIX socket: /var/run/mysqld/mysqld.sock > > Uptime: 2 hours 33 min 8 sec > > > > Threads: 1 Questions: 5 Slow queries: 0 Opens: 11 Flush tables: 1 > > Open tables: 5 Queries per second avg: 0.001 > > ------------------------------------------------------- > > > > Here is my web.xml for this application: > > ------------------------------------------------------------------------ ----------- > > <?xml version="1.0" encoding="UTF-8"?> > > <web-app id="WebApp_ID" version="2.4" > > xmlns="http://java.sun.com/xml/ns/j2ee"; > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > > xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee > > http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd";> > > <display-name> > > Takedown App</display-name> > > <welcome-file-list> > > <welcome-file>index.jsp</welcome-file> > > </welcome-file-list> > > > > <!-- Database connection info start --> > > > > <context-param> > > <param-name> > > javax.servlet.jsp.jstl.sql.dataSource > > </param-name> > > <param-value> > > > > jdbc:mysql://localhost:3306/takedowns,com.mysql.jdbc.Driver,takedown,pas sword_removed > > </param-value> > > </context-param> > > </web-app> > > ------------------------------------------------------------------------ ----------- > > > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
