Hi,
You might have already know that SUN JDBC 2.0 optional package provides connection pooling feature. Please refer SUN JDBC documentation for more details.
Since you are dealing with Oracle database, Oracle JDBC driver provides APIs to handle efficient batch execution,built-in connection pooling package, etc, which you can use in java/jsp code.
Generally, it is not preferrable to handle database operations in a 3 tier architecture, where JSP is used only for presentation and all the JDBC related stuff should be handled in DAO(Data Access Objects). Please refer MVC architecture for more details.
Oracle JDBC Developer's Guide: http://download-west.oracle.com/docs/cd/B10501_01/java.920/a96654/toc.htm Please see Connection Pooling and Caching section.
Oracle JDBC java documentation: http://download-east.oracle.com/otn_hosted_doc/jdeveloper/904preview/jdbc-javadoc/
Oracle JDBC Frequently Asked Questions: http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#36_00
Thanks, H.Ananthalakshmi.
From: Edward King <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: Connection Pool Date: Tue, 30 Nov 2004 13:46:23 +0800
Mr Ananthalakshmi Where can I get built-in package of Oracle JDBC driver? Would you give me some examples which call it in JSP? Thanks
----- Original Message ----- From: "Ananthalakshmi Subramaniyam" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 30, 2004 1:38 PM 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 > >
_________________________________________________________________ Life on the fast track! Get hooked to it! http://server1.msn.co.in/sp04/tataracing/ Meet the champs!
=========================================================================== 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
