To prevent a memory leak, the JDBC Driver has been forcibly unregistered

by

Since version 6.0.24, Tomcat ships with a memory leak detection feature, which in turn can lead to this kind of warning messages when there’s a JDBC 4.0 compatible driver in the webapp’s /WEB-INF/lib which auto-registers itself during webapp’s startup using the ServiceLoader API, but which did not auto-deregister itself during webapp’s shutdown. This message is purely informal, Tomcat has already taken the memory leak prevention action accordingly.

What can you do?

  1. Ignore those warnings. Tomcat is doing its job right. The actual bug is in someone else’s code (the JDBC driver in question), not in yours. Be happy that Tomcat did its job properly and wait until the JDBC driver vendor get it fixed so that you can upgrade the driver. On the other hand, you aren’t supposed to drop a JDBC driver in webapp’s /WEB-INF/lib, but only in server’s /lib. If you still keep it in webapp’s /WEB-INF/lib, then you should manually register and deregister it using a ServletContextListener.

  2. Downgrade to Tomcat 6.0.23 or older so that you will not be bothered with those warnings. But it will silently keep leaking memory. Not sure if that’s good to know after all. Those kind of memory leaks are one of the major causes behind OutOfMemoryError issues during Tomcat hotdeployments.

  3. Move the JDBC driver to Tomcat’s /lib folder and have a connection pooled datasource to manage the driver. Note that Tomcat’s builtin DBCP does not deregister drivers properly on close. See also bug DBCP-322 which is closed as WONTFIX. You would rather like to replace DBCP by another connection pool which is doing its job better then DBCP. For example HikariCP or perhaps Tomcat JDBC Pool.

More Related Contents:

  1. MySQL JDBC Driver 5.1.33 – Time Zone Issue
  2. Can I connect to SQL Server using Windows Authentication from Java EE webapp?
  3. How to configure Tomcat to connect with MySQL
  4. Native Library sqljdbc_auth.dll already loaded in another classloader
  5. Where do I have to place the JDBC driver for Tomcat’s connection pool?
  6. Hours and seconds are lost when storing a date in the database [closed]
  7. How should I use try-with-resources with JDBC?
  8. Get query from java.sql.PreparedStatement [duplicate]
  9. How does a PreparedStatement avoid or prevent SQL injection?
  10. Sharing session data between contexts in Tomcat
  11. How to tune Tomcat 5.5 JVM Memory settings without using the configuration program
  12. Mapping a specific servlet to be the default servlet in Tomcat
  13. How to enable logging for SQL statements when using JDBC
  14. Difference between Oracle jdbc driver classes?
  15. How I save and retrieve an image on my server in a java webapp [duplicate]
  16. Writing a large resultset to an Excel file using POI
  17. Retrieve an Image stored as BLOB on a MYSQL DB
  18. UNIX socket implementation for Java? [closed]
  19. Spring – Injecting a dependency into a ServletContextListener
  20. java.lang.NoClassDefFoundError: javax/servlet/http/HttpServletRequest
  21. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  22. Spring-Boot: How do I set JDBC pool properties like maximum number of connections?
  23. mysql prepared statement error: MySQLSyntaxErrorException
  24. Starting of Tomcat failed from Netbeans
  25. Where is the “server log” for Tomcat when running externally from IntelliJ Ultimate?
  26. Tomcat: How to find out running Tomcat version?
  27. Running a background Java program in Tomcat [duplicate]
  28. How to store a file on a server(web container) through a Java EE web application?
  29. ExceptionHandler doesn’t work with Throwable
  30. ClassNotFoundException DispatcherServlet when launching Tomcat (Maven dependencies not copied to wtpwebapps)

Leave a Comment