aspose file tools*
The moose likes JDBC and the fly likes Regarding Many Connections in a service file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Regarding Many Connections in a service file" Watch "Regarding Many Connections in a service file" New topic
Author

Regarding Many Connections in a service file

Anbarasu Aladiyan
Ranch Hand

Joined: Jun 02, 2009
Posts: 182


I am writing a 'service file'. In this i am using more number of 'sql connections'. As of now i have declared Connection, PrepareStatement, ResultSet in Class level. So i am using these in my code again and again. ie. Every time i am creating new connection and closing it again.

Yesterday my friend said me to use a single connection through out the code. Like with out closing the connection.

Please help me.. Which better way(When i am using more SQL statements)

Regards,
A.A.Anbarasu


A.A.Anbarasu
Mathew Lee
Ranch Hand

Joined: Jun 08, 2009
Posts: 238
I believe single connection is always better
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30537
    
150

I would use a connection pool. Even if it only has one connection, this lets the pool handle it for you. Keeping one connection open too long can give you a timeout error. Whereas getting a connection from the pool is much cheaper than getting a new one each time.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
Don't get me started about those stupid light bulbs.
 
subject: Regarding Many Connections in a service file