Hi, Why don't you use the JDBC 2.0 compliant connection pool open-source set up provided by Apache under Commons DBCP. It can connect to any database as long you have a DataSource for the database. You need to set up the pool in server.xml and refer that resource in the web.xml to make use of the pool. No change in the code is required if you get the datasource from JNDI in your code.
Regards, Partha > ---------- > From: A mailing list about Java Server Pages specification and > reference[SMTP:[EMAIL PROTECTED] on behalf of Ananthalakshmi > Subramaniyam[SMTP:[EMAIL PROTECTED] > Sent: Tuesday, November 30, 2004 11:08 AM > To: [EMAIL PROTECTED] > Subject: Re: Connection Pool > > Hi, > > Are you using Oracle JDBC 2.0 Driver and Jdk 1.3 or greater? > Why can't you try the oracle connection pool, built-in package implemented > in Oracle JDBC driver. > Please go through Oracle JDBC Developer Guide for the implementation > details. > > Thanks, > H.Ananthalakshmi. > > >From: sandeepK <[EMAIL PROTECTED]> > >Reply-To: A mailing list about Java Server Pages specification and > >reference <[EMAIL PROTECTED]> > >To: [EMAIL PROTECTED] > >Subject: Re: Connection Pool > >Date: Thu, 9 Dec 2004 08:33:54 -0800 > > > >yes i can give you the Connection Pool code I have developed for oracle > >database. > > > >Sandeep Katiyar > > > >----- Original Message ----- > >From: "Edward King" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Monday, November 29, 2004 5:30 PM > >Subject: Connection Pool > > > > > > > Hello every, > > > I want to use Connection Pool which can connect into Oracle Database > >in > >JSP,I use one,but that connection pool often raise Http 500 errors,I am > >very > >puzzled with connection pool.Would you give me a advice where I can get a > >free Connection Pool which has good performance? > > > Thanks in advance! > > > > > > > >=========================================================================== > > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > >JSP-INTEREST". > > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > >DIGEST". > > > > > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > > > > > http://java.sun.com/products/jsp > > > http://archives.java.sun.com/jsp-interest.html > > > http://forums.java.sun.com > > > http://www.jspinsider.com > > > > > > >=========================================================================== > >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > >JSP-INTEREST". > >For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > >DIGEST". > > > >Some relevant archives, FAQs and Forums on JSPs can be found at: > > > > http://java.sun.com/products/jsp > > http://archives.java.sun.com/jsp-interest.html > > http://forums.java.sun.com > > http://www.jspinsider.com > > _________________________________________________________________ > Chat with thousands of singles. > http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?74 Only on > BharatMatrimony.com's Instant Messenger. > > =========================================================================== > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > http://java.sun.com/products/jsp > http://archives.java.sun.com/jsp-interest.html > http://forums.java.sun.com > http://www.jspinsider.com > =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com
