RE: ora-4031 & large_pool
- From: "Craig Munday" <Craig.Munday@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 25 May 2004 13:00:41 +1000
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@xxxxxxxxxxxx http://www.gdaus.com.au
-----Original Message-----
From: Ryan [mailto:ryan.gaffuri@xxxxxxx]=20
Sent: Wednesday, 19 May 2004 12:44 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
