File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Connection close issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connection close issue" Watch "Connection close issue" New topic

Connection close issue

sreedhar Lackka
Ranch Hand

Joined: Jul 05, 2008
Posts: 154
Hi All,
Thanks a lot in advance.
We are facing a serious problem with Connections.
How can I identify through programatically how many connections are opening and closing while browsing the application.

Is there any way to find out in Java/Oracle to find out open connections.
Without verifying line by line code beacuse we 1000 files.

Please help me .

sudipto shekhar
Ranch Hand

Joined: Apr 02, 2008
Posts: 823

I went though the documentation and found no such method to do that.

Anybody, lease correct me if I am wrong.

Thank you.

Regards, Sud.
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

If you are using a connection pool this may be able to tell you. Oracle has various management views you ca use (e.g. v$session) which will tell you a lot about active connections. Have a look through the Administrators Guide.

Neither of these are programatic. But using Oracle's admin stuff you should be able to find out if you are hitting the limit allowed and change that limit accordingly.
[ December 11, 2008: Message edited by: Paul Sturrock ]

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link:
subject: Connection close issue
It's not a secret anymore!