Connection Pool

[kri shan]

In what situation we write our own connection pool instead of using the Appserver's Connection Pool service ?

[Shailesh Chandra]

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

[kri shan]

Hi Shailesh, What scenario we use own connection pool ?

[Adeel Ansari]

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.