Idle in transaction state.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi folks,

I've run into an issue that I'm sure there's a fix for, I just haven't
quite figured it out on my own.

First the overview of the environment:
Linux (CentOS release 4.2)
Tomcat 5.x application server
Struts/Tiles MVC
Hibernate 3.1 Object Persistence
postgresql-8.2dev-500.jdbc2.jar for JDBC drivers

What I'm seeing is the first time my web application is being run there
is a bunch of processes running around that look like:
"postgres: peter peter_trialdb 127.0.0.1(46222) idle"

in the process table. What's worse, is if I try to modify my database
schema while these processes are running (and they seem to stick around
forever) the psql session running the SQL script to do the modifications
hangs on the first statement that modifies or drops an existing table.

I'm not even sure what part of this puzzle is the root cause of the
problem. JDBC drivers? Hibernate configuration? Elvis?

Any insight is welcome and appreciated.

- --
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
Peter L. Berghold Peter(at)Berghold(dot)Net
"Those who fail to learn from history are condemned to repeat it."
AIM: redcowdawg Yahoo IM: blue_cowdawg ICQ: 11455958
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Red Hat - http://enigmail.mozdev.org

iD8DBQFFAwRuUM9/01RIhaARAvouAJ9S5BT0aDd4MR2Ps0XXUOCVCU5/vACgtU2E
+drcu3MQ1wVPWq7FnanBOa0=
=xqRU
-----END PGP SIGNATURE-----