RE: ora-4031 & large

From: Craig Munday <Craig.Munday_at_au.gi-de.com>
Date: Tue, 25 May 2004 13:00:41 +1000
Message-ID: <16B8B61095E267428530B6060CB6007801363A@syd1-1s.gdaus.com.au>

Ryan,

Just because you are using connection pooling, it DOES NOT mean that you are using XA. Similarly, just because you are using XA it does not mean that you are using a connection pool. This is largely application server dependent so you should check what your app server does.

If your transactions call components (eg EJBs) that all run within the same address space (or process) it is possible for an application server to ensure that the same (non-XA) connection is "retrieved" from the connection pool each time a component asks for one. JBoss works this way.

Of course if your application makes calls to components that exist within difference address spaces (processes or servers) you will have to configure XA to ensure that your transactions execute within the same context.

Craig Munday
Software Development Manager
Giesecke & Devrient Australasia P/L, 32 Birnie Ave, Lidcombe 2141 Phone: +61 2 9646 6200 Fax: +61 2 9749 1678 Craig.Munday@au.gi-de.com http://www.gdaus.com.au

-----Original Message-----

From: Ryan [mailto:ryan.gaffuri_at_cox.net]=20 Sent: Wednesday, 19 May 2004 12:44 PM
To: oracle-l_at_freelists.org
Subject: Re: ora-4031 & large_pool

how does connection pooling automatically use XA? We use IIS for ours? I thought it was all handled at the middle tier?
----- Original Message -----=20

From: "DENNIS WILLIAMS" <DWILLIAMS_at_LIFETOUCH.COM> To: <oracle-l_at_freelists.org>
Sent: Tuesday, May 18, 2004 8:38 PM
Subject: RE: ora-4031 & large_pool

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Mon May 24 2004 - 21:56:25 CDT