oracle 强制注册,为防止内存泄漏,JDBC驱动程序已被强制取消注册

Andrea Ratto..

8

针对每个应用部署的解决方案

这是我为解决问题而编写的一个监听器:如果驱动程序已经注册并且相应地执行操作,它会自动检测

重要说明:它仅用于在WEB-INF/lib中部署驱动程序jar时使用,而不是像许多人建议的那样在Tomcat/lib中部署,这样每个应用程序都可以处理自己的驱动程序并在未受影响的Tomcat上运行.这就是恕我直言的方式.

只需在web.xml之前配置监听器,然后再享受.

在web.xml顶部附近添加:

utils.db.OjdbcDriverRegistrationListener

另存为utils/db/OjdbcDriverRegistrationListener.java:

package utils.db;

import java.sql.Driver;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.Enumeration;

import javax.servlet.ServletContextEvent;

import javax.servlet.ServletContextListener;

import oracle.jdbc.OracleDriver;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

/**

* Registers and unregisters the Oracle JDBC driver.

*

* Use only when the ojdbc jar is deployed inside the webapp (not as an

* appserver lib)

*/

public class OjdbcDriverRegistrationListener implements ServletContextListener {

private static final Logger LOG = LoggerFactory

.getLogger(OjdbcDriverRegistrationListener.class);

private Driver driver = null;

/**

* Registers the Oracle JDBC driver

*/

@Override

public void contextInitialized(ServletContextEvent servletContextEvent) {

this.driver = new OracleDriver(); // load and instantiate the class

boolean skipRegistration = false;

Enumeration drivers = DriverManager.getDrivers();

while (drivers.hasMoreElements()) {

Driver driver = drivers.nextElement();

if (driver instanceof OracleDriver) {

OracleDriver alreadyRegistered = (OracleDriver) driver;

if (alreadyRegistered.getClass() == this.driver.getClass()) {

// same class in the VM already registered itself

skipRegistration = true;

this.driver = alreadyRegistered;

break;

}

}

}

try {

if (!skipRegistration) {

DriverManager.registerDriver(driver);

} else {

LOG.debug("driver was registered automatically");

}

LOG.info(String.format("registered jdbc driver: %s v%d.%d", driver,

driver.getMajorVersion(), driver.getMinorVersion()));

} catch (SQLException e) {

LOG.error(

"Error registering oracle driver: " +

"database connectivity might be unavailable!",

e);

throw new RuntimeException(e);

}

}

/**

* Deregisters JDBC driver

*

* Prevents Tomcat 7 from complaining about memory leaks.

*/

@Override

public void contextDestroyed(ServletContextEvent servletContextEvent) {

if (this.driver != null) {

try {

DriverManager.deregisterDriver(driver);

LOG.info(String.format("deregistering jdbc driver: %s", driver));

} catch (SQLException e) {

LOG.warn(

String.format("Error deregistering driver %s", driver),

e);

}

this.driver = null;

} else {

LOG.warn("No driver to deregister");

}

}

}