Robert - Don Bales in his recent book "Java Programming with Oracle JDBC" (O'Reilly) describes 4 strategies for Java servlet database connections: 1. Per-transaction connection. Each method opens and closes the connection. Most CGI programs use this and it is the least efficient. 2. Dedicated connection. The servlet uses one connection that remains open during the servlet's entire lifetime and is shared by all users of the servlet. 3. Session connection. Store the connection in an HTTP session object, from which it can be retrieved and used by the other method calls invoked in the same user session. 4. Cached connection. Use a connection pool to minimize the total number of connections that are open at any one time. That is a very fast overview, Don has an entire chapter on this subject. Oracle has pinned its future on the success of Java. I think we DBAs are going to need to understand these issues much better in the future in order to communicate with our Java programmers. Bottom line is that I think that when application servers are involved, the issue becomes more complex than just persistent vs. login/logout. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED]
-----Original Message----- Sent: Monday, April 29, 2002 12:40 PM To: Multiple recipients of list ORACLE-L Looking for any white papers on the above topic with business cases, testing results, etc....Anyone know of any...? RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
