Hi All,

I would like to use a same tool on different computers (so different jvm) which saves data to a Derby database setuped in server mode (not embedded).
This tool uses Hibernate version 3.2.0.ga and a HILO ID generator for several tables.

Can the tools on different computers generate a same ID due to the HILO generator, and thus create an error ?

I've read the doc on HILO but didn't find an answer to this question...

Thanks in advance for your help and light :-)

Regards,
JavaWorker

No it should not. HILO will reserve a range of ids each time it goes to the HILO table in db and thenafter it only dispenses from its reserved region which is not available to the other instances. This process repeats each time it runs out of available ids. The downside of this is that if you configure your region size with a high number you will lose ids if your instances restart frequently.