Interesting process problem

[rmccown]

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:

root   388  0.0  3.2  18976  1500  ?  S  N  14:33  0:00
/usr/local/mysql-3.22.25-pc-linux-gnu-i686/bin/mysqld
--basedir=/usr/local/mysql-3.22.25-pc-linux/gnu-i386
--datadir=/usr/local/mysql/data --skip-locking --user=root
--pid-file=/usr/local/mysql/data/goodolboys.pic
--datadir=/usr/local/mysql/data

Over the span of a couple hours, I get hundreds of these, and eventually the
machine grinds to a halt.

Any ideas?

-Bob

<><><><><><><><><><><><><><><><><><><><><><><>
Bob McCown - Burst! Media LLC - [phone]
<><><><><><><><><><><><><><><><><><><><><><><>