Re: Avoiding duplicate records
Re: Avoiding duplicate records
- Subject: Re: Avoiding duplicate records
- From: Mike Schrag <email@hidden>
- Date: Tue, 15 Jan 2008 11:08:23 -0500
I think this is a case of something seeming unique, but really
isn't. You can have a business rule that says they don't want
duplicates, but hard-coding business rules into the DB can lead to
problems in the future. Use Java to enforce the business logic, not
the DB.
Initiate religious argument .............. NOW.
Regardless of the business logic debate, one HUGE caveat here is that
you cannot properly resolve several race conditions in EOF
implementing logic purely in Java. In particular, enforcing
uniqueness is a really nasty one. If you have multiple instances or
multiple EOF stacks, you will always be open to a race trying to keep
values unique without also having a unique constraint on your database
(where the database can enforce that atomically).
ms
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden