Re: pros/cons of dedicated vs. MTS connections?

From: Joe Weinstein <joeNOSPAM_at_bea.com>
Date: Wed, 14 Sep 2005 09:33:56 -0700
Message-ID: <432850F4.4070402@bea.com>

Mark Bole wrote:
> Billy wrote:
>

>> Joe Weinstein wrote:
>>
>>> Hi. I have an application which makes several (10-50)
>>> separate JDBC connections to an Oracle DBMS, and uses
>>> these connections indefinitely. Can you tell me any
>>> reason I would prefer or care about whether the DBMS
>>> is configured sa MTS or not?

>
> [...]
>

>> I will especially insist on using MTS for JDBC connections - assuming
>> this is from an app server. I have lost count of the number of times
>> app servers fail to close connections when done (guess this can be
>> called pooled connection leaking on the app server side).

>
> That's the whole point of a JDBC connection pool -- you never close the
> connection.

...

Thanks again Mark. I found this online commentary on MTS that concurs with you and most others that MTS should be avoided in most cases:

http://www.dba-oracle.com/t_mts_multithreaded_servers_shared.htm

Joe Weinstein at BEA Received on Wed Sep 14 2005 - 11:33:56 CDT