This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes OutofMemory Error.. Due to Pooling? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "OutofMemory Error.. Due to Pooling?" Watch "OutofMemory Error.. Due to Pooling?" New topic

OutofMemory Error.. Due to Pooling?

Rajkumar balakrishnan
Ranch Hand

Joined: May 29, 2008
Posts: 445

Hi friends,

We are using JNDI with Struts for DS and Connection Pooling. The issue is we very often getting this 'OutOfMemoryError'. And after a server restart only we can able to use the application. Currently we dont have much data's say around 5000, but after implementation, it'll go upto 1lakh. My question is , is there any way to find if there is an memory leak in the application? Because, for another application we are using Spring + DBCP and it never give us any problem yet.

Or else,do we need to close each and every connection manually in Controller itself? Which one do you suggest and please help me get rid of this.

Thanks in advance.

Never try to be a hard-worker. Be a smart-worker.
My Blog
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

You should always release JDBC resources in a finally block after you have finished with them.

To find memory leaks, run your application in a soak test environment and watch memory consumption. If it keeps rising, you may have a leak. To find it, profile what the application is doing with a profiler.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Deepak Bala

Joined: Feb 24, 2006
Posts: 6662

To find it, profile what the application is doing with a profiler.

Try visualvm

SCJP 6 articles - SCJP 5/6 mock exams - More SCJP Mocks
I agree. Here's the link:
subject: OutofMemory Error.. Due to Pooling?
It's not a secret anymore!