| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: persistent connections vs. login/logout white papers anyone?
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.
dwilliams_at_lifetouch.com
-----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: Robert_Freeman_at_csx.com
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Mon Apr 29 2002 - 14:03:43 CDT
 |
 |