tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Luminous Heart <luminoushe...@yahoo.com>
Subject RE: It would be great IF somebody answered me, ONCE, for change :(
Date Mon, 19 Aug 2002 15:49:37 GMT
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>


Mime
View raw message