You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Megan (JIRA)" <ji...@apache.org> on 2006/09/01 21:30:22 UTC
[jira] Created: (OPENJPA-39) Cascade delete does not work with
foreign key constraints
Cascade delete does not work with foreign key constraints
---------------------------------------------------------
Key: OPENJPA-39
URL: http://issues.apache.org/jira/browse/OPENJPA-39
Project: OpenJPA
Issue Type: Bug
Components: jpa
Environment: Microsoft SQL Server 2000
Windows XP
Java SE 1.5
OpenJPA - source downloaded Aug 28, 2006)
Show »
Microsoft SQL Server 2000 Windows XP Java SE 1.5 OpenJPA - source downloaded today (Aug 14, 2006)
Reporter: Megan
Priority: Minor
Attachments: testcase.zip
Removing a parent object in OneToMany with cascade=CascadeType.ALL raises foreign key constraints exception
JpaParent.java
@OneToMany(mappedBy="parent", cascade=CascadeType.ALL)
private Set<JpaChild> children = new HashSet<JpaChild>();
JpaChild.java
@ManyToOne(optional=false)
@JoinColumn(name="ParentId", nullable=false)
private JpaParent parent = null;
// This raises the following exception. If foreign key is removed, it works OK (Maybe I have to let OpenJPA know about foreign key constraints)
JpaParent parent = em.find(JpaParent.class, 1);
em.remove(parent);
<2|true|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:371)
at openjpa.test.BaseTestCase.destroyTestCase(BaseTestCase.java:82)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.junit.internal.runners.BeforeAndAfterRunner.invokeMethod(BeforeAndAfterRunner.java:74)
at org.junit.internal.runners.BeforeAndAfterRunner.runAfters(BeforeAndAfterRunner.java:65)
at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:37)
at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:71)
at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: <0|true|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2028)
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1876)
at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1772)
at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1706)
at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:76)
at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1271)
at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:831)
at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:360)
... 21 more
Caused by: <0|false|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.PersistenceException: [BEA][SQLServer JDBC Driver][SQLServer]DELETE statement conflicted with COLUMN REFERENCE constraint 'JpaChild_Parent_FK'. The conflict occurred in database 'pocdb', table 'JpaChild', column 'ParentId'. {prepstmnt 32048085 DELETE FROM JpaParent WHERE Id = ? AND OptLock = ? [params=(int) 1, (int) 1]} [code=547, state=23000]
FailedObject: openjpa.model.JpaParent-1
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3701)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:94)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:103)
at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:68)
at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrimaryRow(OperationOrderUpdateManager.java:158)
at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(OperationOrderUpdateManager.java:86)
at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:88)
at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:68)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:512)
at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:127)
... 28 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: [BEA][SQLServer JDBC Driver][SQLServer]DELETE statement conflicted with COLUMN REFERENCE constraint 'JpaChild_Parent_FK'. The conflict occurred in database 'pocdb', table 'JpaChild', column 'ParentId'. {prepstmnt 32048085 DELETE FROM JpaParent WHERE Id = ? AND OptLock = ? [params=(int) 1, (int) 1]} [code=547, state=23000]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:186)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:53)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:839)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:266)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1359)
at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:92)
... 35 more
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Re: [jira] Commented: (OPENJPA-39) Cascade delete does not work with foreign key constraints
Posted by Megan Kim <me...@gmail.com>.
This works great. Thank you.
On 9/12/06, Abe White (JIRA) <ji...@apache.org> wrote:
>
> [
> http://issues.apache.org/jira/browse/OPENJPA-39?page=comments#action_12434283]
>
> Abe White commented on OPENJPA-39:
> ----------------------------------
>
> I implemented Craig's suggestion of always considering the child object as
> deleted first when cascading a delete from parent to child. So this test
> case will now work even with non-nullable foreign key columns.
>
> > Cascade delete does not work with foreign key constraints
> > ---------------------------------------------------------
> >
> > Key: OPENJPA-39
> > URL: http://issues.apache.org/jira/browse/OPENJPA-39
> > Project: OpenJPA
> > Issue Type: Bug
> > Components: jpa
> > Environment: Microsoft SQL Server 2000
> > Windows XP
> > Java SE 1.5
> > OpenJPA - source downloaded Aug 28, 2006)
> > Show »
> > Microsoft SQL Server 2000 Windows XP Java SE 1.5 OpenJPA - source
> downloaded today (Aug 14, 2006)
> > Reporter: Megan
> > Priority: Minor
> > Attachments: testcase.zip
> >
> >
> > Removing a parent object in OneToMany with cascade=CascadeType.ALLraises foreign key constraints exception
> > JpaParent.java
> > @OneToMany(mappedBy="parent", cascade=CascadeType.ALL)
> > private Set<JpaChild> children = new HashSet<JpaChild>();
> > JpaChild.java
> > @ManyToOne(optional=false)
> > @JoinColumn(name="ParentId", nullable=false)
> > private JpaParent parent = null;
> > // This raises the following exception. If foreign key is removed, it
> works OK (Maybe I have to let OpenJPA know about foreign key constraints)
> > JpaParent parent = em.find(JpaParent.class, 1);
> > em.remove(parent);
> > <2|true|0.9.0-incubating-SNAPSHOT>
> org.apache.openjpa.persistence.RollbackException: The transaction has been
> rolled back. See the nested exceptions for details on the errors that
> occurred.
> > at org.apache.openjpa.persistence.EntityManagerImpl.commit(
> EntityManagerImpl.java:371)
> > at openjpa.test.BaseTestCase.destroyTestCase(BaseTestCase.java:82)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:39)
> > at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:25)
> > at java.lang.reflect.Method.invoke(Method.java:585)
> > at org.junit.internal.runners.BeforeAndAfterRunner.invokeMethod(
> BeforeAndAfterRunner.java:74)
> > at org.junit.internal.runners.BeforeAndAfterRunner.runAfters(
> BeforeAndAfterRunner.java:65)
> > at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(
> BeforeAndAfterRunner.java:37)
> > at org.junit.internal.runners.TestMethodRunner.runMethod(
> TestMethodRunner.java:75)
> > at org.junit.internal.runners.TestMethodRunner.run(
> TestMethodRunner.java:45)
> > at
> org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(
> TestClassMethodsRunner.java:71)
> > at org.junit.internal.runners.TestClassMethodsRunner.run(
> TestClassMethodsRunner.java:35)
> > at org.junit.internal.runners.TestClassRunner$1.runUnprotected(
> TestClassRunner.java:42)
> > at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(
> BeforeAndAfterRunner.java:34)
> > at org.junit.internal.runners.TestClassRunner.run(
> TestClassRunner.java:52)
> > at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(
> JUnit4TestReference.java:38)
> > at org.eclipse.jdt.internal.junit.runner.TestExecution.run(
> TestExecution.java:38)
> > at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests
> (RemoteTestRunner.java:460)
> > at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests
> (RemoteTestRunner.java:673)
> > at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(
> RemoteTestRunner.java:386)
> > at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(
> RemoteTestRunner.java:196)
> > Caused by: <0|true|0.9.0-incubating-SNAPSHOT>
> org.apache.openjpa.persistence.PersistenceException: The transaction has
> been rolled back. See the nested exceptions for details on the errors that
> occurred.
> > at org.apache.openjpa.kernel.BrokerImpl.newFlushException(
> BrokerImpl.java:2028)
> > at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java
> :1876)
> > at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java
> :1772)
> > at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(
> BrokerImpl.java:1706)
> > at org.apache.openjpa.kernel.LocalManagedRuntime.commit(
> LocalManagedRuntime.java:76)
> > at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java
> :1271)
> > at org.apache.openjpa.kernel.DelegatingBroker.commit(
> DelegatingBroker.java:831)
> > at org.apache.openjpa.persistence.EntityManagerImpl.commit(
> EntityManagerImpl.java:360)
> > ... 21 more
> > Caused by: <0|false|0.9.0-incubating-SNAPSHOT>
> org.apache.openjpa.persistence.PersistenceException: [BEA][SQLServer JDBC
> Driver][SQLServer]DELETE statement conflicted with COLUMN REFERENCE
> constraint 'JpaChild_Parent_FK'. The conflict occurred in database 'pocdb',
> table 'JpaChild', column 'ParentId'. {prepstmnt 32048085 DELETE FROM
> JpaParent WHERE Id = ? AND OptLock = ? [params=(int) 1, (int) 1]} [code=547,
> state=23000]
> > FailedObject: openjpa.model.JpaParent-1
> > at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(
> DBDictionary.java:3701)
> > at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(
> SQLExceptions.java:94)
> > at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(
> SQLExceptions.java:64)
> > at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(
> PreparedStatementManagerImpl.java:103)
> > at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(
> PreparedStatementManagerImpl.java:68)
> > at
> org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrimaryRow
> (OperationOrderUpdateManager.java:158)
> > at
> org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(
> OperationOrderUpdateManager.java:86)
> > at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(
> AbstractUpdateManager.java:88)
> > at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(
> AbstractUpdateManager.java:68)
> > at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(
> JDBCStoreManager.java:512)
> > at org.apache.openjpa.kernel.DelegatingStoreManager.flush(
> DelegatingStoreManager.java:127)
> > ... 28 more
> > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException:
> [BEA][SQLServer JDBC Driver][SQLServer]DELETE statement conflicted with
> COLUMN REFERENCE constraint 'JpaChild_Parent_FK'. The conflict occurred in
> database 'pocdb', table 'JpaChild', column 'ParentId'. {prepstmnt 32048085
> DELETE FROM JpaParent WHERE Id = ? AND OptLock = ? [params=(int) 1, (int)
> 1]} [code=547, state=23000]
> > at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(
> LoggingConnectionDecorator.java:186)
> > at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(
> LoggingConnectionDecorator.java:53)
> > at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate
> (LoggingConnectionDecorator.java:839)
> > at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(
> DelegatingPreparedStatement.java:266)
> > at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate
> (JDBCStoreManager.java:1359)
> > at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(
> PreparedStatementManagerImpl.java:92)
> > ... 35 more
>
> --
> This message is automatically generated by JIRA.
> -
> If you think it was sent incorrectly contact one of the administrators:
> http://issues.apache.org/jira/secure/Administrators.jspa
> -
> For more information on JIRA, see: http://www.atlassian.com/software/jira
>
>
>
[jira] Commented: (OPENJPA-39) Cascade delete does not work with
foreign key constraints
Posted by "Abe White (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OPENJPA-39?page=comments#action_12432220 ]
Abe White commented on OPENJPA-39:
----------------------------------
OpenJPA has to know where the DB foreign keys are. You have a few options:
- Using the org.apache.openjpa.persistence.ForeignKey annotation, and related annnotations (ElementForeignKey, etc) to tell OpenJPA exactly which relations and joins have foreign keys on them.
- Setting the "openjpa.jdbc.SchemaFactory" property to "native(ForeignKeys=true)" will tell OpenJPA to read the existing schema from the DB, including foreign key locations, using JDBC schema reflection. Under this setting OpenJPA will also validate that the schema and mappings match.
- Setting the "openjpa.jdbc.MappingDefaults" property to "jpa(ForeignKeyDeleteAction=restrict, JoinForeignKeyDeleteAction=restrict)" will tell OpenJPA to just assume that all relations and joins are backed by database foreign keys.
The first and third options also affect schema creation, in that OpenJPA's schema creation tools will add foreign keys to to the annotated relations and joins / to all relations and joins under those settings.
I'll leave this JIRA open for now in case anyone would like to comment on whether we should change the defaults. Right now the defaults are to never assume any relation or join is backed by a database foreign key, and to never create database foreign keys during schema creation.
> Cascade delete does not work with foreign key constraints
> ---------------------------------------------------------
>
> Key: OPENJPA-39
> URL: http://issues.apache.org/jira/browse/OPENJPA-39
> Project: OpenJPA
> Issue Type: Bug
> Components: jpa
> Environment: Microsoft SQL Server 2000
> Windows XP
> Java SE 1.5
> OpenJPA - source downloaded Aug 28, 2006)
> Show »
> Microsoft SQL Server 2000 Windows XP Java SE 1.5 OpenJPA - source downloaded today (Aug 14, 2006)
> Reporter: Megan
> Priority: Minor
> Attachments: testcase.zip
>
>
> Removing a parent object in OneToMany with cascade=CascadeType.ALL raises foreign key constraints exception
> JpaParent.java
> @OneToMany(mappedBy="parent", cascade=CascadeType.ALL)
> private Set<JpaChild> children = new HashSet<JpaChild>();
> JpaChild.java
> @ManyToOne(optional=false)
> @JoinColumn(name="ParentId", nullable=false)
> private JpaParent parent = null;
> // This raises the following exception. If foreign key is removed, it works OK (Maybe I have to let OpenJPA know about foreign key constraints)
> JpaParent parent = em.find(JpaParent.class, 1);
> em.remove(parent);
> <2|true|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
> at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:371)
> at openjpa.test.BaseTestCase.destroyTestCase(BaseTestCase.java:82)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at org.junit.internal.runners.BeforeAndAfterRunner.invokeMethod(BeforeAndAfterRunner.java:74)
> at org.junit.internal.runners.BeforeAndAfterRunner.runAfters(BeforeAndAfterRunner.java:65)
> at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:37)
> at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
> at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
> at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:71)
> at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
> at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
> at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
> at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
> Caused by: <0|true|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
> at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2028)
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1876)
> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1772)
> at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1706)
> at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:76)
> at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1271)
> at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:831)
> at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:360)
> ... 21 more
> Caused by: <0|false|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.PersistenceException: [BEA][SQLServer JDBC Driver][SQLServer]DELETE statement conflicted with COLUMN REFERENCE constraint 'JpaChild_Parent_FK'. The conflict occurred in database 'pocdb', table 'JpaChild', column 'ParentId'. {prepstmnt 32048085 DELETE FROM JpaParent WHERE Id = ? AND OptLock = ? [params=(int) 1, (int) 1]} [code=547, state=23000]
> FailedObject: openjpa.model.JpaParent-1
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3701)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:94)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:103)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:68)
> at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrimaryRow(OperationOrderUpdateManager.java:158)
> at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(OperationOrderUpdateManager.java:86)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:88)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:68)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:512)
> at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:127)
> ... 28 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: [BEA][SQLServer JDBC Driver][SQLServer]DELETE statement conflicted with COLUMN REFERENCE constraint 'JpaChild_Parent_FK'. The conflict occurred in database 'pocdb', table 'JpaChild', column 'ParentId'. {prepstmnt 32048085 DELETE FROM JpaParent WHERE Id = ? AND OptLock = ? [params=(int) 1, (int) 1]} [code=547, state=23000]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:186)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:53)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:839)
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:266)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1359)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:92)
> ... 35 more
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (OPENJPA-39) Cascade delete does not work with
foreign key constraints
Posted by "Abe White (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OPENJPA-39?page=comments#action_12432221 ]
Abe White commented on OPENJPA-39:
----------------------------------
In the above comment, the correct annotation is org.apache.openjpa.persistence.jdbc.ForeignKey.
> Cascade delete does not work with foreign key constraints
> ---------------------------------------------------------
>
> Key: OPENJPA-39
> URL: http://issues.apache.org/jira/browse/OPENJPA-39
> Project: OpenJPA
> Issue Type: Bug
> Components: jpa
> Environment: Microsoft SQL Server 2000
> Windows XP
> Java SE 1.5
> OpenJPA - source downloaded Aug 28, 2006)
> Show »
> Microsoft SQL Server 2000 Windows XP Java SE 1.5 OpenJPA - source downloaded today (Aug 14, 2006)
> Reporter: Megan
> Priority: Minor
> Attachments: testcase.zip
>
>
> Removing a parent object in OneToMany with cascade=CascadeType.ALL raises foreign key constraints exception
> JpaParent.java
> @OneToMany(mappedBy="parent", cascade=CascadeType.ALL)
> private Set<JpaChild> children = new HashSet<JpaChild>();
> JpaChild.java
> @ManyToOne(optional=false)
> @JoinColumn(name="ParentId", nullable=false)
> private JpaParent parent = null;
> // This raises the following exception. If foreign key is removed, it works OK (Maybe I have to let OpenJPA know about foreign key constraints)
> JpaParent parent = em.find(JpaParent.class, 1);
> em.remove(parent);
> <2|true|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
> at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:371)
> at openjpa.test.BaseTestCase.destroyTestCase(BaseTestCase.java:82)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at org.junit.internal.runners.BeforeAndAfterRunner.invokeMethod(BeforeAndAfterRunner.java:74)
> at org.junit.internal.runners.BeforeAndAfterRunner.runAfters(BeforeAndAfterRunner.java:65)
> at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:37)
> at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
> at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
> at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:71)
> at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
> at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
> at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
> at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
> Caused by: <0|true|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
> at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2028)
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1876)
> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1772)
> at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1706)
> at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:76)
> at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1271)
> at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:831)
> at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:360)
> ... 21 more
> Caused by: <0|false|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.PersistenceException: [BEA][SQLServer JDBC Driver][SQLServer]DELETE statement conflicted with COLUMN REFERENCE constraint 'JpaChild_Parent_FK'. The conflict occurred in database 'pocdb', table 'JpaChild', column 'ParentId'. {prepstmnt 32048085 DELETE FROM JpaParent WHERE Id = ? AND OptLock = ? [params=(int) 1, (int) 1]} [code=547, state=23000]
> FailedObject: openjpa.model.JpaParent-1
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3701)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:94)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:103)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:68)
> at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrimaryRow(OperationOrderUpdateManager.java:158)
> at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(OperationOrderUpdateManager.java:86)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:88)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:68)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:512)
> at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:127)
> ... 28 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: [BEA][SQLServer JDBC Driver][SQLServer]DELETE statement conflicted with COLUMN REFERENCE constraint 'JpaChild_Parent_FK'. The conflict occurred in database 'pocdb', table 'JpaChild', column 'ParentId'. {prepstmnt 32048085 DELETE FROM JpaParent WHERE Id = ? AND OptLock = ? [params=(int) 1, (int) 1]} [code=547, state=23000]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:186)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:53)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:839)
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:266)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1359)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:92)
> ... 35 more
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Re: [jira] Resolved: (OPENJPA-39) Cascade delete does not work with foreign key constraints
Posted by Abe White <aw...@bea.com>.
> I think that cascade delete is most commonly used where there is a
> one-to-possibly-zero relationship (with a [zero or one or many]-to-
> one on the other side). Thus, the other side has the foreign key,
> and the side with the cascade delete definition is the side with
> the existence that doesn't depend on the other side. So deleting
> the other side first usually solves the timing issues.
Does anyone else have an opinion on this? Should we consider the
children to be deleted before parent when cascading a delete? I have
no problem with that strategy.
>
>>>> Register now for BEA World 2006 --- See http://www.bea.com/
>>>> beaworld<<
>
> Thanks for the personal invitation.
Yeah, I just noticed that they've added that to the outgoing
signature. How obnoxious. Supposedly they're working on removing
the signature for us.
>>Register now for BEA World 2006 --- See http://www.bea.com/beaworld<<
_______________________________________________________________________
Notice: This email message, together with any attachments, may contain
information of BEA Systems, Inc., its subsidiaries and affiliated
entities, that may be confidential, proprietary, copyrighted and/or
legally privileged, and is intended solely for the use of the individual
or entity named in this message. If you are not the intended recipient,
and have received this message in error, please immediately return this
by email and then delete it.
Re: [jira] Resolved: (OPENJPA-39) Cascade delete does not work with
foreign key constraints
Posted by Craig L Russell <Cr...@Sun.COM>.
Hi Abe,
On Sep 12, 2006, at 9:21 AM, Abe White wrote:
>>
>>> - When you delete a parent object and the operation cascades to
>>> children, the object-level operation order is delete parent, then
>>> delete children.
>>
>> In my experience, the cascade should delete the children first.
>> This solves 99% of the cascade delete issues.
>
> It seems to me you'd just have the exact same problem when forward
> foreign keys (rather than inverse ones as in a one-many) are used.
I think that cascade delete is most commonly used where there is a
one-to-possibly-zero relationship (with a [zero or one or many]-to-
one on the other side). Thus, the other side has the foreign key, and
the side with the cascade delete definition is the side with the
existence that doesn't depend on the other side. So deleting the
other side first usually solves the timing issues.
> Or do you mean that cascading to a collection should delete the
> children first, but cascading through a to-one should not?
The side with the cascade delete is not the side with the foreign key
that might be violated. So deleting the other side first should
always work.
>>> Register now for BEA World 2006 --- See http://www.bea.com/
>>> beaworld<<
Thanks for the personal invitation.
Craig
> ______________________________________________________________________
> _
> Notice: This email message, together with any attachments, may
> contain
> information of BEA Systems, Inc., its subsidiaries and
> affiliated
> entities, that may be confidential, proprietary, copyrighted
> and/or
> legally privileged, and is intended solely for the use of the
> individual
> or entity named in this message. If you are not the intended
> recipient,
> and have received this message in error, please immediately return
> this
> by email and then delete it.
Craig Russell
clr@apache.org http://db.apache.org/jdo
Re: [jira] Resolved: (OPENJPA-39) Cascade delete does not work with foreign key constraints
Posted by Abe White <aw...@bea.com>.
>
>> - When you delete a parent object and the operation cascades to
>> children, the object-level operation order is delete parent, then
>> delete children.
>
> In my experience, the cascade should delete the children first.
> This solves 99% of the cascade delete issues.
It seems to me you'd just have the exact same problem when forward
foreign keys (rather than inverse ones as in a one-many) are used.
Or do you mean that cascading to a collection should delete the
children first, but cascading through a to-one should not?
>>Register now for BEA World 2006 --- See http://www.bea.com/beaworld<<
_______________________________________________________________________
Notice: This email message, together with any attachments, may contain
information of BEA Systems, Inc., its subsidiaries and affiliated
entities, that may be confidential, proprietary, copyrighted and/or
legally privileged, and is intended solely for the use of the individual
or entity named in this message. If you are not the intended recipient,
and have received this message in error, please immediately return this
by email and then delete it.
Re: [jira] Resolved: (OPENJPA-39) Cascade delete does not work with
foreign key constraints
Posted by Craig L Russell <Cr...@Sun.COM>.
Hi Abe,
> - When you delete a parent object and the operation cascades to
> children, the object-level operation order is delete parent, then
> delete children.
In my experience, the cascade should delete the children first. This
solves 99% of the cascade delete issues.
Craig
On Sep 11, 2006, at 4:57 PM, Abe White (JIRA) wrote:
> [ http://issues.apache.org/jira/browse/OPENJPA-39?page=all ]
>
> Abe White resolved OPENJPA-39.
> ------------------------------
>
> Resolution: Won't Fix
>
> Turns out the problem is more complicated than just having a
> foreign key. The issue is:
> - OpenJPA's UpdateManager plugin does not reorder SQL. It issues
> SQL in the same order as the corresponding object-level
> operations. The SQL-reordering UpdateManager is unique to Kodo.
> - When you delete a parent object and the operation cascades to
> children, the object-level operation order is delete parent, then
> delete children.
> - Issuing the SQL in that order will violate the FK constraint.
> OpenJPA is smart enough to detect this and null the children
> record's FK columns before deleting the parent.
> - However, the columns in this case are non-nullable, so this
> strategy doesn't work.
>
> So, given that there are no plans to donate Kodo's SQL-reordering
> UpdateManager, the options are:
> 1. Use nullable foreign key columns, or
> 2. Delete the child objects before the parent at the object level.
>
> Also if you choose option #1, make sure to get the latest OpenJPA
> from SVN, as there was a critical problem with nulling the FK
> columns correctly that is now fixed (9/11/2006).
>
>> Cascade delete does not work with foreign key constraints
>> ---------------------------------------------------------
>>
>> Key: OPENJPA-39
>> URL: http://issues.apache.org/jira/browse/OPENJPA-39
>> Project: OpenJPA
>> Issue Type: Bug
>> Components: jpa
>> Environment: Microsoft SQL Server 2000
>> Windows XP
>> Java SE 1.5
>> OpenJPA - source downloaded Aug 28, 2006)
>> Show »
>> Microsoft SQL Server 2000 Windows XP Java SE 1.5 OpenJPA - source
>> downloaded today (Aug 14, 2006)
>> Reporter: Megan
>> Priority: Minor
>> Attachments: testcase.zip
>>
>>
>> Removing a parent object in OneToMany with cascade=CascadeType.ALL
>> raises foreign key constraints exception
>> JpaParent.java
>> @OneToMany(mappedBy="parent", cascade=CascadeType.ALL)
>> private Set<JpaChild> children = new HashSet<JpaChild>();
>> JpaChild.java
>> @ManyToOne(optional=false)
>> @JoinColumn(name="ParentId", nullable=false)
>> private JpaParent parent = null;
>> // This raises the following exception. If foreign key is
>> removed, it works OK (Maybe I have to let OpenJPA know about
>> foreign key constraints)
>> JpaParent parent = em.find(JpaParent.class, 1);
>> em.remove(parent);
>> <2|true|0.9.0-incubating-SNAPSHOT>
>> org.apache.openjpa.persistence.RollbackException: The transaction
>> has been rolled back. See the nested exceptions for details on
>> the errors that occurred.
>> at org.apache.openjpa.persistence.EntityManagerImpl.commit
>> (EntityManagerImpl.java:371)
>> at openjpa.test.BaseTestCase.destroyTestCase(BaseTestCase.java:82)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at sun.reflect.NativeMethodAccessorImpl.invoke
>> (NativeMethodAccessorImpl.java:39)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke
>> (DelegatingMethodAccessorImpl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:585)
>> at org.junit.internal.runners.BeforeAndAfterRunner.invokeMethod
>> (BeforeAndAfterRunner.java:74)
>> at org.junit.internal.runners.BeforeAndAfterRunner.runAfters
>> (BeforeAndAfterRunner.java:65)
>> at org.junit.internal.runners.BeforeAndAfterRunner.runProtected
>> (BeforeAndAfterRunner.java:37)
>> at org.junit.internal.runners.TestMethodRunner.runMethod
>> (TestMethodRunner.java:75)
>> at org.junit.internal.runners.TestMethodRunner.run
>> (TestMethodRunner.java:45)
>> at
>> org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod
>> (TestClassMethodsRunner.java:71)
>> at org.junit.internal.runners.TestClassMethodsRunner.run
>> (TestClassMethodsRunner.java:35)
>> at org.junit.internal.runners.TestClassRunner$1.runUnprotected
>> (TestClassRunner.java:42)
>> at org.junit.internal.runners.BeforeAndAfterRunner.runProtected
>> (BeforeAndAfterRunner.java:34)
>> at org.junit.internal.runners.TestClassRunner.run
>> (TestClassRunner.java:52)
>> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run
>> (JUnit4TestReference.java:38)
>> at org.eclipse.jdt.internal.junit.runner.TestExecution.run
>> (TestExecution.java:38)
>> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests
>> (RemoteTestRunner.java:460)
>> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests
>> (RemoteTestRunner.java:673)
>> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run
>> (RemoteTestRunner.java:386)
>> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main
>> (RemoteTestRunner.java:196)
>> Caused by: <0|true|0.9.0-incubating-SNAPSHOT>
>> org.apache.openjpa.persistence.PersistenceException: The
>> transaction has been rolled back. See the nested exceptions for
>> details on the errors that occurred.
>> at org.apache.openjpa.kernel.BrokerImpl.newFlushException
>> (BrokerImpl.java:2028)
>> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1876)
>> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:
>> 1772)
>> at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion
>> (BrokerImpl.java:1706)
>> at org.apache.openjpa.kernel.LocalManagedRuntime.commit
>> (LocalManagedRuntime.java:76)
>> at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1271)
>> at org.apache.openjpa.kernel.DelegatingBroker.commit
>> (DelegatingBroker.java:831)
>> at org.apache.openjpa.persistence.EntityManagerImpl.commit
>> (EntityManagerImpl.java:360)
>> ... 21 more
>> Caused by: <0|false|0.9.0-incubating-SNAPSHOT>
>> org.apache.openjpa.persistence.PersistenceException: [BEA]
>> [SQLServer JDBC Driver][SQLServer]DELETE statement conflicted with
>> COLUMN REFERENCE constraint 'JpaChild_Parent_FK'. The conflict
>> occurred in database 'pocdb', table 'JpaChild', column 'ParentId'.
>> {prepstmnt 32048085 DELETE FROM JpaParent WHERE Id = ? AND OptLock
>> = ? [params=(int) 1, (int) 1]} [code=547, state=23000]
>> FailedObject: openjpa.model.JpaParent-1
>> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException
>> (DBDictionary.java:3701)
>> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore
>> (SQLExceptions.java:94)
>> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore
>> (SQLExceptions.java:64)
>> at
>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInte
>> rnal(PreparedStatementManagerImpl.java:103)
>> at
>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush
>> (PreparedStatementManagerImpl.java:68)
>> at
>> org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrima
>> ryRow(OperationOrderUpdateManager.java:158)
>> at
>> org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush
>> (OperationOrderUpdateManager.java:86)
>> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush
>> (AbstractUpdateManager.java:88)
>> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush
>> (AbstractUpdateManager.java:68)
>> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush
>> (JDBCStoreManager.java:512)
>> at org.apache.openjpa.kernel.DelegatingStoreManager.flush
>> (DelegatingStoreManager.java:127)
>> ... 28 more
>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: [BEA]
>> [SQLServer JDBC Driver][SQLServer]DELETE statement conflicted with
>> COLUMN REFERENCE constraint 'JpaChild_Parent_FK'. The conflict
>> occurred in database 'pocdb', table 'JpaChild', column 'ParentId'.
>> {prepstmnt 32048085 DELETE FROM JpaParent WHERE Id = ? AND OptLock
>> = ? [params=(int) 1, (int) 1]} [code=547, state=23000]
>> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap
>> (LoggingConnectionDecorator.java:186)
>> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access
>> $700(LoggingConnectionDecorator.java:53)
>> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator
>> $LoggingConnection$LoggingPreparedStatement.executeUpdate
>> (LoggingConnectionDecorator.java:839)
>> at
>> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate
>> (DelegatingPreparedStatement.java:266)
>> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager
>> $CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1359)
>> at
>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInte
>> rnal(PreparedStatementManagerImpl.java:92)
>> ... 35 more
>
> --
> This message is automatically generated by JIRA.
> -
> If you think it was sent incorrectly contact one of the
> administrators: http://issues.apache.org/jira/secure/
> Administrators.jspa
> -
> For more information on JIRA, see: http://www.atlassian.com/
> software/jira
>
>
Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!
[jira] Resolved: (OPENJPA-39) Cascade delete does not work with
foreign key constraints
Posted by "Abe White (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OPENJPA-39?page=all ]
Abe White resolved OPENJPA-39.
------------------------------
Resolution: Won't Fix
Turns out the problem is more complicated than just having a foreign key. The issue is:
- OpenJPA's UpdateManager plugin does not reorder SQL. It issues SQL in the same order as the corresponding object-level operations. The SQL-reordering UpdateManager is unique to Kodo.
- When you delete a parent object and the operation cascades to children, the object-level operation order is delete parent, then delete children.
- Issuing the SQL in that order will violate the FK constraint. OpenJPA is smart enough to detect this and null the children record's FK columns before deleting the parent.
- However, the columns in this case are non-nullable, so this strategy doesn't work.
So, given that there are no plans to donate Kodo's SQL-reordering UpdateManager, the options are:
1. Use nullable foreign key columns, or
2. Delete the child objects before the parent at the object level.
Also if you choose option #1, make sure to get the latest OpenJPA from SVN, as there was a critical problem with nulling the FK columns correctly that is now fixed (9/11/2006).
> Cascade delete does not work with foreign key constraints
> ---------------------------------------------------------
>
> Key: OPENJPA-39
> URL: http://issues.apache.org/jira/browse/OPENJPA-39
> Project: OpenJPA
> Issue Type: Bug
> Components: jpa
> Environment: Microsoft SQL Server 2000
> Windows XP
> Java SE 1.5
> OpenJPA - source downloaded Aug 28, 2006)
> Show »
> Microsoft SQL Server 2000 Windows XP Java SE 1.5 OpenJPA - source downloaded today (Aug 14, 2006)
> Reporter: Megan
> Priority: Minor
> Attachments: testcase.zip
>
>
> Removing a parent object in OneToMany with cascade=CascadeType.ALL raises foreign key constraints exception
> JpaParent.java
> @OneToMany(mappedBy="parent", cascade=CascadeType.ALL)
> private Set<JpaChild> children = new HashSet<JpaChild>();
> JpaChild.java
> @ManyToOne(optional=false)
> @JoinColumn(name="ParentId", nullable=false)
> private JpaParent parent = null;
> // This raises the following exception. If foreign key is removed, it works OK (Maybe I have to let OpenJPA know about foreign key constraints)
> JpaParent parent = em.find(JpaParent.class, 1);
> em.remove(parent);
> <2|true|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
> at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:371)
> at openjpa.test.BaseTestCase.destroyTestCase(BaseTestCase.java:82)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at org.junit.internal.runners.BeforeAndAfterRunner.invokeMethod(BeforeAndAfterRunner.java:74)
> at org.junit.internal.runners.BeforeAndAfterRunner.runAfters(BeforeAndAfterRunner.java:65)
> at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:37)
> at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
> at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
> at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:71)
> at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
> at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
> at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
> at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
> Caused by: <0|true|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
> at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2028)
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1876)
> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1772)
> at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1706)
> at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:76)
> at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1271)
> at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:831)
> at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:360)
> ... 21 more
> Caused by: <0|false|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.PersistenceException: [BEA][SQLServer JDBC Driver][SQLServer]DELETE statement conflicted with COLUMN REFERENCE constraint 'JpaChild_Parent_FK'. The conflict occurred in database 'pocdb', table 'JpaChild', column 'ParentId'. {prepstmnt 32048085 DELETE FROM JpaParent WHERE Id = ? AND OptLock = ? [params=(int) 1, (int) 1]} [code=547, state=23000]
> FailedObject: openjpa.model.JpaParent-1
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3701)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:94)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:103)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:68)
> at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrimaryRow(OperationOrderUpdateManager.java:158)
> at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(OperationOrderUpdateManager.java:86)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:88)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:68)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:512)
> at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:127)
> ... 28 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: [BEA][SQLServer JDBC Driver][SQLServer]DELETE statement conflicted with COLUMN REFERENCE constraint 'JpaChild_Parent_FK'. The conflict occurred in database 'pocdb', table 'JpaChild', column 'ParentId'. {prepstmnt 32048085 DELETE FROM JpaParent WHERE Id = ? AND OptLock = ? [params=(int) 1, (int) 1]} [code=547, state=23000]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:186)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:53)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:839)
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:266)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1359)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:92)
> ... 35 more
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (OPENJPA-39) Cascade delete does not work with
foreign key constraints
Posted by "Abe White (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OPENJPA-39?page=comments#action_12434283 ]
Abe White commented on OPENJPA-39:
----------------------------------
I implemented Craig's suggestion of always considering the child object as deleted first when cascading a delete from parent to child. So this test case will now work even with non-nullable foreign key columns.
> Cascade delete does not work with foreign key constraints
> ---------------------------------------------------------
>
> Key: OPENJPA-39
> URL: http://issues.apache.org/jira/browse/OPENJPA-39
> Project: OpenJPA
> Issue Type: Bug
> Components: jpa
> Environment: Microsoft SQL Server 2000
> Windows XP
> Java SE 1.5
> OpenJPA - source downloaded Aug 28, 2006)
> Show »
> Microsoft SQL Server 2000 Windows XP Java SE 1.5 OpenJPA - source downloaded today (Aug 14, 2006)
> Reporter: Megan
> Priority: Minor
> Attachments: testcase.zip
>
>
> Removing a parent object in OneToMany with cascade=CascadeType.ALL raises foreign key constraints exception
> JpaParent.java
> @OneToMany(mappedBy="parent", cascade=CascadeType.ALL)
> private Set<JpaChild> children = new HashSet<JpaChild>();
> JpaChild.java
> @ManyToOne(optional=false)
> @JoinColumn(name="ParentId", nullable=false)
> private JpaParent parent = null;
> // This raises the following exception. If foreign key is removed, it works OK (Maybe I have to let OpenJPA know about foreign key constraints)
> JpaParent parent = em.find(JpaParent.class, 1);
> em.remove(parent);
> <2|true|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
> at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:371)
> at openjpa.test.BaseTestCase.destroyTestCase(BaseTestCase.java:82)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at org.junit.internal.runners.BeforeAndAfterRunner.invokeMethod(BeforeAndAfterRunner.java:74)
> at org.junit.internal.runners.BeforeAndAfterRunner.runAfters(BeforeAndAfterRunner.java:65)
> at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:37)
> at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
> at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
> at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:71)
> at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
> at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
> at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
> at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
> Caused by: <0|true|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
> at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2028)
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1876)
> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1772)
> at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1706)
> at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:76)
> at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1271)
> at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:831)
> at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:360)
> ... 21 more
> Caused by: <0|false|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.PersistenceException: [BEA][SQLServer JDBC Driver][SQLServer]DELETE statement conflicted with COLUMN REFERENCE constraint 'JpaChild_Parent_FK'. The conflict occurred in database 'pocdb', table 'JpaChild', column 'ParentId'. {prepstmnt 32048085 DELETE FROM JpaParent WHERE Id = ? AND OptLock = ? [params=(int) 1, (int) 1]} [code=547, state=23000]
> FailedObject: openjpa.model.JpaParent-1
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3701)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:94)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:103)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:68)
> at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrimaryRow(OperationOrderUpdateManager.java:158)
> at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(OperationOrderUpdateManager.java:86)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:88)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:68)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:512)
> at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:127)
> ... 28 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: [BEA][SQLServer JDBC Driver][SQLServer]DELETE statement conflicted with COLUMN REFERENCE constraint 'JpaChild_Parent_FK'. The conflict occurred in database 'pocdb', table 'JpaChild', column 'ParentId'. {prepstmnt 32048085 DELETE FROM JpaParent WHERE Id = ? AND OptLock = ? [params=(int) 1, (int) 1]} [code=547, state=23000]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:186)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:53)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:839)
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:266)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1359)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:92)
> ... 35 more
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (OPENJPA-39) Cascade delete does not work with
foreign key constraints
Posted by "Megan (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OPENJPA-39?page=comments#action_12432316 ]
Megan commented on OPENJPA-39:
------------------------------
I have tried all 3 options but I am getting the same error. Could you review if my configuration is correct
1. Using the org.apache.openjpa.persistence.ForeignKey annotation (maybe I need more than adding @ForeignKey annotation)
JpaChild.java:
@ManyToOne(optional=false)
@JoinColumn(name="ParentId", nullable=false)
@ForeignKey
private JpaParent parent = null;
2. Setting the "openjpa.jdbc.SchemaFactory" property
<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence persistence_1_0.xsd"
version="1.0">
<persistence-unit name="test" transaction-type="RESOURCE_LOCAL">
<provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
<class>openjpa.model.JpaParent</class>
<class>openjpa.model.JpaChild</class>
<properties>
<property name="openjpa.jdbc.DBDictionary" value="sqlserver"/>
<property name="openjpa.ConnectionDriverName" value="weblogic.jdbc.sqlserver.SQLServerDriver"/>
<property name="openjpa.ConnectionURL" value="jdbc:bea:sqlserver://hostname:1433;databaseName=dbname"/>
<property name="openjpa.ConnectionUserName" value="username"/>
<property name="openjpa.ConnectionPassword" value="password"/>
<property name="openjpa.jdbc.SchemaFactory" value="native(ForeignKeys=true)"/>
<property name="openjpa.Log" value="DefaultLevel=WARN, Tool=INFO"/>
</properties>
</persistence-unit>
</persistence>
3. Setting the "openjpa.jdbc.MappingDefaults" property
<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence persistence_1_0.xsd"
version="1.0">
<persistence-unit name="test" transaction-type="RESOURCE_LOCAL">
<provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
<class>openjpa.model.JpaParent</class>
<class>openjpa.model.JpaChild</class>
<properties>
<property name="openjpa.jdbc.DBDictionary" value="sqlserver"/>
<property name="openjpa.ConnectionDriverName" value="weblogic.jdbc.sqlserver.SQLServerDriver"/>
<property name="openjpa.ConnectionURL" value="jdbc:bea:sqlserver://hostname:1433;databaseName=dbname"/>
<property name="openjpa.ConnectionUserName" value="username"/>
<property name="openjpa.ConnectionPassword" value="password"/>
<property name="openjpa.jdbc.MappingDefaults" value="jpa(ForeignKeyDeleteAction=restrict, JoinForeignKeyDeleteAction=restrict)"/>
<property name="openjpa.Log" value="DefaultLevel=WARN, Tool=INFO"/>
</properties>
</persistence-unit>
</persistence>
> Cascade delete does not work with foreign key constraints
> ---------------------------------------------------------
>
> Key: OPENJPA-39
> URL: http://issues.apache.org/jira/browse/OPENJPA-39
> Project: OpenJPA
> Issue Type: Bug
> Components: jpa
> Environment: Microsoft SQL Server 2000
> Windows XP
> Java SE 1.5
> OpenJPA - source downloaded Aug 28, 2006)
> Show »
> Microsoft SQL Server 2000 Windows XP Java SE 1.5 OpenJPA - source downloaded today (Aug 14, 2006)
> Reporter: Megan
> Priority: Minor
> Attachments: testcase.zip
>
>
> Removing a parent object in OneToMany with cascade=CascadeType.ALL raises foreign key constraints exception
> JpaParent.java
> @OneToMany(mappedBy="parent", cascade=CascadeType.ALL)
> private Set<JpaChild> children = new HashSet<JpaChild>();
> JpaChild.java
> @ManyToOne(optional=false)
> @JoinColumn(name="ParentId", nullable=false)
> private JpaParent parent = null;
> // This raises the following exception. If foreign key is removed, it works OK (Maybe I have to let OpenJPA know about foreign key constraints)
> JpaParent parent = em.find(JpaParent.class, 1);
> em.remove(parent);
> <2|true|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
> at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:371)
> at openjpa.test.BaseTestCase.destroyTestCase(BaseTestCase.java:82)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at org.junit.internal.runners.BeforeAndAfterRunner.invokeMethod(BeforeAndAfterRunner.java:74)
> at org.junit.internal.runners.BeforeAndAfterRunner.runAfters(BeforeAndAfterRunner.java:65)
> at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:37)
> at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
> at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
> at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:71)
> at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
> at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
> at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
> at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
> Caused by: <0|true|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
> at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2028)
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1876)
> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1772)
> at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1706)
> at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:76)
> at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1271)
> at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:831)
> at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:360)
> ... 21 more
> Caused by: <0|false|0.9.0-incubating-SNAPSHOT> org.apache.openjpa.persistence.PersistenceException: [BEA][SQLServer JDBC Driver][SQLServer]DELETE statement conflicted with COLUMN REFERENCE constraint 'JpaChild_Parent_FK'. The conflict occurred in database 'pocdb', table 'JpaChild', column 'ParentId'. {prepstmnt 32048085 DELETE FROM JpaParent WHERE Id = ? AND OptLock = ? [params=(int) 1, (int) 1]} [code=547, state=23000]
> FailedObject: openjpa.model.JpaParent-1
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3701)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:94)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:103)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:68)
> at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrimaryRow(OperationOrderUpdateManager.java:158)
> at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(OperationOrderUpdateManager.java:86)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:88)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:68)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:512)
> at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:127)
> ... 28 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: [BEA][SQLServer JDBC Driver][SQLServer]DELETE statement conflicted with COLUMN REFERENCE constraint 'JpaChild_Parent_FK'. The conflict occurred in database 'pocdb', table 'JpaChild', column 'ParentId'. {prepstmnt 32048085 DELETE FROM JpaParent WHERE Id = ? AND OptLock = ? [params=(int) 1, (int) 1]} [code=547, state=23000]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:186)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:53)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:839)
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:266)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1359)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:92)
> ... 35 more
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira