In general it is good advice to Stay away from thin client JDBC implementations as their design has little to offer in the pooling arena specifically and JDBC design does not support threading generally Much better to Stay closer to Thick Client implementations which support DB specific pooling activities which are closely synchronised with the DB Server threads (refer to OCI spec from Oracle)
for Implementation details please refer to OCI doc located at http://www.stanford.edu/dept/itss/docs/oracle/9i/java.920/a96654/oci_func.htm#1014118
Learn and use Transaction Management capabilities by calling DB du jour Procedures with appropriate input/output parameter(s)
for Implementation details please refer to Oracle Procedures doc located at http://www-db.stanford.edu/~ullman/fcdb/oracle/or-plsql.html#procedures
Good Luck/ Viel Gluck,
Martin Gainty ______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relating to the official business of Laconia Data Systems (LDS) is proprietary to the company. It is confidential, legally privileged and protected by law. LDS does not own and endorse any other content. (mobile) Etats Unis / US 001-617-852-7822
From: Ananthalakshmi Subramaniyam <[EMAIL PROTECTED]> Reply-To: A mailing list about Java Server Pages specification and reference <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: Connection Pool Date: Tue, 30 Nov 2004 13:46:14 +0530 MIME-Version: 1.0 X-Originating-IP: [193.32.3.82] X-Originating-Email: [EMAIL PROTECTED] X-Sender: [EMAIL PROTECTED] Received: from mc4-f41.hotmail.com ([65.54.190.177]) by mc4-s7.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Tue, 30 Nov 2004 00:17:44 -0800 Received: from swjscmail2.java.sun.com ([192.18.99.108]) by mc4-f41.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Tue, 30 Nov 2004 00:17:43 -0800 Received: from swjscmail1 (swjscmail1.Sun.COM [192.18.99.107])by swjscmail2.java.sun.com (Postfix) with ESMTPid B8C56217BF; Tue, 30 Nov 2004 01:10:07 -0700 (MST) Received: from JAVA.SUN.COM by JAVA.SUN.COM (LISTSERV-TCP/IP release 1.8e) with spool id 47559806 for [EMAIL PROTECTED]; Tue, 30 Nov 2004 01:04:55 -0700 Received: from hotmail.com (bay10-f18.bay10.hotmail.com [64.4.37.18]) by swjscmail1.java.sun.com (Postfix) with ESMTP id E6CE14D19 for <[EMAIL PROTECTED]>; Tue, 30 Nov 2004 01:04:54 -0700 (MST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 30 Nov 2004 00:17:02 -0800 Received: from 193.32.3.82 by by10fd.bay10.hotmail.msn.com with HTTP; Tue, 30 Nov 2004 08:16:14 GMT X-Message-Info: 29Fz9OI/FljKlX/3LrMpzABnz/r/XDFgyDImUlBy/Gs= X-Original-To: [EMAIL PROTECTED] Delivered-To: [EMAIL PROTECTED] X-OriginalArrivalTime: 30 Nov 2004 08:17:02.0087 (UTC) FILETIME=[F843D970:01C4D6B4] Comments: To: [EMAIL PROTECTED] Precedence: list Return-Path: [EMAIL PROTECTED]
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
=========================================================================== 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
