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 question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection Pool question" Watch "Connection Pool question" New topic
Author

Connection Pool question

Ken Shamrock
Ranch Hand

Joined: Jan 23, 2002
Posts: 139
Hi all, I haven't come to this forum for 2 years as I have not play programming for a period, now I come back.

In the past, when I use tomcat with MySQL, I get a connection pool java made by someone and use it with Servlet, now, I will use jsp/servlet with Database MSSQL, I wonder if I still need to use connection pool anymore? Or MSSQL can take care of the connections? Thanks


Thanks everyone who helped me
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29261
    
140

Ken,
You should still use a connection pool at the Java end. The connection to the database itself is expensive which the connection pool protects you from.


[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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Connection Pool question
 
Similar Threads
running out of ManagedConnections available
Connection Pooling help
Using Connection Pool question again
how to use connection pools in wl6.1
Connection Pooling for my web application