This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
The moose likes Servlets and the fly likes Inactive DB Connection issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Introducing JavaFX 8 Programming this week in the JavaFX forum!
JavaRanch » Java Forums » Java » Servlets
Reply locked New topic

Inactive DB Connection issue

Anand Bhatt
Ranch Hand

Joined: May 30, 2007
Posts: 189
I have one for loop that runs for 3000 times ,inside that loop I I am opening db connection(simple JDBC),and at the last inside finally block I am closing all db resources(statement,resultset and connectionproperly.
The issue is that in the inactive database connection mounting to somr 500 and appliction tossed up.
What the wrong I a am doing here?
Using: Jsp,Struts1.2,JDBC andOracle database
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63334

Please do not cross-post the same question in multiple forums. It wastes people's time when multiple redundant conversations take place. Please click this link ⇒ CarefullyChooseOneForum ⇐ for more information.

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Consider Paul's rocket mass heater.
subject: Inactive DB Connection issue
It's not a secret anymore!