Hello friends -

I'm curious as to how the hilo function is generating numbers. I have a hibernate_unique_key table with the column, workorder_history_id column. That column is populated with a value. However, the value it has never seems to increment, and is tens of thousands behind the actual key value being pushed in when I create new records into the table referenced by the code snipet below.

I've experienced no errors, but am having a bit of a sinking feeling that I don't really understand how the hilo mechanism is getting new values. If I create new records, the value in hiberante_unique_key does not increment, but I get valid primary keys. If I change the parameter in the column to a column that does not exist in hibernate_unique_key, I get errors, so I'm confident that the parameters are being taken in and used.

Can anyone help? Thanks!
-pD

Hibernate version:

2.1

Mapping documents:

<generator class="hilo">
<param name="column">workorder_history_id</param>
</generator>

Name and version of the database you are using:

mysql 4.1

The generated SQL (show_sql=true):