You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-cs@ibatis.apache.org by Juan Pablo Araya <ju...@gmail.com> on 2009/01/12 14:34:17 UTC
How to check the use and reliability in the connection pooling
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
RE: How to check the use and reliability in the connection pooling
Posted by "Nicholas L. Piasecki" <ni...@piasecki.name>.
It lives in IBatisNet.* namespace
IBatisNet.Common.*
IBatisNet.DataAccess.*
IBatisNet.DataMapper.*
e.g. for logging the prepared commands that are generated....
<logger name="IBatisNet.DataMapper.Commands.DefaultPreparedCommand">
<level value="DEBUG" />
</logger>
V/R,
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 <ju...@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 <cl...@gmail.com>
> wrote:
>> Enable log4j DEBUG on com.ibatis and java.sql.
>>
>> Clinton
>>
>> On 1/12/09, Juan Pablo Araya <ju...@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
Re: How to check the use and reliability in the connection pooling
Posted by Clinton Begin <cl...@gmail.com>.
Lol... Sometimes I forget to check the list name. :-)
On 1/12/09, Juan Pablo Araya <ju...@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 <cl...@gmail.com>
> wrote:
>> Enable log4j DEBUG on com.ibatis and java.sql.
>>
>> Clinton
>>
>> On 1/12/09, Juan Pablo Araya <ju...@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
Re: How to check the use and reliability in the connection pooling
Posted by Juan Pablo Araya <ju...@gmail.com>.
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 <cl...@gmail.com> wrote:
> Enable log4j DEBUG on com.ibatis and java.sql.
>
> Clinton
>
> On 1/12/09, Juan Pablo Araya <ju...@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
Re: How to check the use and reliability in the connection pooling
Posted by Clinton Begin <cl...@gmail.com>.
Enable log4j DEBUG on com.ibatis and java.sql.
Clinton
On 1/12/09, Juan Pablo Araya <ju...@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