is it possible to generate duplicate ID in load balance environment?

[seanl]

hi,

Suppose we have two servers which are running the engine and share one database in a load balance environment.    and both of them hit the function 'getNextId' in DbIdGenerator.java at exactly the same time, will it generate duplicate ID?

It's a rare case but still be a possible issue as we use database to generate a 'Unique'  IdBlock for every engine.

Thanks
Sean

[seanl]

please help me on this

[jbarrez]

No, a block of ID's is fetched using a transaction on a row in the ACT_GE_PROPERTY table. This works in a multi-node environment.

An alternative to using that id generator, is using an UUID generator.