RE: It would be great IF somebody answered me, ONCE, for change :(

[micael]

Here you go, as per request.  You will have to fiddle a bit to get what is 
going on, but not much.  The methods return the object so you can debug as 
follows:  new Debugger().add(blah1).add(blah2).add(blah3).log("Testing the 
Back Forty", true); which will do what is specified.  Set up the paths 
however is best for you.  I give this to students.  When I use it, I name 
it REMOVE_ME.java.  Good luck!

Micael

At 09:59 AM 8/19/2002 -0700, you wrote:
>It is always nice to have an extra debugger handy :) I
>am testing JTest but am not sure it is really what I
>need. I would appreciate your help if you can send me
>yours.
>
>Thank you in advance.
>
>--- micael <[EMAIL PROTECTED]> wrote:
> > If you have a debugger, all you have to do is to
> > follow the bouncing ball
> > and find the null reference.  That will be the
> > fastest way to find this
> > problem.  It should not take long.  If you don't
> > have a debugger, I will
> > send you one I made to use, and I like better than
> > the standard debuggers.
> >
> > At 08:49 AM 8/19/2002 -0700, you wrote:
> > >I am sorry, but I did not get what you mean with
> > >connection limit to be a hard limit, which one is
> > >that?
> > >
> > >I am including a copy of my pool.xml if you care do
> > >point out what should be changed.
> > >
> > >Thank you in advance.
> > >
> > > Pool.xml =
> > >
> > >
> > >
> > >
> > >   local
> > >
> > >   
> > >
> > > 
> > > 
> > > 
> > >
> > > 
> > >
> > > webdev
> > > webdev
> > > org.postgresql.Driver
> > >
> > jdbc:postgresql://localhost:6093/webdev
> > >
> > > JustAUserName
> > > JustAUserNamePassword
> > >
> > > 
> > > true
> > >
> > > 1
> > > 10
> > > 600
> > > 12
> > > 10
> > >
> > >
> >
> >/usr/local/tomcat/logs/poolman.log
> > > false
> > >
> > > 
> > >
> > > false
> > > 20
> > >
> > 120
> > >
> > >   
> > >
> > >
> > >
> > > End Pool.xml =
> > >--- Mike Jackson <[EMAIL PROTECTED]> wrote:
> > > > Actually now that I think about it more that
> > might
> > > > be the cause of the null
> > > > pointer (but
> > > > probably not).  In your poolman.xml file have
> > you
> > > > set the connection limit
> > > > to be a hard
> > > > limit?  If you timeout on connections (user
> > timeout)
> > > > is fairly high you
> > > > could run out of
> > > > connections, and it might return a "null"
> > instead of
> > > > a connection.
> > > >
> > > > But that's just a guess.  Also, you might was to
> > > > also turn on logging (debug
> > > > level) in
> > > > poolman as well so that you can watch the
> > > > connections getting checked out
> > > > and in.
> > > >
> > > > --mikej
> > > > -=-
> > > > mike jackson
> > > > [EMAIL PROTECTED]
> > > >
> > > > > -Original Message-
> > > > > From: Luminous Heart
> > > > [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Monday, August 19, 2002 8:36 AM
> > > > > To: Tomcat Users List
> > > > > Subject: Re: It would be great IF somebody
> > > > answered me, ONCE, for change
> > > > > :(
> > > > >
> > > > >
> > > > > Hi Graig,
> > > > > Here is my jsp file. I am not sure what might
> > be
> > > > > wrong. Although the same error happens in a
> > bigger
> > > > > application in a tc cluster of 3 tomcats. Two
> > of
> > > > these
> > > > > tcs fail while one does not get any forwards
> > after
> > > > > that.
> > > > >
> > > > > Please take a look at my code, if you do not
> > mind.
> > > > >
> > > > > Best regards.
> > > > >
> > > > > = JSP
> > ==

Re: It would be great IF somebody answered me, ONCE, for change :(

[Carrie Salazar]

hey, can i get a copy of the debugger?  or do others have
any debugger suggestions?

tomcat error messages are pretty cryptic to me still, though
for the simple JSP work i do i get around it most of the time.
but perhaps a debugger will save me some hair pulling.
--
carrie s.

On Mon, Aug 19, 2002 at 09:53:02AM -0700, micael wrote:
> If you have a debugger, all you have to do is to follow the bouncing ball 
> and find the null reference.  That will be the fastest way to find this 
> problem.  It should not take long.  If you don't have a debugger, I will 
> send you one I made to use, and I like better than the standard debuggers.
> 
> At 08:49 AM 8/19/2002 -0700, you wrote:
> >I am sorry, but I did not get what you mean with
> >connection limit to be a hard limit, which one is
> >that?
> >
> >I am including a copy of my pool.xml if you care do
> >point out what should be changed.
> >
> >Thank you in advance.

--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

RE: It would be great IF somebody answered me, ONCE, for change :(

[Mike Jackson]

It can, and then you'd have other problems.  I use oracle here and
even though I'm licensed for x connections the database hasn't
yet failed to give me a connection at high load times.  I've got
my scavenge count fairly high with only a 2 minute timeout on the
connections in the pool (user timeout is more).  Seems to work
pretty well for me.  Much better than that connection pool that I
wrote.

--mikej
-=-
mike jackson
[EMAIL PROTECTED]

> -Original Message-
> From: Luminous Heart [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 19, 2002 9:58 AM
> To: Tomcat Users List
> Subject: RE: It would be great IF somebody answered me, ONCE, for change
> :(
>
>
> Thank you Mike,
> I will test with this, although I tried to
> troubleshoot the problem by going back to an older
> version of poolman. It worked. Now I will try your
> solution, that might help. But would the softlimiting
> of the pool run my server out of sockets in case of
> heavy access?
>
>
> --- Mike Jackson <[EMAIL PROTECTED]> wrote:
> > Add the following and the limit will be a soft limit
> > (it can go above as
> > needed)
> >
> > true
> >
> >
> > --mikej
> > -=-
> > mike jackson
> > [EMAIL PROTECTED]
> >
> > > -Original Message-----
> > > From: Luminous Heart
> > [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, August 19, 2002 8:50 AM
> > > To: Tomcat Users List
> > > Subject: RE: It would be great IF somebody
> > answered me, ONCE, for change
> > > :(
> > >
> > >
> > > I am sorry, but I did not get what you mean with
> > > connection limit to be a hard limit, which one is
> > > that?
> > >
> > > I am including a copy of my pool.xml if you care
> > do
> > > point out what should be changed.
> > >
> > > Thank you in advance.
> > >
> > >  Pool.xml
> > =
> > > 
> > >
> > > 
> > >
> > >   local
> > >
> > >   
> > >
> > > 
> > > 
> > > 
> > >
> > > 
> > >
> > > webdev
> > > webdev
> > > org.postgresql.Driver
> > >
> > jdbc:postgresql://localhost:6093/webdev
> > >
> > > JustAUserName
> > > JustAUserNamePassword
> > >
> > > 
> > > true
> > >
> > > 1
> > > 10
> > > 600
> > > 12
> > > 10
> > >
> > >
> > >
> >
> /usr/local/tomcat/logs/poolman.log
> > > false
> > >
> > > 
> > >
> > > false
> > > 20
> > >
> > 120
> > >
> > >   
> > >
> > > 
> > >
> > >  End Pool.xml
> > =
> > > --- Mike Jackson <[EMAIL PROTECTED]> wrote:
> > > > Actually now that I think about it more that
> > might
> > > > be the cause of the null
> > > > pointer (but
> > > > probably not).  In your poolman.xml file have
> > you
> > > > set the connection limit
> > > > to be a hard
> > > > limit?  If you timeout on connections (user
> > timeout)
> > > > is fairly high you
> > > > could run out of
> > > > connections, and it might return a "null"
> > instead of
> > > > a connection.
> > > >
> > > > But that's just a guess.  Also, you might was to
> > > > also turn on logging (debug
> > > > level) in
> > > > poolman as well so that you can watch the
> > > > connections getting checked out
> > > > and in.
> > > >
> > > > --mikej
> > > > -=-
> > > > mike jackson
> > > > [EMAIL PROTECTED]
> > > >
> > > > > -Original Message-
> > > > > From: Luminous Heart
> > > > [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Monday, August 19, 2002 8:36 AM
> > > > > To: Tomcat Users List
> > > > > Subject: Re: It would be great IF somebody
> > > > answered me, ONCE, for change
> > > > > :(
> > > > >
> > > > >
> > > > > Hi Graig,
> > > > > Here is my jsp file. I am not sure what might
> > be
> > > > > wrong. Alth

Re: It would be great IF somebody answered me, ONCE, for change :(

[Luminous Heart]

Thank you Paul. I know we are NOT paid to help
eachother, but hey, maybe someday I would be able to
lend a hand. This is how a great software like Apache
is putting a wide smile on all our faces.

Regards.

--- Paul McGovern <[EMAIL PROTECTED]> wrote:
> 
> Sorry, but you haven't included enough information
> for anyone to formulate an 
> answer. Based on the information all I can say is
> that you have a null 
> pointer exception. If you want a proper response,
> please include the code 
> segment that is going wrong, and config info from
> server.xml and web.xml.
> 
> Also please bear in mind that nobody here, AFAIK, is
> being paid to answer.
> 
> 
> On Monday 19 August 2002 11:14, you wrote:
> > I keep on asking this question but noone helps. Is
> it
> > a bug in TC?
> >
> > Why do I get NullPointerException? If I press
> refresh
> > a couple of times I would go through.
> >
> > 2002-08-19 00:53:32 StandardWrapperValve[jsp]:
> > Servlet.service() for servlet jsp threw exception
> > java.lang.NullPointerException
> > at
> >
>
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:61)
> > at
> >
>
org.postgresql.Connection.ExecSQL(Connection.java:398)
> > at
> >
>
org.postgresql.jdbc2.Statement.execute(Statement.java:130)
> > at
> >
>
org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
> > at
> >
>
org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:
> >99) at
> >
>
com.codestudio.sql.PoolManPreparedStatement.executeQuery(Unknown
> > Source)
> > at
> >
>
org.apache.jsp.AccountAccess$jsp._jspService(AccountAccess$jsp.java:207)
> > at
> >
>
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
> > at
> >
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> > at
> >
>
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.j
> >ava:201) at
> >
>
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
> > at
> >
>
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
> > at
> >
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> > at
> >
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio
> >nFilterChain.java:247) at
> >
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC
> >hain.java:193) at
> >
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j
> >ava:243) at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
> >566) at
> >
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> > at
> >
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> > at
> >
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j
> >ava:190) at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
> >566) at
> >
>
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBas
> >e.java:531) at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
> >564) at
> >
>
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:
> >246) at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
> >564) at
> >
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> > at
> >
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> > at
> >
>
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
> > at
> >
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:18
> >0) at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
> >566) at
> >
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve
> >.java:170) at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
> >564) at
> >
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:17
> >0) at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
> >564) at
> >
>
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
> >564) at
> >
>
org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:392
> >) at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
> >564) at
> >
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> > at
> >
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> > at
> >
>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav
> >a:174) at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
> >566) at
> >
>
org.apache.catalina.core.StandardPipeline.invoke(Stan

RE: It would be great IF somebody answered me, ONCE, for change :(

[Luminous Heart]

It is always nice to have an extra debugger handy :) I
am testing JTest but am not sure it is really what I
need. I would appreciate your help if you can send me
yours.

Thank you in advance.

--- micael <[EMAIL PROTECTED]> wrote:
> If you have a debugger, all you have to do is to
> follow the bouncing ball 
> and find the null reference.  That will be the
> fastest way to find this 
> problem.  It should not take long.  If you don't
> have a debugger, I will 
> send you one I made to use, and I like better than
> the standard debuggers.
> 
> At 08:49 AM 8/19/2002 -0700, you wrote:
> >I am sorry, but I did not get what you mean with
> >connection limit to be a hard limit, which one is
> >that?
> >
> >I am including a copy of my pool.xml if you care do
> >point out what should be changed.
> >
> >Thank you in advance.
> >
> > Pool.xml =
> >
> >
> >
> >
> >   local
> >
> >   
> >
> > 
> > 
> > 
> >
> > 
> >
> > webdev
> > webdev
> > org.postgresql.Driver
> >
> jdbc:postgresql://localhost:6093/webdev
> >
> > JustAUserName
> > JustAUserNamePassword
> >
> > 
> > true
> >
> > 1
> > 10
> > 600
> > 12
> > 10
> >
> >
>
>/usr/local/tomcat/logs/poolman.log
> > false
> >
> > 
> >
> > false
> > 20
> >
> 120
> >
> >   
> >
> >
> >
> > End Pool.xml =
> >--- Mike Jackson <[EMAIL PROTECTED]> wrote:
> > > Actually now that I think about it more that
> might
> > > be the cause of the null
> > > pointer (but
> > > probably not).  In your poolman.xml file have
> you
> > > set the connection limit
> > > to be a hard
> > > limit?  If you timeout on connections (user
> timeout)
> > > is fairly high you
> > > could run out of
> > > connections, and it might return a "null"
> instead of
> > > a connection.
> > >
> > > But that's just a guess.  Also, you might was to
> > > also turn on logging (debug
> > > level) in
> > > poolman as well so that you can watch the
> > > connections getting checked out
> > > and in.
> > >
> > > --mikej
> > > -=-
> > > mike jackson
> > > [EMAIL PROTECTED]
> > >
> > > > -Original Message-
> > > > From: Luminous Heart
> > > [mailto:[EMAIL PROTECTED]]
> > > > Sent: Monday, August 19, 2002 8:36 AM
> > > > To: Tomcat Users List
> > > > Subject: Re: It would be great IF somebody
> > > answered me, ONCE, for change
> > > > :(
> > > >
> > > >
> > > > Hi Graig,
> > > > Here is my jsp file. I am not sure what might
> be
> > > > wrong. Although the same error happens in a
> bigger
> > > > application in a tc cluster of 3 tomcats. Two
> of
> > > these
> > > > tcs fail while one does not get any forwards
> after
> > > > that.
> > > >
> > > > Please take a look at my code, if you do not
> mind.
> > > >
> > > > Best regards.
> > > >
> > > > = JSP
> =
> > > > <%@ page import="java.io.*" %>
> > > > <%@ page import="java.util.*" %>
> > > > <%@ page import="java.text.*" %>
> > > >
> > > > <%@ page import="java.util.Properties" %>
> > > > <%@ page import="java.util.Date" %>
> > > >
> > > > <%@ page contentType="text/html"%>
> > > >
> > > > <%@ page import="com.codestudio.util.*"%>
> > > > <%@ page import="java.sql.*"%>
> > > >
> > > > 
> > > >
> > > >  > > > name="access_form">
> > > >   
> > > >   
> > > >   
> > >  > > > size=5>User Access
> > > >
> > > >  
> > > >  
> > > >  
> > > >   
> > > >   
> > > > 
> > > > 
> > > >> > border=0>
> > > > 
>  > > > size=5>User Access by userid
> > > > 
> > > >   
> User
> > > > Name
> > > >  > > name="byusername"
> > > > size=25 value=""  maxlength=25>
> > > >   
> > > > 
> > > >   
> > > > 
> > > > 
> > > > 
> > > > 
> > > >> > border=0>
> > > > 
>  > > > size=5>User Access by Date > > size=1>
> > > > 
> > > > 
> > > >Date
> > > >  name="bydate"
> > > > value="" size=25  maxlength=125>
> > > > 
> > > >   
> > > > 
> > > >   
> > > > 
> > > > 
> > > > 
> > > > 
> > > >> > border=0>
> > > > 
>  > > > size=5>USER Access by IP Address
> > > > 
> > > > 
> 
=== message truncated ===


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

RE: It would be great IF somebody answered me, ONCE, for change :(

[Luminous Heart]

Thank you Mike,
I will test with this, although I tried to
troubleshoot the problem by going back to an older
version of poolman. It worked. Now I will try your
solution, that might help. But would the softlimiting
of the pool run my server out of sockets in case of
heavy access?


--- Mike Jackson <[EMAIL PROTECTED]> wrote:
> Add the following and the limit will be a soft limit
> (it can go above as
> needed)
> 
> true
> 
> 
> --mikej
> -=-
> mike jackson
> [EMAIL PROTECTED]
> 
> > -Original Message-
> > From: Luminous Heart
> [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, August 19, 2002 8:50 AM
> > To: Tomcat Users List
> > Subject: RE: It would be great IF somebody
> answered me, ONCE, for change
> > :(
> >
> >
> > I am sorry, but I did not get what you mean with
> > connection limit to be a hard limit, which one is
> > that?
> >
> > I am including a copy of my pool.xml if you care
> do
> > point out what should be changed.
> >
> > Thank you in advance.
> >
> >  Pool.xml
> =
> > 
> >
> > 
> >
> >   local
> >
> >   
> >
> > 
> > 
> > 
> >
> > 
> >
> > webdev
> > webdev
> > org.postgresql.Driver
> >
> jdbc:postgresql://localhost:6093/webdev
> >
> > JustAUserName
> > JustAUserNamePassword
> >
> > 
> > true
> >
> > 1
> > 10
> > 600
> > 12
> > 10
> >
> >
> >
>
/usr/local/tomcat/logs/poolman.log
> > false
> >
> > 
> >
> > false
> > 20
> >
> 120
> >
> >   
> >
> > 
> >
> >  End Pool.xml
> =
> > --- Mike Jackson <[EMAIL PROTECTED]> wrote:
> > > Actually now that I think about it more that
> might
> > > be the cause of the null
> > > pointer (but
> > > probably not).  In your poolman.xml file have
> you
> > > set the connection limit
> > > to be a hard
> > > limit?  If you timeout on connections (user
> timeout)
> > > is fairly high you
> > > could run out of
> > > connections, and it might return a "null"
> instead of
> > > a connection.
> > >
> > > But that's just a guess.  Also, you might was to
> > > also turn on logging (debug
> > > level) in
> > > poolman as well so that you can watch the
> > > connections getting checked out
> > > and in.
> > >
> > > --mikej
> > > -=-
> > > mike jackson
> > > [EMAIL PROTECTED]
> > >
> > > > -Original Message-
> > > > From: Luminous Heart
> > > [mailto:[EMAIL PROTECTED]]
> > > > Sent: Monday, August 19, 2002 8:36 AM
> > > > To: Tomcat Users List
> > > > Subject: Re: It would be great IF somebody
> > > answered me, ONCE, for change
> > > > :(
> > > >
> > > >
> > > > Hi Graig,
> > > > Here is my jsp file. I am not sure what might
> be
> > > > wrong. Although the same error happens in a
> bigger
> > > > application in a tc cluster of 3 tomcats. Two
> of
> > > these
> > > > tcs fail while one does not get any forwards
> after
> > > > that.
> > > >
> > > > Please take a look at my code, if you do not
> mind.
> > > >
> > > > Best regards.
> > > >
> > > > = JSP
> =
> > > > <%@ page import="java.io.*" %>
> > > > <%@ page import="java.util.*" %>
> > > > <%@ page import="java.text.*" %>
> > > >
> > > > <%@ page import="java.util.Properties" %>
> > > > <%@ page import="java.util.Date" %>
> > > >
> > > > <%@ page contentType="text/html"%>
> > > >
> > > > <%@ page import="com.codestudio.util.*"%>
> > > > <%@ page import="java.sql.*"%>
> > > >
> > > > 
> > > >
> > > >  > > > name="access_form">
> > > >   
> > > >   
> > > >   
> > >  > > > size=5>User Access
> > > >
> > > >  
> > > >  
> > > >  
> > > >   
> > > >   
> > > > 
> > > > 
> > > >> > border=0>
> > > > 
>  > > > size=5>User Access by userid
> > > > 
> > > >   
> User
> > > > Name
> > > >  > > name="byusername"
> > > > size=25 value=""  maxlength=25>
> > > >   
> > > > 
> > > >   
> > > > 
> > > > 
> > > > 
> > > > 
> > > >> > border=0>
> > > > 
>  > > > size=5>User Access by Date > > size=1>
> > > > 
> > > > 
> > > >Date
> > > >  name="bydate"
> 
=== message truncated ===


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

RE: It would be great IF somebody answered me, ONCE, for change :(

[micael]

If you have a debugger, all you have to do is to follow the bouncing ball 
and find the null reference.  That will be the fastest way to find this 
problem.  It should not take long.  If you don't have a debugger, I will 
send you one I made to use, and I like better than the standard debuggers.

At 08:49 AM 8/19/2002 -0700, you wrote:
>I am sorry, but I did not get what you mean with
>connection limit to be a hard limit, which one is
>that?
>
>I am including a copy of my pool.xml if you care do
>point out what should be changed.
>
>Thank you in advance.
>
> Pool.xml =
>
>
>
>
>   local
>
>   
>
> 
> 
> 
>
> 
>
> webdev
> webdev
> org.postgresql.Driver
> jdbc:postgresql://localhost:6093/webdev
>
> JustAUserName
> JustAUserNamePassword
>
> 
> true
>
> 1
> 10
> 600
> 12
> 10
>
>
>/usr/local/tomcat/logs/poolman.log
> false
>
> 
>
> false
> 20
> 120
>
>   
>
>
>
> End Pool.xml =
>--- Mike Jackson <[EMAIL PROTECTED]> wrote:
> > Actually now that I think about it more that might
> > be the cause of the null
> > pointer (but
> > probably not).  In your poolman.xml file have you
> > set the connection limit
> > to be a hard
> > limit?  If you timeout on connections (user timeout)
> > is fairly high you
> > could run out of
> > connections, and it might return a "null" instead of
> > a connection.
> >
> > But that's just a guess.  Also, you might was to
> > also turn on logging (debug
> > level) in
> > poolman as well so that you can watch the
> > connections getting checked out
> > and in.
> >
> > --mikej
> > -=-
> > mike jackson
> > [EMAIL PROTECTED]
> >
> > > -Original Message-
> > > From: Luminous Heart
> > [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, August 19, 2002 8:36 AM
> > > To: Tomcat Users List
> > > Subject: Re: It would be great IF somebody
> > answered me, ONCE, for change
> > > :(
> > >
> > >
> > > Hi Graig,
> > > Here is my jsp file. I am not sure what might be
> > > wrong. Although the same error happens in a bigger
> > > application in a tc cluster of 3 tomcats. Two of
> > these
> > > tcs fail while one does not get any forwards after
> > > that.
> > >
> > > Please take a look at my code, if you do not mind.
> > >
> > > Best regards.
> > >
> > > = JSP =
> > > <%@ page import="java.io.*" %>
> > > <%@ page import="java.util.*" %>
> > > <%@ page import="java.text.*" %>
> > >
> > > <%@ page import="java.util.Properties" %>
> > > <%@ page import="java.util.Date" %>
> > >
> > > <%@ page contentType="text/html"%>
> > >
> > > <%@ page import="com.codestudio.util.*"%>
> > > <%@ page import="java.sql.*"%>
> > >
> > > 
> > >
> > >  > > name="access_form">
> > >   
> > >   
> > >   
> >  > > size=5>User Access
> > >
> > >  
> > >  
> > >  
> > >   
> > >   
> > > 
> > > 
> > >> border=0>
> > >   > > size=5>User Access by userid
> > > 
> > >User
> > > Name
> > >  > name="byusername"
> > > size=25 value=""  maxlength=25>
> > >   
> > > 
> > >   
> > > 
> > > 
> > > 
> > > 
> > >> border=0>
> > >   > > size=5>User Access by Date > size=1>
> > > 
> > > 
> > >Date
> > >  > > value="" size=25  maxlength=125>
> > > 
> > >   
> > > 
> > >   
> > > 
> > > 
> > > 
> > > 
> > >> border=0>
> > >   > > size=5>

Re: It would be great IF somebody answered me, ONCE, for change :(

[micael]

You are getting a null pointer exception because one of your variables 
referencing an object has not been instantiated and has a null value.  That 
is the answer to your question.

At 08:14 AM 8/19/2002 -0700, you wrote:
>I keep on asking this question but noone helps. Is it
>a bug in TC?
>
>Why do I get NullPointerException? If I press refresh
>a couple of times I would go through.
>
>2002-08-19 00:53:32 StandardWrapperValve[jsp]:
>Servlet.service() for servlet jsp threw exception
>java.lang.NullPointerException
> at
>org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:61)
> at
>org.postgresql.Connection.ExecSQL(Connection.java:398)
> at
>org.postgresql.jdbc2.Statement.execute(Statement.java:130)
> at
>org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
> at
>org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:99)
> at
>com.codestudio.sql.PoolManPreparedStatement.executeQuery(Unknown
>Source)
> at
>org.apache.jsp.AccountAccess$jsp._jspService(AccountAccess$jsp.java:207)
> at
>org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
> at
>javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
> at
>org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
> at
>org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
> at
>javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
> at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
> at
>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
> at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
> at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:531)
> at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
> at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
> at
>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
> at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
>org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
> at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
> at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:392)
> at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
> at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:458)
> at
>org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:551)
> at java.lang.Thread.run(Thread.java:536)
>
>
>
>__
>Do You Yahoo!?
>HotJobs - Search Thousands of New Jobs
>http://www.hotjobs.com
>
>--
>To unsubscribe, e-mail:   
>For additional commands, e-mail: 



--
To unsubscribe, e-mail:   

RE: It would be great IF somebody answered me, ONCE, for change :(

[Mike Jackson]

Add the following and the limit will be a soft limit (it can go above as
needed)

true


--mikej
-=-
mike jackson
[EMAIL PROTECTED]

> -Original Message-
> From: Luminous Heart [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 19, 2002 8:50 AM
> To: Tomcat Users List
> Subject: RE: It would be great IF somebody answered me, ONCE, for change
> :(
>
>
> I am sorry, but I did not get what you mean with
> connection limit to be a hard limit, which one is
> that?
>
> I am including a copy of my pool.xml if you care do
> point out what should be changed.
>
> Thank you in advance.
>
>  Pool.xml =
> 
>
> 
>
>   local
>
>   
>
> 
> 
> 
>
> 
>
> webdev
> webdev
> org.postgresql.Driver
> jdbc:postgresql://localhost:6093/webdev
>
> JustAUserName
> JustAUserNamePassword
>
> 
> true
>
> 1
> 10
> 600
> 12
> 10
>
>
> /usr/local/tomcat/logs/poolman.log
> false
>
> 
>
> false
> 20
> 120
>
>   
>
> 
>
>  End Pool.xml =
> --- Mike Jackson <[EMAIL PROTECTED]> wrote:
> > Actually now that I think about it more that might
> > be the cause of the null
> > pointer (but
> > probably not).  In your poolman.xml file have you
> > set the connection limit
> > to be a hard
> > limit?  If you timeout on connections (user timeout)
> > is fairly high you
> > could run out of
> > connections, and it might return a "null" instead of
> > a connection.
> >
> > But that's just a guess.  Also, you might was to
> > also turn on logging (debug
> > level) in
> > poolman as well so that you can watch the
> > connections getting checked out
> > and in.
> >
> > --mikej
> > -=-
> > mike jackson
> > [EMAIL PROTECTED]
> >
> > > -Original Message-
> > > From: Luminous Heart
> > [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, August 19, 2002 8:36 AM
> > > To: Tomcat Users List
> > > Subject: Re: It would be great IF somebody
> > answered me, ONCE, for change
> > > :(
> > >
> > >
> > > Hi Graig,
> > > Here is my jsp file. I am not sure what might be
> > > wrong. Although the same error happens in a bigger
> > > application in a tc cluster of 3 tomcats. Two of
> > these
> > > tcs fail while one does not get any forwards after
> > > that.
> > >
> > > Please take a look at my code, if you do not mind.
> > >
> > > Best regards.
> > >
> > > = JSP =
> > > <%@ page import="java.io.*" %>
> > > <%@ page import="java.util.*" %>
> > > <%@ page import="java.text.*" %>
> > >
> > > <%@ page import="java.util.Properties" %>
> > > <%@ page import="java.util.Date" %>
> > >
> > > <%@ page contentType="text/html"%>
> > >
> > > <%@ page import="com.codestudio.util.*"%>
> > > <%@ page import="java.sql.*"%>
> > >
> > > 
> > >
> > >  > > name="access_form">
> > >   
> > >   
> > >   
> >  > > size=5>User Access
> > >
> > >  
> > >  
> > >  
> > >   
> > >   
> > > 
> > > 
> > >> border=0>
> > >   > > size=5>User Access by userid
> > > 
> > >User
> > > Name
> > >  > name="byusername"
> > > size=25 value=""  maxlength=25>
> > >   
> > > 
> > >   
> > > 
> > > 
> > > 
> > > 
> > >> border=0>
> > >   > > size=5>User Access by Date > size=1>
> > > 
> > > 
> > >Date
> > >  > > value="" size=25  maxlength=125>
> > > 
> > >   
> > > 
> > >   
> > > 
> > > 
> > > 
> > > 
> > >> border=0>
&

RE: It would be great IF somebody answered me, ONCE, for change :(

[Luminous Heart]

I am sorry, but I did not get what you mean with 
connection limit to be a hard limit, which one is
that?

I am including a copy of my pool.xml if you care do
point out what should be changed.

Thank you in advance.

 Pool.xml =




  local

  







webdev
webdev
org.postgresql.Driver
jdbc:postgresql://localhost:6093/webdev

JustAUserName
JustAUserNamePassword


true

1
10
600
12
10

   
/usr/local/tomcat/logs/poolman.log
false



false
20
120

  



 End Pool.xml =
--- Mike Jackson <[EMAIL PROTECTED]> wrote:
> Actually now that I think about it more that might
> be the cause of the null
> pointer (but
> probably not).  In your poolman.xml file have you
> set the connection limit
> to be a hard
> limit?  If you timeout on connections (user timeout)
> is fairly high you
> could run out of
> connections, and it might return a "null" instead of
> a connection.
> 
> But that's just a guess.  Also, you might was to
> also turn on logging (debug
> level) in
> poolman as well so that you can watch the
> connections getting checked out
> and in.
> 
> --mikej
> -=-
> mike jackson
> [EMAIL PROTECTED]
> 
> > -Original Message-
> > From: Luminous Heart
> [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, August 19, 2002 8:36 AM
> > To: Tomcat Users List
> > Subject: Re: It would be great IF somebody
> answered me, ONCE, for change
> > :(
> >
> >
> > Hi Graig,
> > Here is my jsp file. I am not sure what might be
> > wrong. Although the same error happens in a bigger
> > application in a tc cluster of 3 tomcats. Two of
> these
> > tcs fail while one does not get any forwards after
> > that.
> >
> > Please take a look at my code, if you do not mind.
> >
> > Best regards.
> >
> > = JSP =
> > <%@ page import="java.io.*" %>
> > <%@ page import="java.util.*" %>
> > <%@ page import="java.text.*" %>
> >
> > <%@ page import="java.util.Properties" %>
> > <%@ page import="java.util.Date" %>
> >
> > <%@ page contentType="text/html"%>
> >
> > <%@ page import="com.codestudio.util.*"%>
> > <%@ page import="java.sql.*"%>
> >
> > 
> >
> >  > name="access_form">
> >   
> >   
> >   
>  > size=5>User Access
> >
> >  
> >  
> >  
> >   
> >   
> > 
> > 
> >border=0>
> >   > size=5>User Access by userid
> > 
> >User
> > Name
> >  name="byusername"
> > size=25 value=""  maxlength=25>
> >   
> > 
> >   
> > 
> > 
> > 
> > 
> >border=0>
> >   > size=5>User Access by Date size=1>
> > 
> > 
> >Date
> >  > value="" size=25  maxlength=125>
> > 
> >   
> > 
> >   
> > 
> > 
> > 
> > 
> >border=0>
> >   > size=5>USER Access by IP Address
> > 
> > 
> >IP
> Address
> >  name="byipaddress"
> > value="" size=25  maxlength=125>
> > 
> >   
> > 
> >   
> > 
> > 
> >   
> >   
> >  
> > 
> >> name="submit">
> > 
> >  
> >   
> > 
> > 
> > <%
> > String inUser = null;
> > String inDate = null;
> > String inIPadd = null;
> >
> > try{
> >inUser =
> > (request.getParameter("byusername")).trim();
> >if (inUser == null) inUser = "";
> >inDate =
> request.getParameter("bydate").trim();
> >if (inDate == null) inDate = "";
> >inIPadd =
> > request.getParameter("byipaddress").trim();
> >if (inIPadd == null) inIPadd = "";
> >
> > }catch(NullPointerExce

RE: It would be great IF somebody answered me, ONCE, for change :(

[Luminous Heart]

Mike,
Yes I am returning the connection to the pool after
closing the ps. As you can see in the jsp code that I
have attached earlier to Craig, I am closing the
preparedstatement then returning the instance. Here
again the snippet.

%>



<%}

  ps.close();
  thisManager.returnConnection(myConn);

/* End Log user access count to the system */
}%>

--- Mike Jackson <[EMAIL PROTECTED]> wrote:
> You might want to close your database connection, or
> at least return it to
> the pool (I don't see you doing that, it ought to be
> after you close the
> prepared statement).
> 
> --mikej
> -=-
> mike jackson
> [EMAIL PROTECTED]
> 
> > -Original Message-
> > From: Luminous Heart
> [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, August 19, 2002 8:36 AM
> > To: Tomcat Users List
> > Subject: Re: It would be great IF somebody
> answered me, ONCE, for change
> > :(
> >
> >
> > Hi Graig,
> > Here is my jsp file. I am not sure what might be
> > wrong. Although the same error happens in a bigger
> > application in a tc cluster of 3 tomcats. Two of
> these
> > tcs fail while one does not get any forwards after
> > that.
> >
> > Please take a look at my code, if you do not mind.
> >
> > Best regards.
> >
> > = JSP =
> > <%@ page import="java.io.*" %>
> > <%@ page import="java.util.*" %>
> > <%@ page import="java.text.*" %>
> >
> > <%@ page import="java.util.Properties" %>
> > <%@ page import="java.util.Date" %>
> >
> > <%@ page contentType="text/html"%>
> >
> > <%@ page import="com.codestudio.util.*"%>
> > <%@ page import="java.sql.*"%>
> >
> > 
> >
> >  > name="access_form">
> >   
> >   
> >   
>  > size=5>User Access
> >
> >  
> >  
> >  
> >   
> >   
> > 
> > 
> >border=0>
> >   > size=5>User Access by userid
> > 
> >User
> > Name
> >  name="byusername"
> > size=25 value=""  maxlength=25>
> >   
> > 
> >   
> > 
> > 
> > 
> > 
> >border=0>
> >   > size=5>User Access by Date size=1>
> > 
> > 
> >Date
> >  > value="" size=25  maxlength=125>
> > 
> >   
> > 
> >   
> > 
> > 
> > 
> > 
> >border=0>
> >   > size=5>USER Access by IP Address
> > 
> > 
> >IP
> Address
> >  name="byipaddress"
> > value="" size=25  maxlength=125>
> > 
> >   
> > 
> >   
> > 
> > 
> >   
> >   
> >  
> > 
> >> name="submit">
> > 
> >  
> >   
> > 
> > 
> > <%
> > String inUser = null;
> > String inDate = null;
> > String inIPadd = null;
> >
> > try{
> >inUser =
> > (request.getParameter("byusername")).trim();
> >if (inUser == null) inUser = "";
> >inDate =
> request.getParameter("bydate").trim();
> >if (inDate == null) inDate = "";
> >inIPadd =
> > request.getParameter("byipaddress").trim();
> >if (inIPadd == null) inIPadd = "";
> >
> > }catch(NullPointerException npe){
> > out.println("Please choose a query option.");
> >
> > }
> >
> >   PreparedStatement ps = null;
> >  /* Log user access count to the system */
> >
> > SQLManager thisManager = null;
> > if (thisManager == null)
> >   thisManager = SQLManager.getInstance();
> >
> > Connection myConn = null;
> >
> >  if (myConn == null)
> >myConn = thisManager.requestConnection();
> > if (((inUser != null) && !inUser.equals("") ) ||
> > ((inDate != null

RE: It would be great IF somebody answered me, ONCE, for change :(

[Mike Jackson]

Actually now that I think about it more that might be the cause of the null
pointer (but
probably not).  In your poolman.xml file have you set the connection limit
to be a hard
limit?  If you timeout on connections (user timeout) is fairly high you
could run out of
connections, and it might return a "null" instead of a connection.

But that's just a guess.  Also, you might was to also turn on logging (debug
level) in
poolman as well so that you can watch the connections getting checked out
and in.

--mikej
-=-
mike jackson
[EMAIL PROTECTED]

> -Original Message-
> From: Luminous Heart [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 19, 2002 8:36 AM
> To: Tomcat Users List
> Subject: Re: It would be great IF somebody answered me, ONCE, for change
> :(
>
>
> Hi Graig,
> Here is my jsp file. I am not sure what might be
> wrong. Although the same error happens in a bigger
> application in a tc cluster of 3 tomcats. Two of these
> tcs fail while one does not get any forwards after
> that.
>
> Please take a look at my code, if you do not mind.
>
> Best regards.
>
> = JSP =
> <%@ page import="java.io.*" %>
> <%@ page import="java.util.*" %>
> <%@ page import="java.text.*" %>
>
> <%@ page import="java.util.Properties" %>
> <%@ page import="java.util.Date" %>
>
> <%@ page contentType="text/html"%>
>
> <%@ page import="com.codestudio.util.*"%>
> <%@ page import="java.sql.*"%>
>
> 
>
>  name="access_form">
>   
>   
> size=5>User Access
>
>  
>  
>  
>   
>   
> 
> 
>   
>   size=5>User Access by userid
> 
>User
> Name
>  size=25 value=""  maxlength=25>
>   
> 
>   
> 
> 
> 
> 
>   
>   size=5>User Access by Date
> 
> 
>Date
>  value="" size=25  maxlength=125>
> 
>   
> 
>   
> 
> 
> 
> 
>   
>   size=5>USER Access by IP Address
> 
> 
>IP Address
>  value="" size=25  maxlength=125>
> 
>   
> 
>   
> 
> 
>   
>   
>  
> 
>name="submit">
> 
>  
>   
> 
> 
> <%
>   String inUser = null;
>   String inDate = null;
>   String inIPadd = null;
>
>   try{
>  inUser =
> (request.getParameter("byusername")).trim();
>  if (inUser == null) inUser = "";
>  inDate = request.getParameter("bydate").trim();
>  if (inDate == null) inDate = "";
>  inIPadd =
> request.getParameter("byipaddress").trim();
>  if (inIPadd == null) inIPadd = "";
>
>   }catch(NullPointerException npe){
>   out.println("Please choose a query option.");
>
>   }
>
> PreparedStatement ps = null;
>  /* Log user access count to the system */
>
> SQLManager thisManager = null;
> if (thisManager == null)
>   thisManager = SQLManager.getInstance();
>
> Connection myConn = null;
>
>if (myConn == null)
>  myConn = thisManager.requestConnection();
>   if (((inUser != null) && !inUser.equals("") ) ||
> ((inDate != null) && !inDate.equals("")) || ((inIPadd
> != null) && !inIPadd.equals("")))
>   {
>
> java.util.Date today = new java.util.Date();
> java.sql.Timestamp stamp = new
> java.sql.Timestamp(today.getTime());
>
> String stampStr = stamp.toString();
>
> String timeofday =
> stampStr.substring(11,stampStr.length());
> String date = stampStr.substring(0,11);
>
> String todayatZero = date + " 00:00:00.";
>
> todayatZero = "2002-08-01 00:00:00.";
>
> inDate += " 00:00:00.";
>
>   boolean ValueEntered = false;
> if (((inUser != null)&& (inDate != null) && (inIPadd
> != null)) && (!inUser.equals("") && !inDate.equals("")
> && !inIPadd.equals("")) )
> {
> //out.println("

RE: It would be great IF somebody answered me, ONCE, for change :(

[Mike Jackson]

You might want to close your database connection, or at least return it to
the pool (I don't see you doing that, it ought to be after you close the
prepared statement).

--mikej
-=-
mike jackson
[EMAIL PROTECTED]

> -Original Message-
> From: Luminous Heart [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 19, 2002 8:36 AM
> To: Tomcat Users List
> Subject: Re: It would be great IF somebody answered me, ONCE, for change
> :(
>
>
> Hi Graig,
> Here is my jsp file. I am not sure what might be
> wrong. Although the same error happens in a bigger
> application in a tc cluster of 3 tomcats. Two of these
> tcs fail while one does not get any forwards after
> that.
>
> Please take a look at my code, if you do not mind.
>
> Best regards.
>
> = JSP =
> <%@ page import="java.io.*" %>
> <%@ page import="java.util.*" %>
> <%@ page import="java.text.*" %>
>
> <%@ page import="java.util.Properties" %>
> <%@ page import="java.util.Date" %>
>
> <%@ page contentType="text/html"%>
>
> <%@ page import="com.codestudio.util.*"%>
> <%@ page import="java.sql.*"%>
>
> 
>
>  name="access_form">
>   
>   
> size=5>User Access
>
>  
>  
>  
>   
>   
> 
> 
>   
>   size=5>User Access by userid
> 
>User
> Name
>  size=25 value=""  maxlength=25>
>   
> 
>   
> 
> 
> 
> 
>   
>   size=5>User Access by Date
> 
> 
>Date
>  value="" size=25  maxlength=125>
> 
>   
> 
>   
> 
> 
> 
> 
>   
>   size=5>USER Access by IP Address
> 
> 
>IP Address
>  value="" size=25  maxlength=125>
> 
>   
> 
>   
> 
> 
>   
>   
>  
> 
>name="submit">
> 
>  
>   
> 
> 
> <%
>   String inUser = null;
>   String inDate = null;
>   String inIPadd = null;
>
>   try{
>  inUser =
> (request.getParameter("byusername")).trim();
>  if (inUser == null) inUser = "";
>  inDate = request.getParameter("bydate").trim();
>  if (inDate == null) inDate = "";
>  inIPadd =
> request.getParameter("byipaddress").trim();
>  if (inIPadd == null) inIPadd = "";
>
>   }catch(NullPointerException npe){
>   out.println("Please choose a query option.");
>
>   }
>
> PreparedStatement ps = null;
>  /* Log user access count to the system */
>
> SQLManager thisManager = null;
> if (thisManager == null)
>   thisManager = SQLManager.getInstance();
>
> Connection myConn = null;
>
>if (myConn == null)
>  myConn = thisManager.requestConnection();
>   if (((inUser != null) && !inUser.equals("") ) ||
> ((inDate != null) && !inDate.equals("")) || ((inIPadd
> != null) && !inIPadd.equals("")))
>   {
>
> java.util.Date today = new java.util.Date();
> java.sql.Timestamp stamp = new
> java.sql.Timestamp(today.getTime());
>
> String stampStr = stamp.toString();
>
> String timeofday =
> stampStr.substring(11,stampStr.length());
> String date = stampStr.substring(0,11);
>
> String todayatZero = date + " 00:00:00.";
>
> todayatZero = "2002-08-01 00:00:00.";
>
> inDate += " 00:00:00.";
>
>   boolean ValueEntered = false;
> if (((inUser != null)&& (inDate != null) && (inIPadd
> != null)) && (!inUser.equals("") && !inDate.equals("")
> && !inIPadd.equals("")) )
> {
> //out.println("all are not empty and not null!");
> ps = myConn.prepareStatement ("select * from
> DataBaseTableName where username = ? and useripaddress
> = ? and timestamp >= ? order by timestamp desc");
> ps.setString(1, inUser);
> ps.setString(2, inIPadd);
> ps.setString(3, inDate);
> ValueEntered = true;
>
> }else{

Re: It would be great IF somebody answered me, ONCE, for change :(

[Luminous Heart]

ot;)) &&
((inDate != null) && !inDate.equals("")))
{
ps = myConn.prepareStatement ("select * from
DataBaseTableName where username = ? and timestamp >=
? order by timestamp desc");
ps.setString(1, inUser);
ps.setString(2, inDate);
//out.println("inUser & inDate are not empty!");
ValueEntered = true;
}else

if (((inIPadd != null) && !inIPadd.equals("")) &&
((inDate != null) && !inDate.equals("")))
{
ps = myConn.prepareStatement ("select * from
DataBaseTableName where username = ? and useripaddress
= ? order by timestamp desc");
ps.setString(1, inUser);
ps.setString(2, inIPadd);
//out.println("inIPadd & inDate are not empty!");
ValueEntered = true;
}

}
if(ValueEntered)
{
  ValueEntered = false;
ResultSet returnedRecord = ps.executeQuery();


String Attempt = "0";
String dUser = "";
String userIP = "";
String timestamper = "";
int counter = 0;

if (returnedRecord.next())
{
%>








Number
Username
IP
Logins
Stamp


<%}  //end testReturned.
returnedRecord.previous(); //keep here to make sure
you reset the cursor!

boolean isGrey = false;
String cellcolor = "#ee00ff";
try{
while(returnedRecord.next())
{
dUser = returnedRecord.getString("username");
userIP =
returnedRecord.getString("useripaddress");
Attempt =
returnedRecord.getString("DataBaseTableName");
timestamper =
returnedRecord.getString("timestamp");
if (counter % 2 == 0)
cellcolor = "#aaffee";
else cellcolor = "#aaff80";

counter++;
%>

<%=counter%>
<%=dUser%>
<%=userIP%>
<%=Attempt%>
                <%=timestamper%>
        

<%
isGrey = true;
}

}catch(java.lang.IndexOutOfBoundsException iobe){

}catch (java.lang.NullPointerException npe){}

  
%>



<%}

ps.close();
  thisManager.returnConnection(myConn);

/* End Log user access count to the system */
}%>

= End JSP =
--- "Craig R. McClanahan" <[EMAIL PROTECTED]> wrote:
> 
> 
> On Mon, 19 Aug 2002, Luminous Heart wrote:
> 
> > Date: Mon, 19 Aug 2002 08:14:08 -0700 (PDT)
> > From: Luminous Heart <[EMAIL PROTECTED]>
> > Reply-To: Tomcat Users List
> <[EMAIL PROTECTED]>
> > To: Tomcat Users List
> <[EMAIL PROTECTED]>
> > Subject: It would be great IF somebody answered
> me, ONCE, for change :(
> >
> > I keep on asking this question but noone helps. Is
> it
> > a bug in TC?
> >
> 
> Since Tomcat doesn't do any database processing of
> its own, this issue is
> virtually guaranteed to be a bug in your code, or
> (much less likely, but
> possible) a bug in the postgres or poolman packages.
>  THerefore, asking
> for help on a Tomcat list isn't likely to be useful
> -- especially since
> you don't include any of the code on your page that
> illustrates what you
> are trying to do.
> 
> Craig
> 
> 
> --
> To unsubscribe, e-mail:  
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
> 


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Re: It would be great IF somebody answered me, ONCE, for change :(

[Paul McGovern]

Sorry, but you haven't included enough information for anyone to formulate an 
answer. Based on the information all I can say is that you have a null 
pointer exception. If you want a proper response, please include the code 
segment that is going wrong, and config info from server.xml and web.xml.

Also please bear in mind that nobody here, AFAIK, is being paid to answer.


On Monday 19 August 2002 11:14, you wrote:
> I keep on asking this question but noone helps. Is it
> a bug in TC?
>
> Why do I get NullPointerException? If I press refresh
> a couple of times I would go through.
>
> 2002-08-19 00:53:32 StandardWrapperValve[jsp]:
> Servlet.service() for servlet jsp threw exception
> java.lang.NullPointerException
> at
> org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:61)
> at
> org.postgresql.Connection.ExecSQL(Connection.java:398)
> at
> org.postgresql.jdbc2.Statement.execute(Statement.java:130)
> at
> org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
> at
> org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:
>99) at
> com.codestudio.sql.PoolManPreparedStatement.executeQuery(Unknown
> Source)
> at
> org.apache.jsp.AccountAccess$jsp._jspService(AccountAccess$jsp.java:207)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.j
>ava:201) at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
> at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio
>nFilterChain.java:247) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC
>hain.java:193) at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j
>ava:243) at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
>566) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j
>ava:190) at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
>566) at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBas
>e.java:531) at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
>564) at
> org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:
>246) at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
>564) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:18
>0) at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
>566) at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve
>.java:170) at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
>564) at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:17
>0) at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
>564) at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
>564) at
> org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:392
>) at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
>564) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav
>a:174) at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:
>566) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:458)
> at
> org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:551)
> at java.lang.Thread.run(Thread.java:536)
>
>
>
> __
> Do You Yahoo!?
> HotJobs - Search Thousands of New Jobs
> http://www.hotjobs.com

--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

Re: It would be great IF somebody answered me, ONCE, for change :(

[Luminous Heart]

I bet you are the Snot, not just Snotty. How was I
being snotty by asking for someone to help. Yes we are
all obligated towards each other. That is the basic
concept of OpenSource, if you have not noticed. We are
a community of highly involved professionals and we
think that we have to be there for eachother. And
trust me. I would reply to you ASAP if I knew the
solution. So if you do not know the solution do not
fill up the bandwidth with your counterproductive
emails.

Best regards.

--- Paul Caton <[EMAIL PROTECTED]> wrote:
> Common sense should tell you that posting snotty
> subject-lines will
> not help persuade list users to answer you. You seem
> to think that
> someone has an *obligation* to jump and answer you
> as soon as
> possible, but this is not the case. Be patient and
> polite and I'll bet
> someone responds.
> 
> Paul Caton
> 
> -- 
> 
> Project Analyst/Electronic Publications Editor, WWP
> Scholarly Technology Group
> 
>  e-mail: [EMAIL PROTECTED]
> tel: (401) 863-3619
> address: Box 1841, Brown University, Providence RI
> 02912
> 
>   
> 
> 
> --
> To unsubscribe, e-mail:  
> 
> For additional commands, e-mail:
> 
> 


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

RE: It would be great IF somebody answered me, ONCE, for change :(

[Campano, Troy]

I don't know, but if you want to find out what is making your app break you need to 
find the cause first.
By finding out what is pointing to a null value, it could help.



-Original Message-
From: Luminous Heart [mailto:[EMAIL PROTECTED]] 
Sent: Monday, August 19, 2002 11:22 AM
To: Tomcat Users List
Subject: RE: It would be great IF somebody answered me, ONCE, for change :(


Well, it is a big application. And it was working fine
with tc3.x. I have never had such a problem. I noticed
that I had to do lots of modifications to my code to
get TC4.0.4 work. What is different?

--- "Campano, Troy" <[EMAIL PROTECTED]>
wrote:
> Have you tried commenting out different parts of
> your code to see what part is causing this problem?
> 
> -Original Message-
> From: Luminous Heart
> [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 19, 2002 11:14 AM
> To: Tomcat Users List
> Subject: It would be great IF somebody answered me,
> ONCE, for change :(
> 
> 
> I keep on asking this question but noone helps. Is
> it
> a bug in TC?
> 
> Why do I get NullPointerException? If I press
> refresh
> a couple of times I would go through.
> 
> 2002-08-19 00:53:32 StandardWrapperValve[jsp]:
> Servlet.service() for servlet jsp threw exception 
> java.lang.NullPointerException
> at
>
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:61)
> at
>
org.postgresql.Connection.ExecSQL(Connection.java:398)
> at
>
org.postgresql.jdbc2.Statement.execute(Statement.java:130)
> at
>
org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
> at
>
org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:99)
> at
>
com.codestudio.sql.PoolManPreparedStatement.executeQuery(Unknown
> Source)
> at
>
org.apache.jsp.AccountAccess$jsp._jspService(AccountAccess$jsp.java:207)
> at
>
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
> at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
> at
>
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
> at
>
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
> at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
>
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:531)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
> at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:392)
> at
>
o

Re: It would be great IF somebody answered me, ONCE, for change :(

[Craig R. McClanahan]

On Mon, 19 Aug 2002, Luminous Heart wrote:

> Date: Mon, 19 Aug 2002 08:14:08 -0700 (PDT)
> From: Luminous Heart <[EMAIL PROTECTED]>
> Reply-To: Tomcat Users List <[EMAIL PROTECTED]>
> To: Tomcat Users List <[EMAIL PROTECTED]>
> Subject: It would be great IF somebody answered me, ONCE, for change :(
>
> I keep on asking this question but noone helps. Is it
> a bug in TC?
>

Since Tomcat doesn't do any database processing of its own, this issue is
virtually guaranteed to be a bug in your code, or (much less likely, but
possible) a bug in the postgres or poolman packages.  THerefore, asking
for help on a Tomcat list isn't likely to be useful -- especially since
you don't include any of the code on your page that illustrates what you
are trying to do.

Craig


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

RE: It would be great IF somebody answered me, ONCE, for change :(

[Stuart Stephen]

Probably quite a lot then. ;o)

-Original Message-
From: Luminous Heart [mailto:[EMAIL PROTECTED]]
Sent: 19 August 2002 16:22
To: Tomcat Users List
Subject: RE: It would be great IF somebody answered me, ONCE, for change
:(


Well, it is a big application. And it was working fine
with tc3.x. I have never had such a problem. I noticed
that I had to do lots of modifications to my code to
get TC4.0.4 work. What is different?

--- "Campano, Troy" <[EMAIL PROTECTED]>
wrote:
> Have you tried commenting out different parts of
> your code to see what part is causing this problem?
>
> -Original Message-
> From: Luminous Heart
> [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 19, 2002 11:14 AM
> To: Tomcat Users List
> Subject: It would be great IF somebody answered me,
> ONCE, for change :(
>
>
> I keep on asking this question but noone helps. Is
> it
> a bug in TC?
>
> Why do I get NullPointerException? If I press
> refresh
> a couple of times I would go through.
>
> 2002-08-19 00:53:32 StandardWrapperValve[jsp]:
> Servlet.service() for servlet jsp threw exception
> java.lang.NullPointerException
> at
>
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:61)
> at
>
org.postgresql.Connection.ExecSQL(Connection.java:398)
> at
>
org.postgresql.jdbc2.Statement.execute(Statement.java:130)
> at
>
org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
> at
>
org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:9
9)
> at
>
com.codestudio.sql.PoolManPreparedStatement.executeQuery(Unknown
> Source)
> at
>
org.apache.jsp.AccountAccess$jsp._jspService(AccountAccess$jsp.java:207)
> at
>
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
> at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:201)
> at
>
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
> at
>
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
> at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:190)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
> at
>
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase
.java:531)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
> at
>
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
> at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
> at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:170)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
> at
>
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
> at
>
org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:392)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
> at
>
org.apache.catalina.core.StandardPipeline.inv

