Re: [JDBC] [GENERAL] Idle in transaction state.

2006-09-10 Thread Dave Cramer
On 10-Sep-06, at 12:12 AM, Jack Orenstein wrote: Tom Lane wrote: "Peter L. Berghold" <[EMAIL PROTECTED]> writes: 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) idl

Re: [GENERAL] Idle in transaction state.

2006-09-09 Thread Jack Orenstein
Tom Lane wrote: "Peter L. Berghold" <[EMAIL PROTECTED]> writes: 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" "idle" is fine, "idle in transaction" is not so f

Re: [GENERAL] Idle in transaction state.

2006-09-09 Thread Dave Cramer
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)

Re: [GENERAL] Idle in transaction state.

2006-09-09 Thread Tom Lane
"Peter L. Berghold" <[EMAIL PROTECTED]> writes: > 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" "idle" is fine, "idle in transaction" is not so fine, because t

[GENERAL] Idle in transaction state.

2006-09-09 Thread Peter L. Berghold
-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