>Subject: jdbc driver: should a copy ... > >be placed in each webapp's web-inf/lib folder so it >instantiates its own >copy of the jdbc driver? Right now I have a single copy in the >common/lib >but I experience lags and temp space growth that runs amuck essentially >causing DoS.
I don't think having multiple JDBC drivers loaded will change anything. All the ressources are attached to the connection objects. Make sure that you close ResultSet objects as early as possible. The garbage collector could start much too late. >kill all the connections because I have no way of knowing >which individual >connection is blocking and/or freaking out and causing the slow down. 7.6 has additional infos in system tables (SELECT * from FILES) that allow you to get the amount of temp space used by each session. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
