tomcat : How to get opened jdbc:oracle connection&

Question

Have a web application running across multiple locations,
I can see many connections piling up by running this command on linux:

ps -ef|grep LOCAL

shows me the count of active oracle connections with process id's, and the connection count has been growing up by 5-7 number every hour. After few hours, application slows down and eventually tomcat server needs to be restarted.

As, I am able to see connections growing, Is there any way to get the source of these connections, to find out what classes or object's have created these laid up connections?

And I am not using Tomcat connection pooling, I tried generating thread dumps by issuing kill -3 tomcat pid, but of no use to me, as I am not able to understand them, even tried thread analyzers.

Is there any simple way to get the originator classes associated with these laid up connections to get a small hint, using some tomcat feature, or by any other means?

Answer 1

You could search for uses of javax.sql.DataSource.getConnection() using your IDE.

If you start tomcat in debug mode, you can look for instances of the connection class (and see them increasing). Also, putting a breakpoint on the constructor will catch them in the act of being created.

But really you should be using a connection pool. That is the easiest solution to your problems.

Answer 2

Perhaps these two tools can help you to determine what slows your sever application's performance.

jmeter

ab benchmarking tool

Performance might have slowed due to some simple implementation issues too. You might want to use NIO (buffer oriented, non-blocking IO) instead of IO for web applications, also you might be doing a lot of string concatenations (use StringBuffer).

Answer 3

In JProfiler, you yould use the JDBC probe to get the stack trace that opened a connection. You would select the connection in the timeline

and jump to the events view

where you can select the "Connection opened" event. in the lower pane, the associated stack trace is shown.

Disclaimer: My company develops JProfiler