Thread: Idle in Transaction

Idle in Transaction

From
Jim Downing
Date:
Hi all,

I have a problem whereby every time my java application tries to
commit a transaction a new postgresql process is spawned which is
marked 'Idle in Transaction'. Could anybody tell me what situations
(in the context of using the jdbc driver) these 'idle in transaction'
threads are created?

I'm using a persistence framework (Hibernate as it happens), but
no-one else has had this problem with that framework, so I suspect
it's something to do with the way I have postgres configured, or else
my code (looking most likely atm).

Regards,

jim

Jim Downing
Paribus

Re: Idle in Transaction

From
Dave Cramer
Date:
Jim,

I'm just about to start playing with Hibernate, so I'm more than
interested in this.

Does hibernate use connection pools?

Dave
On Sun, 2003-01-05 at 12:00, Jim Downing wrote:
> Hi all,
>
> I have a problem whereby every time my java application tries to
> commit a transaction a new postgresql process is spawned which is
> marked 'Idle in Transaction'. Could anybody tell me what situations
> (in the context of using the jdbc driver) these 'idle in transaction'
> threads are created?
>
> I'm using a persistence framework (Hibernate as it happens), but
> no-one else has had this problem with that framework, so I suspect
> it's something to do with the way I have postgres configured, or else
> my code (looking most likely atm).
>
> Regards,
>
> jim
>
> Jim Downing
> Paribus
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Dave Cramer <Dave@micro-automation.net>