I've been trying out the HiLo algorithm for generating my ids and I see a problem on the horizon if I use MySQL. Because the HiLo algorithm uses one column per required id ( therefore per table ) if I have more than 255 tables that require generated ids the hilo table will not work because of MySQLs limit of 255 columns per table.

The options I see to avoid this are:

Use the HiLo system for now and create a second generator table should my table count get > 255.

or

Write my own generator class to have one row per generated table rather than one column?

Is there a more straightforward solution I am missing or a way of making the current HiLo implementation do the second option?

Cheers.

Myk.

? HiLo just uses one column for all tables.

Unless you want to have different id series per persistent entity ;-)

Have a look to http://forum.hibernate.org/viewtopic.php?t=927541... This is probably what you are looking for. Unfortunately, I haven't received any answer from Gavin yet :-(

Who would ever want that ;-)

Heu... me :-(
I've been thinking about it ;-)