Re: Avoiding duplicate records
Re: Avoiding duplicate records
- Subject: Re: Avoiding duplicate records
- From: Miguel Arroz <email@hidden>
- Date: Tue, 15 Jan 2008 16:12:14 +0000
Hi!
Keep cool you guys! :)
This is not a "regular" contact list. In this case, it really
doesn't make any sense to have more than one email address in each
contact list. :)
Yours
Miguel Arroz
On 2008/01/15, at 16:08, Mike Schrag wrote:
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:
40guiamac.com
This email sent to email@hidden
Miguel Arroz
http://www.terminalapp.net
http://www.ipragma.com
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
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