Eclipse Community Forums: EclipseLink » Set join column to null after removing the related row?

Home » Eclipse Projects » EclipseLink » Set join column to null after removing the related row?(How to set a join column to null if the related row was removed)

Set join column to null after removing the related row? [message #524275]

Wed, 31 March 2010 07:46

Eclipse User

Hi,

I have a one-to-one relationship and want to set the join column of this relation to null if the related row was removed. At the moment I just found ways to cascade which removes the row in the child table. I need a way to say it in SQL like "ON DELETE SET NULL".
All what I try removes the child row(cascade, orphan-removal, private-owned, ...). Any suggestions what I have to do? Thanks in advance!

regards
Christian

Re: Set join column to null after removing the related row? [message #524634 is a reply to message #524275]

Thu, 01 April 2010 12:13

Eclipse User

Hello Christian,

JPA does not maintain relationships for you, so if the application removes an entity, the application will need to clean up/null out references to that entity itself. You can use the "ON DELETE SET NULL" in the database to null out FKs, but this will leave objects in the cache inconsistent with what is in the database - objects referencing the removed entity will still reference it in the cache. This can be overcome if you manually refresh the objects with these references, but this comes at the expense of a database hit anyway.

If the problem is that the code doing the remove cannot know of the objects that are left referencing it, the application could use a the pre-update/remove/write event methods to manage referencing relationships. These methods might allow the modified entity to manage relationships other Entities might have to it.

Best Regards,
Chris

Re: Set join column to null after removing the related row? [message #524742 is a reply to message #524634]

Fri, 02 April 2010 03:52

Eclipse User

Hello Chris,

thanks for you reply!
That means I needn't to create any relation (one-to-one, ...) but I have to set to "null", with the event methods, manually, haven't?

What I want to do: I'll link an "Account" with the corresponding "Session". Account has a Column "FK_SESSION_ID", this column I need to set to null if the session expire or becomes invalid otherwise. Should I realize it on another way or is my intention the right way? I just want that one Account can only have one or none Session.

best regards
Christian

Previous Topic:	Unexplained Update Statements affecting Concurrency
Next Topic:	Record persist order

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 21:39:39 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter