ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Juan Pablo Araya" <juanpablo.ar...@gmail.com>
Subject Re: How to check the use and reliability in the connection pooling
Date Mon, 12 Jan 2009 16:53:54 GMT
Thanks, It's the same way for C#?

Greetings and sorry for my poor English

On Mon, Jan 12, 2009 at 12:25 PM, Clinton Begin <clinton.begin@gmail.com> wrote:
> Enable log4j DEBUG on com.ibatis and java.sql.
>
> Clinton
>
> On 1/12/09, Juan Pablo Araya <juanpablo.araya@gmail.com> wrote:
>> Hi all,
>>
>> We are auditing a big web system with his own "mapper" (it's from
>> 2002) that use a lot of connections. Each day they have to reset the
>> web server in wich the application run, because it use up all the
>> connections from the pooling service. A few days ago we used the
>> system and the DBA called us because we exhausted the Oracle
>> connections in the development server.
>>
>> In this moment, under development, the system developers set the
>> connection pooling to false so they can work on it.
>>
>> As far as I know, the problem arises in the data access layer because
>> they don't release the register, connection or whatever related,
>> waiting for the garbage collector to return the resource to the
>> pooling service.
>>
>> One of our solutions (they have a profile database in which query for
>> every asp control before they render it; it's very hard in
>> connections) is to use a better connection layer (iBatis).
>>
>> ┬┐How can I log or see when iBatis take one resource from the pooling
>> and release it, without debugging the source? It's very important to
>> check the reliability because of the profile base for the system.
>>
>> Greetings!
>>
>> --
>> Juan Pablo Araya
>>
>
> --
> Sent from my mobile device
>



-- 
Juan Pablo Araya

Mime
View raw message