RE: It would be great IF somebody answered me, ONCE, for change :(

[Luminous Heart]

Well, it is a big application. And it was working fine
with tc3.x. I have never had such a problem. I noticed
that I had to do lots of modifications to my code to
get TC4.0.4 work. What is different?

--- "Campano, Troy" <[EMAIL PROTECTED]>
wrote:
> Have you tried commenting out different parts of
> your code to see what part is causing this problem?
> 
> -Original Message-
> From: Luminous Heart
> [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, August 19, 2002 11:14 AM
> To: Tomcat Users List
> Subject: It would be great IF somebody answered me,
> ONCE, for change :(
> 
> 
> I keep on asking this question but noone helps. Is
> it
> a bug in TC?
> 
> Why do I get NullPointerException? If I press
> refresh
> a couple of times I would go through. 
> 
> 2002-08-19 00:53:32 StandardWrapperValve[jsp]:
> Servlet.service() for servlet jsp threw exception
> java.lang.NullPointerException
> at
>
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:61)
> at
>
org.postgresql.Connection.ExecSQL(Connection.java:398)
> at
>
org.postgresql.jdbc2.Statement.execute(Statement.java:130)
> at
>
org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
> at
>
org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:99)
> at
>
com.codestudio.sql.PoolManPreparedStatement.executeQuery(Unknown
> Source)
> at
>
org.apache.jsp.AccountAccess$jsp._jspService(AccountAccess$jsp.java:207)
> at
>
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
> at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
> at
>
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
> at
>
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
> at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
>
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:531)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
> at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:392)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
> at
>
org.apache.cat

