如何检查Java EE应用程序中的数据库连接泄漏? [英] How to check the Database Connection leakage in Java EE application?

问题描述

有什么方法可以检查Java EE应用程序中的连接泄漏吗?

Is there any way to check the connection leakage in a Java EE application?

该应用程序正在我的本地计算机上运行.它使用MySQL数据库，并且用户将其详细信息输入该数据库.

The application is running on my local machine. It uses a MySQL database and a user enters his details into this database.

我认为连接泄漏表示未正确关闭连接对象.我在应用程序中创建了太多的数据库连接.我想检查数据库连接中是否存在任何连接泄漏.

In my opinion connection leakage means not closing the connection object properly. I am creating too many database connections in my application. I want to check if there is any connection leakage in the database connections.

推荐答案

log4jdbc ，可以记录其他JDBC驱动程序的SQL和/或JDBC调用的Java JDBC驱动程序具有一个记录器，该记录器记录连接打开和关闭事件以及转储所有打开的连接号.这对于解决连接泄漏问题非常有用.

log4jdbc, a Java JDBC driver that can log SQL and/or JDBC calls for other JDBC drivers, has a logger which logs connection open and close events as well as dumping all open connection numbers. This is very useful for hunting down connection leak problems.

您可能要检查的另一种工具是 ConnLeakFinder ，一种简单的工具，可用于确定jdbc连接Java代码中泄漏.我没有任何经验.

Another tool that you might want to check is ConnLeakFinder, a simple tool to pinpoint jdbc connection leaks in java code. I don't have any experience with it though.

这篇关于如何检查Java EE应用程序中的数据库连接泄漏?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！