I'm currently using a custom EntityPersister to use stored procedures for CUD operations. Now I need to use subclass/discriminator columns and also <list> mappings with an index column.

I can use getDiscriminatorSQLValue() to find the discriminator value, how do I get the value of my list index? (eg. <list><index column="SEQUENCE"/></list>)

I'd also like to switch to using Hibernate 3's <sql-insert> tags instead of writing the custom EntityPersister objects.

Is this possible? I'm having trouble finding examples. I'm open to either using the EntityPersister or new <sql-insert> tags, whichever is easier and most effective.

Thanks,
- Ryan

there is examples of custom sql in H3 junit tests. CustomSQLTest