ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nicholas L. Piasecki" <nicho...@piasecki.name>
Subject RE: How to check the use and reliability in the connection pooling
Date Mon, 12 Jan 2009 21:26:15 GMT
It lives in IBatisNet.* namespace


e.g. for logging the prepared commands that are generated....

<logger name="IBatisNet.DataMapper.Commands.DefaultPreparedCommand">
    <level value="DEBUG" />

Nicholas Piasecki

-----Original Message-----
From: Clinton Begin [mailto:clinton.begin@gmail.com] 
Sent: Monday, January 12, 2009 1:11 PM
To: user-cs@ibatis.apache.org
Subject: Re: How to check the use and reliability in the connection pooling

Lol...  Sometimes I forget to check the list name.  :-)

On 1/12/09, Juan Pablo Araya <juanpablo.araya@gmail.com> wrote:
> 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

Sent from my mobile device

View raw message