This error occour  if you have not closed connection after each use or
release connection after each use. If you have own connection pool code make
sure that you are releasing the connection after each use.If you are
relasing connection properly then most of time number of connection in pool
doesnt exceed default connections.

"Release connection before every sendRedirect or forward ."

Have a nice day

Balkrishna R Parab



        -----Original Message-----
        From:   Madhan M Srinivasan [SMTP:[EMAIL PROTECTED]]
        Sent:   Tuesday, March 06, 2001 2:03 AM
        To:     [EMAIL PROTECTED]
        Subject:        [JSP-INTEREST] connection pooling

        Hai

        In our prj.. we are using connection pooling with db as oracle in
win nt .we are recving an error :
        number of connection exceeded 200 .
        we 've set the max no of connection as 200 and every page accessing
the bean (connection pooling ) @ the
        end of every page a method from the bean is called to
        throw the connection to a hashtable ..

        can any one help out

        Regs

        Madhan Srinivasan


        ______________________________________________________
        123India.com - India's Premier Portal
        Get your Free Email Account at http://www.123india.com


===========================================================================
        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

Reply via email to