File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Connection Pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection Pool" Watch "Connection Pool" New topic
Author

Connection Pool

kri shan
Ranch Hand

Joined: Apr 08, 2004
Posts: 1372
In what situation we write our own connection pool instead of using the Appserver's Connection Pool service ?
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

If connection pool is available from App server, then I dont think we should re invent the wheel.

If still there is some scenario where we should use own connection pool then I will really welcome.

becuase creating connection pool needs lot of consideration otherwise pool can be very nasty to system.


thanks


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
kri shan
Ranch Hand

Joined: Apr 08, 2004
Posts: 1372
Hi Shailesh, What scenario we use own connection pool ?
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
Originally posted by kri shan:
Hi Shailesh, What scenario we use own connection pool ?


If there is some Shailesh will welcome.

you can use DBCP from Apache, a ready made API, to implement a connection pooling mechanism. I use it with Tomcat.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Connection Pool