Peter,
On 9-Sep-06, at 2:14 PM, Peter L. Berghold wrote:
-----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"
I presume you mean "idle in transaction"
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?
It's the pooling implementation, it should be setting autocommit to
true when closing the connection, which really means returning the
connection to the pool.
Any insight is welcome and appreciated.
Dave
- --
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
::
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-----
<Peter.vcf>
---------------------------(end of
broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
