| 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: connection pooling from an application server to oracle
Ryan
It depends on the application. For most applications the app. server connection pooling works satisfactorily (with grumbling from the DBA). For other applications that isn't good enough. An example might be a high-security financial application where you must trace each connection and transaction back to a specific user. Everyone has their own Oracle username.
Bale's book Java Programming with Oracle JDBC describes three connection models for Java programs.
http://www.amazon.com/exec/obidos/tg/detail/-/059600088X/qid=1071503575//ref =sr_8_xs_ap_i1_xgl14/103-7713527-1855831?v=glance&s=books&n=507846
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Monday, December 15, 2003 6:59 AM
To: Multiple recipients of list ORACLE-L
The software engineers here are using an application server with connection pooling to connect to our oracle instances. They are doing it with a dedicated connection to Oracle. No MTS.
they compartmentalize stuff here, so Im having trouble figuring out exactly how this affects the database and how to monitor performance. All I know is that I see a handful of constantly open dedicated connections. I have been told that this is actually alot of users connecting to the database.
This concerns me. how do you handle transaction control in this type of environment? in this type of environment do you have to commit after every DML statement? since multiple users will access the database with the same conneciton?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <ryan_oracle_at_cox.net
INET: ryan_oracle_at_cox.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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 Dec 15 2003 - 09:54:34 CST
 |
 |