wood burning stoves 2.0*
The moose likes JDBC and the fly likes Connection pooling with SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection pooling with SQL Server" Watch "Connection pooling with SQL Server" New topic
Author

Connection pooling with SQL Server

Syed Hussain
Ranch Hand

Joined: Feb 06, 2001
Posts: 55
Hi,
I am accessing SQL Server database which is located on another PC , from a linux PC through a jsp page using a pure jdbc driver but still the connection is very slow.I am using the Tomcat Servlet Engine.Could anyone tell me how to use connection pooling with my application.
Waiting in anticipation.
Syed.
bill bozeman
Ranch Hand

Joined: Jun 30, 2000
Posts: 1070
Here is a link for a couple of different implementations of connection pooling. Basic idea is to have a servlet open on load of the web server, and that opens a certain number of connections to the database. Then have each of your servlets or jsp pages, grab one of those open connections and use that for database access. I have seen 3 or 4 different ways of doing this as I am trying to do one for a MySql database.
http://www.webdevelopersjournal.com/columns/connection_pool.html http://archive.coreservlets.com/Chapter18.html
I am about to finish compiling the different version I have seen and taking out the peices I want for a site I am working. Once I finish it, I will be posting it at this site: www.javaworkshop.net
Hope that helps.
Bill
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection pooling with SQL Server
 
Similar Threads
What is "Connection Pooling"
Newbie Conn Pool question
Connection Pooling : which one should i use?
connection pooling in websphere 5.1
Resultset in session