aspose file tools*
The moose likes JDBC and the fly likes Weak reference concept in Connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Weak reference concept in Connection " Watch "Weak reference concept in Connection " New topic

Weak reference concept in Connection

siva saran

Joined: Mar 11, 2007
Posts: 17
Hi all,

I have the folowing code snippet

My doubt is
1) I do a getConnection two times but should I close two times using returnConnection or one returnConnection is enough.
2) I read about a concept called "Weak reference".Does this example point to that.Any more simplified explanation availabe
for the concept somewhere.
3) As of now , I have used two return connection (i have uncommented the code in the finally to avoid problems)but I feel its redundant.Please correct me if am wrong.
Leandro Coutinho
Ranch Hand

Joined: Mar 04, 2009
Posts: 417
next time post a clean and idented code

Googling you'll find nice texts about weak references. But I don't think you need to use it.
Search for connection pool to enhance the performance.

yes, it's redundant. other thing I noticed, you are throwing and catching the exception in the same

I changed the code a little:

siva saran

Joined: Mar 11, 2007
Posts: 17
Thanks Leandro. I will keep your instruction in mind.
I agree. Here's the link:
subject: Weak reference concept in Connection
Similar Threads
Why cant connect to another computer in lan?
Problem in getting the data from DB using servlets
mysql connectivity with jboss
JDBC Connection Pooling in Websphere
ClassNotFoundException while trying to connect to Oracle