Hello, I have to change the way that I generate the ids and I have to now if Hibernate can help me.

In the past I had to generate the Ids (to record of contracts) in sequence. Then I used MS-SQL with Identity and with the following configuration everything works fine:

But now I have a new requirement to generate the Ids, the new id have this form: YYXXXX, where
YY is two digit of the contract year ("04" for 2004) and XXXX is contract sequence number (starts with 0001 for that year).
So 030001 is the first contract of year 2003, 030002 is the second contract of year 2003 and 040001 is the first contract of year 2004.

Is there a way to hibernate help me to generate the sequence of this ids?

Thanks in advance, Claudio.

Hi Claudio,

you can write your own generator (see Hibernate Reference chapter 5.1.4.1. ).


Reto

Thanks for the response.

I've read that chapter. Then I've written my own generator whit a little change on TableGenerator class.
This is my new configuration:


Now when I save a new record (new contract) everything works fine. The new contract gets the correct id and the key table (app_primary_key) updates the value.
But I have a problem. If I try to save a new contract that it have a constraint error (for example duplicate value on a unique field) the key table is updated although the new record is not saved.
I prefer that if the contract is not saved the key table manteins the same value, is this possible?

Thanks, Claudio. (apologize for my english)