This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript 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
 
wood burning stoves
 
subject: Connection close issue