Return-Path: 
 <tomcat-user-return-30156-qmlist-jakarta-archive-tomcat-user=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org
Received: (qmail 13995 invoked from network); 19 Aug 2002 15:50:45 -0000
Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131)
  by daedalus.apache.org with SMTP; 19 Aug 2002 15:50:45 -0000
Received: (qmail 1066 invoked by uid 97); 19 Aug 2002 15:50:11 -0000
Delivered-To: qmlist-jakarta-archive-tomcat-user@jakarta.apache.org
Received: (qmail 971 invoked by uid 97); 19 Aug 2002 15:50:09 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 869 invoked by uid 98); 19 Aug 2002 15:50:09 -0000
X-Antivirus: nagoya (v4198 created Apr 24 2002)
Message-ID: <20020819154937.74362.qmail@web13509.mail.yahoo.com>
Date: Mon, 19 Aug 2002 08:49:37 -0700 (PDT)
From: Luminous Heart <luminousheart@yahoo.com>
Subject: RE: It would be great IF somebody answered me, ONCE, for change :(
To: Tomcat Users List <tomcat-user@jakarta.apache.org>
In-Reply-To: <DDEPJBPNFOMNALFBBLMMGEJMDPAA.mjackson@cdi-hq.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

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>
> >     <td>&nbsp;</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:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>