Originally posted by Mike Mitchell:
Congrats Rinke!
May I ask about how many hours you spent on the project?
Originally posted by Joshua Fix:
I am working on B&S. For me, it seemed too unlikely that two businesses with the same name are in the same city that offer the same specialties and have the same number of employees and same rate.
Originally posted by Ewan Livingstone:
I don't see any way in which there could ever be any circumstance in which one cannot insert a record because the ID/key already exists.
Am I missing something?
Originally posted by Joshua Fix:
I just call my find(String[]) method on the data that was passed in to the create method. It in turn attempts to match every field of a record to the fields of the record that is trying to be created.
If any matches are returned, then there is an entry with all the same values. In that case, I throw a DuplicateKeyException.
Originally posted by Jim Petersson:
I chose to use name + location as a primary key. Of course this has to be mentioned in the choices file. I guess this is one of those cases were you need to make a design decision for yourself.
Originally posted by Raghavan Muthu:
But hanging is a different issue as there may be some other environmental/OS related factors contributing for it.
Originally posted by Liviu Carausu:
That means that you are either ignoring the requirement "possibly reusing a deleted entry" (You are right, it is not a "must"), or you are compacting somehow the database at startup . Am I right ?