mysql memory leak_解决Memory Leak问题

异常如下：

2012-2-9 17:43:12 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc

严重: The web application [/codeMarket] registered the JBDC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

2012-2-9 17:43:12 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc

严重: The web application [/codeMarket] registered the JBDC driver [oracle.jdbc.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

2012-2-9 17:43:12 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

严重: The web application [/codeMarket] appears to have started a thread named [Timer-0] but has failed to stop it. This is very likely to create a memory leak.

2012-2-9 17:43:12 org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap

严重: The web application [/codeMarket] created a ThreadLocal with key of type [null] (value [com.opensymphony.xwork2.inject.ContainerImpl$10@e1666]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@e0ada6]) but failed to remove it when the web application was stopped. This is very likely to create a memory leak.

2012-2-9 17:43:12 org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap

严重: The web application [/codeMarket] created a ThreadLocal with key of type [null] (value [com.opensymphony.xwork2.inject.ContainerImpl$10@a8a314]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@16ab2e8]) but failed to remove it when the web application was stopped. This is very likely to create a memory leak.

AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@11f1f12)

LogAbandoned: false

RemoveAbandoned: true

RemoveAbandonedTimeout: 3600

搜了一堆资料终于搞懂了 赶紧记下来~~

第一个问题：

严重: The web application [/codeMarket] registered the JBDC driver [oracle.jdbc.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

网上资料:

详细如下：

应用程序注册了JDBC驱动，但当程序停止时无法注销这个驱动，tomcat为了防止内存溢出，就给强制注销了

https://issues.apache.org/jira/browse/DBCP-332

解决：

重写了org.apache.commons.dbcp.BasicDataSource 的 close()方法：

packageorg.company.util;importjava.sql.DriverManager;importjava.sql.SQLException;importorg.apache.commons.dbcp.BasicDataSource;public class XBasicDataSource extendsBasicDataSource{

@Overridepublic synchronized void close() throwsSQLException{//System.out.println("......输出数据源Driver的url："+DriverManager.getDriver(url));

DriverManager.deregisterDriver(DriverManager.getDriver(url));super.close();

}

}

在dbcp数据源中的配置：

class="org.company.util.XBasicDataSource" destroy-method="close">

value="oracle.jdbc.driver.OracleDriver">

value="jdbc:oracle:thin:@XX.XXX.XX.X:1521:ccdb">

问题解决~

再重新加载的时候发现还有：

严重: The web application [/codeMarket] registered the JBDC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

2012-2-9 17:43:12 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc

检查了一下jar包 发现多了一个mysql-connector-java-bin.jar 赶紧删之 ok~