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 ===================== ><?xml version="1.0" encoding="UTF-8"?> > ><poolman> > > <management-mode>local</management-mode> > > <datasource> > > <!-- ============================== --> > <!-- Physical Connection Attributes --> > <!-- ============================== --> > > <!-- Standard JDBC Driver info --> > > <dbname>webdev</dbname> > <jndiName>webdev</jndiName> > <driver>org.postgresql.Driver</driver> > <url>jdbc:postgresql://localhost:6093/webdev</url> > > <username>JustAUserName</username> > <password>JustAUserNamePassword</password> > > <!-- Oracle needs this to be set to true --> > <nativeResults>true</nativeResults> > > <minimumSize>1</minimumSize> > <maximumSize>10</maximumSize> > <connectionTimeout>600</connectionTimeout> > <userTimeout>12</userTimeout> > <shrinkBy>10</shrinkBy> > > ><logFile>/usr/local/tomcat/logs/poolman.log</logFile> > <debugging>false</debugging> > > <!-- Query Cache Attributes--> > > <cacheEnabled>false</cacheEnabled> > <cacheSize>20</cacheSize> > <cacheRefreshInterval>120</cacheRefreshInterval> > > </datasource> > ></poolman> > >==================== 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.*"%> > > > > > > <!-- %@ include file="no-cache.jsp" % --> > > > > > > <form action="UserAccount.jsp" method=post > > > name="access_form"> > > > <table width="90%" align="center"> > > > <tr> > > > <th bgcolor="#CCCCFF" colspan=3> > > <font > > > size=5>User Access</font></th> > > > > > > <td> </td> > > > <td> </td> > > > <td> </td> > > > </tr> > > > <tr> > > > <td> > > > <center> > > > <table cellpadding=4 cellspacing=2 > > border=0> > > > <th bgcolor="#CCCCFF" colspan=2> <font > > > size=5>User Access by userid</font></th> > > > <tr bgcolor="#c8d8f8"> > > > <td valign=top colspan=2> <b>User > > > Name</b><br> > > > <input type="text" > > name="byusername" > > > size=25 value="" maxlength=25> > > > </td> > > > </tr> > > > </table> > > > </center> > > > </td> > > > <td> > > > <center> > > > <table cellpadding=4 cellspacing=2 > > border=0> > > > <th bgcolor="#CCCCFF" colspan=2> <font > > > size=5>User Access by Date</font><font > > size=1></font> > > > </th> > > > <tr bgcolor="#c8d8f8"> > > > <td valign=top> <b>Date</b><br> > > > <input type="text" name="bydate" > > > value="" size=25 maxlength=125> > > > <br> > > > </td> > > > </tr> > > > </table> > > > </center> > > > </td> > > > <td> > > > <center> > > > <table cellpadding=4 cellspacing=2 > > border=0> > > > <th bgcolor="#CCCCFF" colspan=2> <font > > > size=5>USER Access by IP Address</font> > > > </th> > > > <tr bgcolor="#c8d8f8"> > > > <td valign=top> <b>IP > > Address</b><br> > > > <input type="text" > > name="byipaddress" > > > value="" size=25 maxlength=125> > > > <br> > > > </td> > > > </tr> > > > </table> > > > </center> > > > </td> > > > </tr> > > > <tr> > > > <td> </td> > > > <td align="center" bgcolor="#c8d8f8"> > > > <input type="submit" value="Submit" > > > name="submit"> > > > </td> > > > <td> </td> > > > </tr> > > > </table> > > > </form> > > > <% > > > 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.0000"; > > > > > > todayatZero = "2002-08-01 00:00:00.0000"; > > > > > > inDate += " 00:00:00.0000"; > > > > > > boolean ValueEntered = false; > > > if (((inUser != null)&& (inDate != null) && > > (inIPadd > > > != null)) && (!inUser.equals("") && > > !inDate.equals("") > > > && !inIPadd.equals("")) ) > > >=== 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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
