Hi takashi,
My environment is :
Win2000, jdk1.3, tomcat 4,
Well, i am sure i added a snippet which closes statemnt and the connection.
for example, below is the snippet from one of my pages content.jsp :
<% if (stmt!=null) { // actually this is a curly left brace
stmt.close(); } // actually this is a curly right brace
if (conn!=null){ // stmt is a Statement object
conn.close(); // conn is a Connection object
} %>
whenever i call this page , number of connections inreases by one
it seems that the connections can not be closed
Any idea or suggestions ?
thanks a lot in advance
best regards :)
----- Original Message -----
From: "TAKAHASHI, Tomohiro" <[EMAIL PROTECTED]>
To: "yilmaz" <[EMAIL PROTECTED]>
Sent: Sunday, November 25, 2001 8:02 PM
Subject: Re: number of connections keeps increasing
>
> I want to know environment about Java, JDBC, Servlet-Conatiner, and so
on.
> Maybe, I think you forget to close connection in JSP somewhere.
>
> yilmaz wrote:
> >
> > hi takashi,
> > i don't know which jsp page exactly causes this problem,
> > because i have more than 30 JSP pages in my application, and i always
> > close my statements and connections after the process is finished.
> > But , i think probably the problem comes from MySQL itself
> > below is my MySQL environment:
> >
> > This Report was made using the WinMySQLadmin 1.0 Tool
> >
> <snip>
>
> --
> TAKAHASHI, Tomohiro
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
