X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A1D975287E for ; Wed, 20 Jul 2005 03:29:05 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 88491-04 for ; Wed, 20 Jul 2005 06:28:55 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.197]) by svr1.postgresql.org (Postfix) with ESMTP id 4320D529B5 for ; Wed, 20 Jul 2005 03:28:53 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id j2so1353329nzf for ; Tue, 19 Jul 2005 23:28:54 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=BrgSuVRKWJFRSNy/hMgRJ4fnkAt6E1x+abgQYR0xpgJQxe35QmzoAg18+ah1Gxg2+e65I2iIh07Q0pzojbEVVIzK/KSuM2O9IRm7ztc03s8TzspBudLfoQRYaQJmkr7mZi/VCI75gqT01/BjySul7GmVeGqtjDtiwTM7BqCYfBY= Received: by 10.36.48.13 with SMTP id v13mr5056299nzv; Tue, 19 Jul 2005 23:28:25 -0700 (PDT) Received: by 10.36.221.58 with HTTP; Tue, 19 Jul 2005 23:28:25 -0700 (PDT) Message-ID: Date: Wed, 20 Jul 2005 08:28:25 +0200 From: imi Reply-To: imi To: FM Subject: Re: PGSQL 7.4.8 : idle in transaction problem Cc: Mailing List Postgres-Admin In-Reply-To: <42DD5955.8000501@lexum.umontreal.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <42DD5955.8000501@lexum.umontreal.ca> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.94 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP, RCVD_IN_BL_SPAMCOP_NET X-Spam-Level: X-Archive-Number: 200507/141 X-Sequence-Number: 18197 Hello, (Sorry my english) I saw this words in my 'ps -Af'. JBOSS use jdbc driver for postgres. In java the Connection has a method: setAutoCommit(boolen). Those connections where autocommit=3Dfalse, and after the last sql command (select, insert, update) NOT have rollback or commit, state will "idle in transaction". I'm sorry but I don't know how can you setup autocommit feature in the JBOS= S. linimi On 7/19/05, FM wrote: > Hello, >=20 > We are using JBOSS and postgresql on 1 database (DB1). From time to time > the JBOSS process . >=20 > What is strange is that users on all DB (not only DB1) are affected by > the JBOSS . > I understand that it locked DB1 but why it also locked users on others DB= ? >=20 > Thanks ! >=20 >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >