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
