All,

I'm working on a legacy database that is using the table per concrete class with implicit polymorphism for mapping class inheritance. I'm in the process of moving to table per concrete class with unions, but there is one problem. Each table uses it's own sequence generator.

Prior to trying to move to table per concrete class with unions, I mapped the sequence generator for each class and everything works fine.

Is it possible to move to table per concrete class with unions and maintain a separate sequence generator for each class? I have searched and tried different approaches but each time Hibernate wants to use the sequence generator for the base class.

I'm using Oracle 10g for my database and Hibernate version 3.2 and mapping my classes with annotations version Hiberante-Annotations 3.2 GA.

Thanks