aspose file tools
The moose likes JDBC and the fly likes Connection Pool question Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply 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: 26193
    
  66

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
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Connection Pool question
 
Similar Threads
Connection Pooling for my web application
running out of ManagedConnections available
Using Connection Pool question again
how to use connection pools in wl6.1
Connection Pooling help