tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brian Vuyk" <bv...@cs.redeemer.on.ca>
Subject Re: Random NullPointerException when trying to connect to Datasource
Date Wed, 07 Jun 2006 13:28:30 GMT
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 <svijiya@solutionscraft.com> wrote:
> 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 <bvuyk@cs.redeemer.on.ca> wrote:
> > I feel compelled to also mention that I have rebooted the system, with
> > still the same effect.
> >
> > On 6/6/06, Brian Vuyk <bvuyk@cs.redeemer.on.ca> 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:
> > >
> ------------------------------------------------------------------------
> -----------
> > > <?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: 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
>
>

---------------------------------------------------------------------
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


Mime
View raw message