-----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                                     [EMAIL PROTECTED]
"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-----
begin:vcard
fn:Peter  L. Berghold
n:Berghold;Peter 
org:IBM;GSD
email;internet:[EMAIL PROTECTED]
title:Unix Specialist
tel;work:(732) 918-1487
tel;fax:(732) 982-1632
x-mozilla-html:FALSE
url:http://www.berghold.net
version:2.1
end:vcard

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to