Thank for your recommendatoin A new quesion is I'm using Servlet and jsp together and I need a container that support both of them and connection pooling to have you any suggestion? And new question is how can I find best number of upper and lower limit of pool connection? And finally has there any way to let some of the pages has het more connection from the pool and some less? I'm using oracle 8i and tomcat 3.1 If you know and article about these thinks please let me know Thanks >From: Rogério Saran <[EMAIL PROTECTED]> >Reply-To: A mailing list about Java Server Pages specification and > reference <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: Can anydoby help me in database connection type for > bestperformance >Date: Tue, 8 Aug 2000 09:22:10 -0300 > >There are two good and simple approaches: > >The fastest way to communicate with your database: a highly optimized >type 2 driver and a good connection pooling manager. > >Almost so fast and also a lot more portable: type 4 driver and >connection pooling again. > >We are building a project with JSP, and to keep things simple we >installed a high performance servlet container (Resin) with embedded >connection pooling support. If your servlet runner does not handle >connection pooling try a driver who does it, like Ashna's JTurbo >Enterprise (it´s a type 4 driver.) > > > >Hooman Ahmadi wrote: > > > > I try to make connection with best performance But I don't know when I > > should use Connection Pooling or when I should for example Singleton > > Patrern or ... > > > > Can any body help me > > ________________________________________________________________________ > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > > > >=========================================================================== > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff >JSP-INTEREST". > > 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". >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 ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". 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