Return-Path: 
 <dev-return-21414-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org>
X-Original-To: apmail-openjpa-dev-archive@www.apache.org
Delivered-To: apmail-openjpa-dev-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 5A123EAC5
	for <apmail-openjpa-dev-archive@www.apache.org>;
 Thu, 27 Dec 2012 19:42:51 +0000 (UTC)
Received: (qmail 32064 invoked by uid 500); 27 Dec 2012 19:42:51 -0000
Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org
Received: (qmail 32031 invoked by uid 500); 27 Dec 2012 19:42:51 -0000
Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@openjpa.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@openjpa.apache.org>
List-Post: <mailto:dev@openjpa.apache.org>
List-Id: <dev.openjpa.apache.org>
Reply-To: dev@openjpa.apache.org
Delivered-To: mailing list dev@openjpa.apache.org
Received: (qmail 32022 invoked by uid 99); 27 Dec 2012 19:42:51 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Dec 2012 19:42:51 +0000
X-ASF-Spam-Status: No, hits=2.0 required=5.0
	tests=SPF_NEUTRAL,URI_HEX
X-Spam-Check-By: apache.org
Received-SPF: neutral (nike.apache.org: 216.139.250.139 is neither permitted
 nor denied by domain of pankydudein@gmail.com)
Received: from [216.139.250.139] (HELO joe.nabble.com) (216.139.250.139)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Dec 2012 19:42:44 +0000
Received: from jim.nabble.com ([192.168.236.80])
	by joe.nabble.com with esmtp (Exim 4.72)
	(envelope-from <pankydudein@gmail.com>)
	id 1ToJGJ-0005S7-A9
	for dev@openjpa.apache.org; Thu, 27 Dec 2012 11:37:03 -0800
Date: Thu, 27 Dec 2012 11:37:03 -0800 (PST)
From: pankajpriyadarshi <pankydudein@gmail.com>
To: dev@openjpa.apache.org
Message-ID: <1356637023301-7582368.post@n2.nabble.com>
In-Reply-To: <1356144647448-7582359.post@n2.nabble.com>
References: <1351961775831-7581600.post@n2.nabble.com>
 <1356107748401-7582345.post@n2.nabble.com>
 <1356109449385-7582346.post@n2.nabble.com>
 <1356110867991-7582347.post@n2.nabble.com>
 <1356120314337-7582352.post@n2.nabble.com>
 <1356125712874-7582355.post@n2.nabble.com>
 <1356133769440-7582356.post@n2.nabble.com>
 <1356137160278-7582357.post@n2.nabble.com>
 <1356139519464-7582358.post@n2.nabble.com>
 <1356144647448-7582359.post@n2.nabble.com>
Subject: Re: Savepoint issue with OpenJPA
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

Hello Pinaki,
           I have 2 new files to the JIRA issue: a) the latest jar file
along with b) a small SQL script to be run on
openjpa-persistence-jdbc\target\database\openjpa-derby-database Derby
database. This script will add foreign constraints to the tables.

With this latest jar you can see the testInsertWithoutSavepoint passing but
testInsertWithSavepoint failing when doing a commit. I also tried the
<property name="openjpa.jdbc.SynchronizeMappings"
value="buildSchema(ForeignKeys=true)"/> but it makes no difference to this
issue.

Please let me know if you need anything else from me. This is the URL to the
JIRA issue where I have added the 2 new files:

https://issues.apache.org/jira/browse/OPENJPA-2291?page=com.atlassian.jirafisheyeplugin:fisheye-issuepanel#comment-13538436.

The exception that I got was:

Caused by: <openjpa-2.3.0-SNAPSHOT-runknown fatal general error>
org.apache.openjpa.persistence.PersistenceException: INSERT on table
'PER_JDBC_KERN_STORY' caused a violation of foreign key constraint
'SQL121227131511400' for key (25).  The statement has been rolled back.
{prepstmnt 1898869038 INSERT INTO PER_JDBC_KERN_STORY (ID, TASK_ID, VERSION)
VALUES (?, ?, ?) [params=?, ?, ?]} [code=20000, state=23503]
FailedObject: org.apache.openjpa.jdbc.kernel.Story1@73607360
	at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4940)
	at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4906)
	at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:137)
	at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78)
	at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:144)
	at
org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
	at
com.ibm.ws.persistence.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:63)
	at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100)
	at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
	at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
	at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
	at
org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
	at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:105)
	at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:78)
	at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:735)
	at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)

Thank You,
Pankaj Priyadarshi



--
View this message in context: http://openjpa.208410.n2.nabble.com/Savepoint-issue-with-OpenJPA-tp7581548p7582368.html
Sent from the OpenJPA Developers mailing list archive at Nabble.com.