wood burning stoves 2.0*
The moose likes JDBC and the fly likes why need connection pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "why need connection pool" Watch "why need connection pool" New topic
Author

why need connection pool

meg850
Greenhorn

Joined: May 07, 2002
Posts: 1
very stupid question. But I just can't answer it?
who can help me or tell me where to find info about the difference between pool and Divermanage
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

"meg850",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp.
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements.
Thanks.
Dave
Tanel Alumae
Greenhorn

Joined: Aug 26, 2002
Posts: 14
Connection pooling is usually done to improve application performance and decrease the load on the database.
DriverManager is only responsible for creating new connection to the database. As you probably know, creating a connection and logging in to the database is relatively time-consuming. Therefore, connection pool is often used. A connection pool is like a facade to the DriverManager. Application can use the Connection Pool to ask for a connection to database. Connection Pool caches the connections to the database. This means that once an application ends using a database connection (e.g. at the end of transaction), Connection Pool does not release it, but reuses it when the application asks for the connection again. Anyway, you can find much information on this topic for example here.
[ September 09, 2002: Message edited by: Tanel Alumae ]

RefactorIT - Java Refactoring Tool<br /><a href="http://www.refactorit.com" target="_blank" rel="nofollow">www.refactorit.com</a>
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: why need connection pool