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 which way is better to initialize connection pool? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "which way is better to initialize connection pool?" Watch "which way is better to initialize connection pool?" New topic
Author

which way is better to initialize connection pool?

Ego Tang
Greenhorn

Joined: Oct 01, 2002
Posts: 11
Hi ranchers,
I am not sure which is a better way to initialize a connection pool: to initialize it declaratively(e.g. configure it in server.xml in Tomcat), or construct it programmatically(implement ConnectionPoolDataSource)?
Moreover, I am trying to use a disconnected CachedRowSet to cache the returned resultset, do I need to close it after using it?
Many thanks!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: which way is better to initialize connection pool?