Return-Path: 
 <user-return-12094-apmail-geronimo-user-archive=geronimo.apache.org@geronimo.apache.org>
Delivered-To: apmail-geronimo-user-archive@www.apache.org
Received: (qmail 67801 invoked from network); 4 Dec 2008 15:11:21 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 4 Dec 2008 15:11:21 -0000
Received: (qmail 1943 invoked by uid 500); 4 Dec 2008 15:11:26 -0000
Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org
Received: (qmail 1920 invoked by uid 500); 4 Dec 2008 15:11:26 -0000
Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:user-help@geronimo.apache.org>
list-unsubscribe: <mailto:user-unsubscribe@geronimo.apache.org>
List-Post: <mailto:user@geronimo.apache.org>
Reply-To: user@geronimo.apache.org
List-Id: <user.geronimo.apache.org>
Delivered-To: mailing list user@geronimo.apache.org
Received: (qmail 1904 invoked by uid 99); 4 Dec 2008 15:11:26 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Dec 2008 07:11:26 -0800
X-ASF-Spam-Status: No, hits=2.2 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of ljubad@gmail.com designates
 209.85.198.236 as permitted sender)
Received: from [209.85.198.236] (HELO rv-out-0506.google.com) (209.85.198.236)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Dec 2008 15:09:57 +0000
Received: by rv-out-0506.google.com with SMTP id f6so4135475rvb.55
        for <user@geronimo.apache.org>; Thu, 04 Dec 2008 07:10:45 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:received:message-id:date:from:to
         :subject:in-reply-to:mime-version:content-type:references;
        bh=nLbu/depEYG1gLVShOdzz8QnupT7elstv2azS85o+/4=;
        b=lmqoqrkMzPyb3meDc6hUH/4Lq8xApDOZ71KsbsNPfPZMRwN8Oyp/JxnC0e+Y45dIGg
         uDbGgauqPySbVLeMvwsnrBfltDd5QpPHlyQVq4Tr3TbBkz5/fDl6YT+qMIufFoMSvrRo
         29rgKvKfJTb2iIoEE8YOHVjOY6c5I/H0XwXzw=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:references;
        b=A6Fp9Qsa6mQQ+6oPpevzTQuI2UDrOLA+yMVwV8nAW+PRkEy1CwXz9E+u9mnozfURz4
         AymmF5DvGgRxBGS1oi7pjvUB8spTlCbssd/4RWEwDXYoJm7NRDPHPHLvrXpBz2jYhJH2
         2pjxRic/h7NrJeh8rSJqPfyk2MQuucCHx0a3M=
Received: by 10.140.128.3 with SMTP id a3mr6967517rvd.232.1228403445279;
        Thu, 04 Dec 2008 07:10:45 -0800 (PST)
