can't seem to find anything on my problem. hope list can help: thread class creates connection to mysql - all is well if sql takes too long, calling thread interrupts thread, and close resources: rs.close(), stmt.close(), conn.close() however mysqld server connections are not closed after a while, max number of connections is reached. bad.
how do i force the connection on mysqld to close after thread interrupt? btw, normal close of connection (without thread interrupt) works fine. solaris 2.8 mysql v4.0 jdbc v3.14 david ---- David Lopez org: fsl->tso->dsn tech->tools&meth->t&m interfce->csam phone: 480-413-6251 email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]