Hi,

I need to change the schema name of a sequence on run time.
I plan to create few different dataSource that will be linked to different schema and I also need to change the sequence's schema name according to it.
Is there a way to do this ?

Currently the schema name is hard coded in the hbm file:
<id name="documentId" type="integer" column="DOCUMENT_ID">
<generator class="sequence">
<param name="sequence">SCHEMA_NAME.P_DOCUMENT_SEQ</param>
</generator>
</id>

I would like to remove this from the hbm file and set it dynamically..

Thanks for all the helpers :)
Lital