Re: It would be great IF somebody answered me, ONCE, for change :(

[Paul Caton]

Common sense should tell you that posting snotty subject-lines will
not help persuade list users to answer you. You seem to think that
someone has an *obligation* to jump and answer you as soon as
possible, but this is not the case. Be patient and polite and I'll bet
someone responds.

Paul Caton

-- 

Project Analyst/Electronic Publications Editor, WWP
Scholarly Technology Group

 e-mail: [EMAIL PROTECTED]
tel: (401) 863-3619
address: Box 1841, Brown University, Providence RI 02912




--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

RE: It would be great IF somebody answered me, ONCE, for change :(

[Campano, Troy]

Have you tried commenting out different parts of your code to see what part is causing 
this problem?

-Original Message-
From: Luminous Heart [mailto:[EMAIL PROTECTED]] 
Sent: Monday, August 19, 2002 11:14 AM
To: Tomcat Users List
Subject: It would be great IF somebody answered me, ONCE, for change :(


I keep on asking this question but noone helps. Is it
a bug in TC?

Why do I get NullPointerException? If I press refresh
a couple of times I would go through. 

2002-08-19 00:53:32 StandardWrapperValve[jsp]:
Servlet.service() for servlet jsp threw exception java.lang.NullPointerException
at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:61)
at
org.postgresql.Connection.ExecSQL(Connection.java:398)
at
org.postgresql.jdbc2.Statement.execute(Statement.java:130)
at
org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
at
org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:99)
at com.codestudio.sql.PoolManPreparedStatement.executeQuery(Unknown
Source)
at
org.apache.jsp.AccountAccess$jsp._jspService(AccountAccess$jsp.java:207)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:531)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:392)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:458)
at
org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:551)
at java.lang.Thread.run(Thread.java:536)
 


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-ma

It would be great IF somebody answered me, ONCE, for change :(

[Luminous Heart]

I keep on asking this question but noone helps. Is it
a bug in TC?

Why do I get NullPointerException? If I press refresh
a couple of times I would go through. 

2002-08-19 00:53:32 StandardWrapperValve[jsp]:
Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:61)
at
org.postgresql.Connection.ExecSQL(Connection.java:398)
at
org.postgresql.jdbc2.Statement.execute(Statement.java:130)
at
org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
at
org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:99)
at
com.codestudio.sql.PoolManPreparedStatement.executeQuery(Unknown
Source)
at
org.apache.jsp.AccountAccess$jsp._jspService(AccountAccess$jsp.java:207)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:531)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:392)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:458)
at
org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:551)
at java.lang.Thread.run(Thread.java:536)
 


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

--
To unsubscribe, e-mail:   
For additional commands, e-mail: