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:44:06 GMT
Mike,
Yes I am returning the connection to the pool after
closing the ps. As you can see in the jsp code that I
have attached earlier to Craig, I am closing the
preparedstatement then returning the instance. Here
again the snippet.

%>
</table>
</body>
</html>
<%}
 	
  ps.close();
  thisManager.returnConnection(myConn);

	/* End Log user access count to the system */
}%>

--- Mike Jackson <mjackson@cdi-hq.com> wrote:
> You might want to close your database connection, or
> at least return it to
> the pool (I don't see you doing that, it ought to be
> after you close the
> prepared statement).
> 
> --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("")) )
> > {
> > //out.println("all are not empty and not null!");
> > ps = myConn.prepareStatement ("select * from
> > DataBaseTableName where username = ? and
> useripaddress
> > = ? and timestamp >= ? order by timestamp desc");
> > ps.setString(1, inUser);
> > ps.setString(2, inIPadd);
> > ps.setString(3, inDate);
> > ValueEntered = true;
> >
> > }else{
> > if ((inUser != null)&&	(!inUser.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