This is a discussion on mysqld connections still open when java thread interrupted within the MySQL General forum forums, part of the MySQL category; --> can't seem to find anything on my problem. hope list can help: thread class creates connection to mysql - ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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: r9374c@freescale.com |
| Thread Tools | |
| Display Modes | |
|
|