From users-return-146362-apmail-tomcat-users-archive=tomcat.apache.org@tomcat.apache.org Wed Jun 07 12:24:23 2006 Return-Path: Delivered-To: apmail-tomcat-users-archive@www.apache.org Received: (qmail 23963 invoked from network); 7 Jun 2006 12:24:23 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 7 Jun 2006 12:24:23 -0000 Received: (qmail 24221 invoked by uid 500); 7 Jun 2006 12:24:08 -0000 Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org Received: (qmail 24203 invoked by uid 500); 7 Jun 2006 12:24:07 -0000 Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Tomcat Users List" Delivered-To: mailing list users@tomcat.apache.org Received: (qmail 24188 invoked by uid 99); 7 Jun 2006 12:24:07 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jun 2006 05:24:07 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [67.15.56.68] (HELO win2.interactivedns.com) (67.15.56.68) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jun 2006 05:24:06 -0700 Received: from yourdc2f5571f1 ([59.92.142.56]) by win2.interactivedns.com with MailEnable ESMTP; Wed, 07 Jun 2006 17:53:48 +0530 From: "Vijaya" To: "'Tomcat Users List'" Subject: RE: Random NullPointerException when trying to connect to Datasource Date: Wed, 7 Jun 2006 17:53:31 +0530 Message-ID: <000401c68a2d$35050280$6401a8c0@yourdc2f5571f1> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 In-Reply-To: <244a5c480606070508g7280babbqf90b275983f13e46@mail.gmail.com> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Did you by chance miss any quotes while correcting the typo of the displayed text? Vijaya -----Original Message----- From: brianvuyk@gmail.com [mailto:brianvuyk@gmail.com] 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 wrote: > I feel compelled to also mention that I have rebooted the system, with > still the same effect. > > On 6/6/06, Brian Vuyk 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: takedown@localhost > > 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: > > ------------------------------------------------------------------------ ----------- > > > > > 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"> > > > > Takedown App > > > > index.jsp > > > > > > > > > > > > > > javax.servlet.jsp.jstl.sql.dataSource > > > > > > > > jdbc:mysql://localhost:3306/takedowns,com.mysql.jdbc.Driver,takedown,pas sword_removed > > > > > > > > ------------------------------------------------------------------------ ----------- > > > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org For additional commands, e-mail: users-help@tomcat.apache.org --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org For additional commands, e-mail: users-help@tomcat.apache.org