[OFBiz] Users - POS and synchronization question

[David Jones]

Si,

"Guaranteed" unique sequences are a pretty tricky (and often error 
prone) prospect...

I think, for now, the best option is prefixing.

-David


On Jul 2, 2004, at 3:38 PM, Si Chen wrote:

> Hello everybody.
>
> Working on the synchronization, and then reading some of the posts 
> about a POS solutions, makes me wonder about how to solve something 
> like this:
>
> Each instance of Open for Business, with its own entity engine, will 
> create id's for entities based on a sequence (10000, 10001, etc.)  It 
> will create these ids for orders, parties, people, addresses, phone 
> numbers, etc.  How do we keep them separated from each other?  That 
> way, they can all be uploaded to a central server or shared with each 
> other?  (Otherwise, seeing two partyId 10000 or two orderId 10000 or 
> two contactMechId 10000 might cause problems.)
>
> At first I thought it might be possible just to prefix orders from 
> differently stores with a code, but then I realized the same would 
> have to be done for all the other entities (like people, parties, 
> addresses...)  So this doesn't seem practical.
>
> Should some kind of scrambling algorithm be used for the id's, rather 
> than just getting the next numerical sequence?  Perhaps there is a way 
> to generate guaranteed unique number sequences?
>
> Thanks,
>
> Si Chen
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at ofbiz.dev.java.net
> For additional commands, e-mail: users-help at ofbiz.dev.java.net
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2363 bytes
Desc: not available
Url : http://lists.ofbiz.org/pipermail/users/attachments/20040703/d51a6efe/smime.bin