[
https://issues.apache.org/jira/browse/OPENJPA-2525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14145198#comment-14145198
]
ASF subversion and git services commented on OPENJPA-2525:
----------------------------------------------------------
Commit 1627112 from [~fyrewyld] in branch 'openjpa/branches/2.3.x'
[ https://svn.apache.org/r1627112 ]
OPENJPA-2525: Use of JoinColumn targets to another joinColumn key exposed as an
attribute will cause a ConstrainViolation exception on persist
> Use of JoinColumn(.. referencedColumnName= ..) targets to another joinColumn
> key exposed as an attribute will cause a ConstrainViolation exception on
> persist
> -------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: OPENJPA-2525
> URL: https://issues.apache.org/jira/browse/OPENJPA-2525
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.2.2
> Reporter: Albert Lee
> Assignee: Albert Lee
> Fix For: 2.2.3
>
> Attachments: OPENJPA-2525.patch
>
>
> Using the following entities, when a simple single entry aCase -> aText ->
> aEvident instances are created, a ConstraintViolationException will be
> observed when this object tree is persisted
> @Entity
> public class ACase {
> @Id
> @GeneratedValue(strategy=GenerationType.IDENTITY)
> private int id;
> @OneToOne(fetch=FetchType.LAZY, mappedBy="aCase",
> cascade=CascadeType.MERGE)
> private AText aText;
> }
> @Entity
> public class AText {
> @Id
> @GeneratedValue(strategy=GenerationType.IDENTITY)
> private int id;
> @OneToOne(fetch=FetchType.LAZY, cascade=CascadeType.MERGE)
> @JoinColumn(name="ACASE_ID", nullable=false)
> private ACase aCase;
> @OneToMany(targetEntity=AEvident.class, mappedBy="aText",
> cascade=CascadeType.MERGE)
> private Set<AEvident> aEvidents = new HashSet<AEvident>();
> @Column(name="ACASE_ID", insertable=false, updatable=false, unique=true)
> private int aCaseId; // <<< this field is not updated to the
> associated aCase.id value after aText instance is persisted/merged.
> }
> @Entity
> public class AEvident {
> @Id
> @GeneratedValue(strategy=GenerationType.IDENTITY)
> private int id;
> @ManyToOne(fetch=FetchType.LAZY, cascade=CascadeType.MERGE)
> @JoinColumn(name="ACASE_ID", referencedColumnName="ACASE_ID") // <<<
> when aEvident instance is persisted in the same transaction, the INSERT used
> the default value (0) in aText.aCaseId, which does not exist, hence the
> ConstraintViolationException is thrown.
> public AText getAText() {
> }
> INSERT INTO ACase (name) VALUES (?) [params=(String) Case_A]
> VALUES(IDENTITY_VAL_LOCAL())
> INSERT INTO AText (ACASE_ID, name) VALUES (?, ?) [params=(int) 15, (String)
> Text_A]
> VALUES(IDENTITY_VAL_LOCAL())
> INSERT INTO AEvident (name, ACASE_ID) VALUES (?, ?) [params=(String)
> Evident_A, (int) 0]
> Caused by: <openjpa-2.2.3-SNAPSHOT-rsvn: E155036: The working copy at
> '/cygdrive/c/Watson/oea/workspace/openjpa.22x' fatal general error>
> org.apache.openjpa.persistence.PersistenceException: The transaction has been
> rolled back. See the nested exceptions for details on the errors that
> occurred.
> FailedObject: org.apache.openjpa.persistence.relations.AEvident@a33283dc
> at
> org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2352)
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2190)
> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2087)
> at
> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2005)
> at
> org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
> at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1529)
> at
> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:933)
> at
> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:570)
> ... 23 more
> Caused by: <openjpa-2.2.3-SNAPSHOT-rsvn: E155036: The working copy at
> '/cygdrive/c/Watson/oea/workspace/openjpa.22x' fatal general error>
> org.apache.openjpa.persistence.PersistenceException: INSERT on table
> 'AEVIDENT' caused a violation of foreign key constraint 'SQL140820224303470'
> for key (0). The statement has been rolled back. {prepstmnt -198000009
> INSERT INTO AEvident (name, ACASE_ID) VALUES (?, ?) [params=(String)
> Evident_A, (int) 0]} [code=20000, state=23503]
> FailedObject: org.apache.openjpa.persistence.relations.AEvident@a33283dc
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4985)
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4951)
> 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
> 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:357)
> at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flushGraph(ConstraintUpdateManager.java:349)
> at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:97)
> 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:732)
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
> ... 30 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: INSERT on table
> 'AEVIDENT' caused a violation of foreign key constraint 'SQL140820224303470'
> for key (0). The statement has been rolled back. {prepstmnt -198000009
> INSERT INTO AEvident (name, ACASE_ID) VALUES (?, ?) [params=(String)
> Evident_A, (int) 0]} [code=20000, state=23503]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$4(LoggingConnectionDecorator.java:194)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1134)
> at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:275)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1792)
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:268)
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:119)
> ... 41 more
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
