You can also try PoolMan (forgot the URL).
You just use jdbc:poolman://yourdatabase instead of the real
url.
Configure poolman using the poolman.xml
code the program as you normally do without a connection
pool or cache.
when you do someConnection.close() instead of closing it
just returns it to the pool.
Ashish
a x h i x h @ y a h o o . c o m
Get your free headlines at http://headlines.sourceforge.net
------------------------------
"Chawla, Mehar" wrote:
>
> Hi all,
>
> Can anyone tell me how to implement JDBC connection pooling in Tomcat.
> Basically I want the following things :
>
> 1. Setup the connection pool in web.xml or server.xml with oracle user
> name and password set up in that file itself to avoid harcoding the username
> and password
> in the servlets or jsp files.
> 2. Create a Servlet with methods GetConnection and ReleaseConnection
> (not close connection) to return the connection back to the pool and which
> should be loaded on startup of the web server (Tomcat)
> 3. And finally the jsp code to get the connection from that servlet.
>
> I would appericiate if you could help me in setting this up by providing
> the sample code.
>
> P.S. I have Tomcat 3.2.1 and Oracle 8.1.7
>
> thanks very much.
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets