This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Re: Freeing of resources 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 "Re: Freeing of resources" Watch "Re: Freeing of resources" New topic

Re: Freeing of resources

Ashwin Tadepalli

Joined: Feb 01, 2001
Posts: 27
I have a qusetion about freeing of resources when I am using JDBC code.My application works pretty well for sometime and after sometime it behaves in a weird manner.Basically my application involves servlets talking to backend database and retreiving the results back.To remedy for the solution I have to restart my application server and you know what it works pretty well this time.In my JDBC code I did not close my statement but I did close my connection and it works fine.Also I am using the CreateStatement() in a try block.Is it advisable to use it there or put it before the try statement,could anyone please let me know of what exactly is happening here.
Thanking you,
Angela Lamb
Ranch Hand

Joined: Feb 22, 2001
Posts: 156
You need to close your result sets and statements or the database resources will eventually be used up. This is usually done in a finally block.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Re: Freeing of resources
It's not a secret anymore!