Hello Folks,

I am using Oracle 10g as my backend database. I have a table that has a NUMEBER field as the primary key but is not an IDENTITY, nor is there a sequence defined in the database. I would like to using the generator class=increment when inserting a new record.

However, hibernate maps NUMBER to BIG_DECIMAL and as such, the increment class cannot be used. Is there any way around this? If there isn't, what is the best strategy to solve this problem besides defining a sequence in the database?