Return-Path: Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: (qmail 28463 invoked from network); 13 Feb 2011 08:14:20 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 13 Feb 2011 08:14:20 -0000 Received: (qmail 68113 invoked by uid 500); 13 Feb 2011 08:14:20 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 67868 invoked by uid 500); 13 Feb 2011 08:14:17 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 67860 invoked by uid 99); 13 Feb 2011 08:14:16 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 13 Feb 2011 08:14:16 +0000 X-ASF-Spam-Status: No, hits=0.0 required=5.0 tests=FREEMAIL_FROM,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of mtylenda@o2.pl designates 193.17.41.186 as permitted sender) Received: from [193.17.41.186] (HELO moh2-ve1.go2.pl) (193.17.41.186) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 13 Feb 2011 08:14:08 +0000 Received: from moh2-ve1.go2.pl (unknown [10.0.0.186]) by moh2-ve1.go2.pl (Postfix) with ESMTP id 13E5E44C17C for ; Sun, 13 Feb 2011 09:13:47 +0100 (CET) Received: from o2.pl (unknown [10.0.0.67]) by moh2-ve1.go2.pl (Postfix) with SMTP for ; Sun, 13 Feb 2011 09:13:45 +0100 (CET) Subject: =?UTF-8?Q?Re:_EntityManager_dosn't_release_?= =?UTF-8?Q?connection_in_XA_transactions?= From: =?UTF-8?Q?Mi=C5=82osz?= To: users@openjpa.apache.org Mime-Version: 1.0 Message-ID: <3fcee76c.e2b07d5.4d5792b8.6d2c8@o2.pl> Date: Sun, 13 Feb 2011 09:13:44 +0100 X-Originator: 79.186.150.179 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org Hi=20Sargol, I=20don't=20think=20there=20is=20an=20OpenJPA=20property=20which=20would=20= help=20you=20here.=20If=20you=20want=20to=20lower=20the=20isolation=20lev= el,=20try=20doing=20it=20on=20the=20datasource=20configuration=20or=20whe= rever=20you=20configure=20the=20distributed=20transaction=20instead=20of=20= setting=20the=20openjpa.jdbc.TransactionIsolation=20property. I=20would=20recommend=20that=20you=20first=20figure=20out=20the=20sequenc= e=20of=20SQL=20statements=20that=20leads=20to=20the=20lock=20timeout=20er= ror.=20It=20is=20a=20tedious=20job=20but=20without=20it=20you=20risk=20lo= oking=20blindly=20for=20the=20solution. Cheers, Milosz >=20 >=20Hi, >=20For=20your=20information,=20we=20got=20the=20"ORA-02049:=20timeout:=20= distributed >=20transaction=20waiting=20for=20lock"=20error=20when=20the=20.net=20sid= e=20of=20application=20had >=20not=20been=20 >=20involved=20in=20the=20transaction.=20Does=20it=20show=20that=20the=20= problem=20is=20not=20related=20to >=20the=20distributed=20transaction=20configurations?=20Is=20there=20any=20= special=20property >=20that=20we=20 >=20must=20have=20configured=20regarding=20Openjpa=20locking.=20 >=20 >=20Thank=20you=20in=20advance. >=20 >=20Regards, >=20Sargol=20=20 >=20