Received: by 10.141.179.20 with HTTP; Thu, 4 Dec 2008 07:10:45 -0800 (PST)
Message-ID: <b3c5665f0812040710q2d9e5005tdba289cc3441a9a3@mail.gmail.com>
Date: Thu, 4 Dec 2008 16:10:45 +0100
From: "David Ljuba" <ljubad@gmail.com>
To: user@geronimo.apache.org
Subject: Re: @GeneratedValue(strategy = GenerationType.TABLE... :
 org.apache.openjpa.persistence.PersistenceException: The Transaction
 Synchronization Registry can not suspend the current transaction
In-Reply-To: <b3c5665f0812040135n3688c6bfld1301e54913b7cb7@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_6548_22781970.1228403445263"
References: <b3c5665f0812030645v2940757bu6f6192e2b91a5e3b@mail.gmail.com>
	 <F6B13445-DB16-4248-A6FD-51BE706A4FAF@yahoo.com>
	 <b3c5665f0812040135n3688c6bfld1301e54913b7cb7@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_6548_22781970.1228403445263
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

It works now but there could be problem with transactions.

I made change in persistence.xml:
from
<jta-data-source>xxx</jta-data-source>
to
<non-jta-data-source>xxx</non-jta-data-source>


Could be this problem? After all there is transaction, but maybe there are
not distributed transactions needed for other services. Here is log

04 Dec 2008 15:18:09,296  INFO [pool-4-thread-6] (Transaction.java:70) - TX
Required: Started transaction
org.apache.geronimo.transaction.manager.TransactionImpl@11bddeb
04 Dec 2008 15:18:09,312 DEBUG [pool-4-thread-6]
(net.xxx.persistenceTest.probnaTabela.ProbnaTabela1Home.java:66) -
persisting ProbnaTabela1 instance
04 Dec 2008 15:18:09,406 DEBUG [pool-4-thread-6]
(net.xxx.persistenceTest.probnaTabela.ProbnaTabela1Home.java:66) - persist
successful
04 Dec 2008 15:18:09,406  INFO [pool-4-thread-6] (Transaction.java:70) - TX
Required: Committing transaction
org.apache.geronimo.transaction.manager.TransactionImpl@11bddeb
83531  xxx  TRACE  [pool-4-thread-6] openjpa.jdbc.SQL - <t 10235390, conn
18496393> executing prepstmnt 16150401
SELECT COUNTERVALUE
    FROM xxx.xxx.counters WITH (UPDLOCK)
    WHERE COUNTERNAME = ?
[params=(String) CUSTOMER_NO]
83531  xxx  TRACE  [pool-4-thread-6] openjpa.jdbc.SQL - <t 10235390, conn
18496393> [0 ms] spent
83531  xxx  TRACE  [pool-4-thread-6] openjpa.jdbc.SQL - <t 10235390, conn
18496393> executing prepstmnt 12455974
UPDATE xxx.xxx.counters
    SET COUNTERVALUE = ?
    WHERE COUNTERNAME = ? AND COUNTERVALUE = ?
[params=(long) 8673337, (String) CUSTOMER_NO, (long) 8673287]
83546  xxx  TRACE  [pool-4-thread-6] openjpa.jdbc.SQL - <t 10235390, conn
18496393> [15 ms] spent
83546  xxx  TRACE  [pool-4-thread-6] openjpa.jdbc.SQL - <t 10235390, conn
4865623> executing prepstmnt 26306486
INSERT INTO xxx.xxx.ProbnaTabela1 (id_1, ime)
    VALUES (?, ?)
[params=(int) 8673287, (String) D]
83546  xxx  TRACE  [pool-4-thread-6] openjpa.jdbc.SQL - <t 10235390, conn
4865623> [0 ms] spent

------=_Part_6548_22781970.1228403445263
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

It works now but there could be problem with transactions.<br><br>I made change in persistence.xml:<br>from<br>&lt;jta-data-source&gt;xxx&lt;/jta-data-source&gt;<br>to<br>&lt;non-jta-data-source&gt;xxx&lt;/non-jta-data-source&gt;<br>

<br><br>Could be this problem? After all there is transaction, but maybe there are not distributed transactions needed for other services. Here is log<br><br>04 Dec 2008 15:18:09,296&nbsp; INFO [pool-4-thread-6] (Transaction.java:70) - TX Required: Started transaction org.apache.geronimo.transaction.manager.TransactionImpl@11bddeb<br>

04 Dec 2008 15:18:09,312 DEBUG [pool-4-thread-6] (net.xxx.persistenceTest.probnaTabela.ProbnaTabela1Home.java:66) - persisting ProbnaTabela1 instance<br>04 Dec 2008 15:18:09,406 DEBUG [pool-4-thread-6] (net.xxx.persistenceTest.probnaTabela.ProbnaTabela1Home.java:66) - persist successful<br>

04 Dec 2008 15:18:09,406&nbsp; INFO [pool-4-thread-6] (Transaction.java:70) - TX Required: Committing transaction org.apache.geronimo.transaction.manager.TransactionImpl@11bddeb<br>83531&nbsp; xxx&nbsp; TRACE&nbsp; [pool-4-thread-6] openjpa.jdbc.SQL - &lt;t 10235390, conn 18496393&gt; executing prepstmnt 16150401<br>

SELECT COUNTERVALUE<br>&nbsp;&nbsp;&nbsp; FROM xxx.xxx.counters WITH (UPDLOCK)<br>&nbsp;&nbsp;&nbsp; WHERE COUNTERNAME = ?<br>[params=(String) CUSTOMER_NO]<br>83531&nbsp; xxx&nbsp; TRACE&nbsp; [pool-4-thread-6] openjpa.jdbc.SQL - &lt;t 10235390, conn 18496393&gt; [0 ms] spent<br>

83531&nbsp; xxx&nbsp; TRACE&nbsp; [pool-4-thread-6] openjpa.jdbc.SQL - &lt;t 10235390, conn 18496393&gt; executing prepstmnt 12455974<br>UPDATE xxx.xxx.counters<br>&nbsp;&nbsp;&nbsp; SET COUNTERVALUE = ?<br>&nbsp;&nbsp;&nbsp; WHERE COUNTERNAME = ? AND COUNTERVALUE = ?<br>

[params=(long) 8673337, (String) CUSTOMER_NO, (long) 8673287]<br>83546&nbsp; xxx&nbsp; TRACE&nbsp; [pool-4-thread-6] openjpa.jdbc.SQL - &lt;t 10235390, conn 18496393&gt; [15 ms] spent<br>83546&nbsp; xxx&nbsp; TRACE&nbsp; [pool-4-thread-6] openjpa.jdbc.SQL - &lt;t 10235390, conn 4865623&gt; executing prepstmnt 26306486<br>

INSERT INTO xxx.xxx.ProbnaTabela1 (id_1, ime)<br>&nbsp;&nbsp;&nbsp; VALUES (?, ?)<br>[params=(int) 8673287, (String) D]<br>83546&nbsp; xxx&nbsp; TRACE&nbsp; [pool-4-thread-6] openjpa.jdbc.SQL - &lt;t 10235390, conn 4865623&gt; [0 ms] spent<br><br>

------=_Part_6548_22781970.1228403445263--