ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: postgresql: idle in transaction
Date Tue, 04 Jan 2005 16:45:44 GMT
Try this...

<transactionManager ... commitRequired="true">

By default iBATIS only commits on non-queries (insert/update/delete/proc).  

Cheers,
Clinton


On Tue, 04 Jan 2005 10:35:10 +0100, Baldur Norddahl
<bbn-ibatis@inaphone.com> wrote:
> Hi,
> 
> I am trying to avoid that all my connections ends up in state "idle in
> transaction" like this:
> 
> bbn@vacuum2:~$ ps ax | grep "postres: secure"
> 11249 ?        S      0:00 postgres: secure db 192.168.2.121 idle in
> transaction
> 
> With the old version af iBatis and our php projects, that status is only
> "idle" (unless the connection is currently working on a query).
> 
> Clinton Begin advised me to try <transactionManager type="JDBC"
> commitRequired="true"> in the config file. I am going to use this
> setting anyway so my stored procedures work correctly, but it does not
> seem to have any effect on the "idle in transaction" problem.
> 
> It does not seem to have any bad effects on the system, but from a
> system admin perspective I would like to avoid it, so I can have my
> scripts warn me if those starts piling up. They are a sign that somebody
> is not handling their transactions correctly.
> 
> Baldur
>

Mime
View raw message