Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 18171 invoked from network); 7 Jul 2010 14:57:21 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 7 Jul 2010 14:57:21 -0000 Received: (qmail 64387 invoked by uid 500); 7 Jul 2010 14:57:21 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 64309 invoked by uid 500); 7 Jul 2010 14:57:20 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Delivered-To: moderator for derby-user@db.apache.org Received: (qmail 34617 invoked by uid 99); 7 Jul 2010 13:44:03 -0000 X-ASF-Spam-Status: No, hits=0.7 required=10.0 tests=RCVD_IN_DNSWL_NONE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) X-Belgacom-Dynamic: yes X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AkkFAEMhNExXQE83/2dsb2JhbACTVoxAcsEMhSQE From: rjlist@nextmind.net Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Subject: XA Transaction Prepared Date: Wed, 7 Jul 2010 15:42:30 +0200 Message-Id: To: derby-user@db.apache.org Mime-Version: 1.0 (Apple Message framework v1081) X-Mailer: Apple Mail (2.1081) X-Virus-Checked: Checked by ClamAV on apache.org Hi List, we are using Derby as DB with JBOSS with an XA datasource, Now I'm facing a problem after a jboss errors we ha a UserTransaction = in state PREPARED this transaction locks some tables and every sql calls = fail on lock acquisition... ;( Does anyone know a way to rollaback/delete this transaction ? ij> SELECT XID,TYPE,STATUS FROM SYSCS_DIAG.TRANSACTION_TABLE; XID |TYPE |STATUS =20 ------------------------------------------------------- 279580 |SystemTransaction |IDLE =20 279648 |UserTransaction |IDLE =20 269843 |UserTransaction |PREPARED any help, pointer will be appreciated thank -Patrick=