tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Luminous Heart <luminoushe...@yahoo.com>
Subject Craig, PoolMan, latest version WAS the problem.
Date Mon, 19 Aug 2002 16:53:52 GMT
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 <luminousheart@yahoo.com> 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 <mjackson@cdi-hq.com> 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
> > mjackson@cdi-hq.com
> > 
> > > -----Original Message-----
> > > From: Luminous Heart
> > [mailto:luminousheart@yahoo.com]
> > > 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>&nbsp;</td>
> > >     <td>&nbsp;</td>
> > >     <td>&nbsp;</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>&nbsp;</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:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


Mime
View raw message