RE: Interesting process problem

[rmccown]

Bingo...I wasnt closeing the result set rs.close() under certain
circumstances....

Thanks!

-Bob

-----Original Message-----
From: Tim Endres [mailto:time@stripped]
Sent: Tuesday, September 14, 1999 2:59 PM
To: rmccown@stripped
Subject: Re: Interesting process problem


> Hi there.
>  Ive got an interesting problem happening here.  Im using java 1.2, Apache
> 1.3.x, and Linux 2.1.35.  Im writing a servlet, and using the following
> style of call to send a query:
> 
>    try {
>       Connection con = DriverManager.getConnection(SQL_DBURL); 
>       Statement stmt = con.createStatement();
>       String sQuery = "Select email, addrlist from users where userid='" +
> iUserID + "'";
>       ResultSet rs = stmt.executeQuery(sQuery);
>       if( rs.next() )
>       {
> 	...
> 
> what happens, is EVERY TIME that a request is executed, I get another
> process of mysql running.  here's the ps -auxw of one of the lines:

Do you close the ResultSet, Statement, and Connection each time?
tim.