my dog learned polymorphism*
The moose likes JDBC and the fly likes Connection close issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection close issue" Watch "Connection close issue" New topic
Author

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 .

Reagards,
Sreedhar
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.
SCJP 5 ScjpFAQ JLS
Paul Sturrock
Bartender

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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Connection close issue