Hello,
I am using "hilo" ID generator and I am wondering if there is any way to instruct the db to generate the ids in a specific range, particularly given a "start" value. I am not much familiar with hilo algorithm, but anyway, if it is not possible with hilo, is there any other generator to help achieve this?
Thank you very much.
Madhan.

Yes and no.
Since hilo use for high value the value stored in DB, the you can manually update it to DB.
No there is no special start config property.

Thank you! How does the hi-lo value appear in the db? I mean is there is a size proportion for the "high" and "low" digit? I set this number to an "int" and also I believe I can do some kind of bit masking and set the intial value for the "high" part if I know the structure of this number in the db.
Thanks again,
Madhan.

Only the current high-value is stored in the db, the lo-part is generated in memory only by the generator

you have the
<param name="max_lo">100</param> in the generator tag that let you specify the low range.

First time, Hibernate will take hi value from db, and increment a JVM counter from 1 to max_lo
id = hi *maxlo + localcount

once counter = maxlo, then it will take the next high value from the db.

Here is an article on id keys http://www.agiledata.org/essays/dataModeling101.html#AssignKeys