-----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@xxxxxxxxxxxx "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:peter@xxxxxxxxxxxx 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
