Ok. I reverted to an older version of PoolMan, where we use pool.prop instead of pool.xml. That version works fine. I have not hit the exception although I tested it for sometime.
Does that mean am stuck to the older poolman? Is there a better solution to handle database pooling? Thank you. --- Luminous Heart <[EMAIL PROTECTED]> 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> > === 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]>
