• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Avoiding duplicate records
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


  • Follow-Ups:
    • Re: Avoiding duplicate records
      • From: David Avendasora <email@hidden>
    • Re: Avoiding duplicate records
      • From: Miguel Arroz <email@hidden>
References: 
 >Avoiding duplicate records (From: Miguel Arroz <email@hidden>)
 >Re: Avoiding duplicate records (From: David Avendasora <email@hidden>)

  • Prev by Date: Re: Avoiding duplicate records
  • Next by Date: Re: Avoiding duplicate records
  • Previous by thread: Re: Avoiding duplicate records
  • Next by thread: Re: Avoiding duplicate records
  • Index(es):
    • Date
    • Thread