I am using Tomcat 5.5.17. This appwas developed for this version of Tomcat, and worked on it until the morning that day, and has refused since. THere was no migration, though....
Thanks for the reply. On 6/8/06, Vijaya <[EMAIL PROTECTED]> wrote:
Then I think you are in the same boat as mine. I saw some other post also having trouble to connect to the data base when migrated from tomcat 5.0.28 to 5.0.17. What is your tomcat version? Regards, Vijaya -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Vuyk Sent: Wednesday, June 07, 2006 6:59 PM To: Tomcat Users List Subject: Re: Random NullPointerException when trying to connect to Datasource Thank you for your reply. Unfortunately, no, I did not. I have checked my JSP over a few times, and as far as I can tell, the syntax is correct. Also, this error does not occur only in a specific page - no connection to the databse works, regardless of the page. On 6/7/06, Vijaya <[EMAIL PROTECTED]> wrote: > 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] > > --------------------------------------------------------------------- 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]
--------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]