In my project I have to write work flow trace to a history tables. As it may grow exponentially, I would like to use a separate sequence. And this table has no relation with other entities.

So can I have more than one sequence in my hibernate mappings. I need one to generate ids when entities are saved. And the other one for history entity.

How can I specify the id generator property for history entity to use second sequence. I am using Oracle 9i.

Thanks

I don't understand very well your problem, but maybe this can help you:
http://www.hibernate.org/296.html

i'm using oracle sequence and here's my mapping file:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping
>
<class
name="com.test.vo.SequenceVO"
table="DUAL"
dynamic-insert="true"
optimistic-lock="version"
>

<id
name="num"
column="num"
type="long"
>
<generator class="assigned">
<!--
To add non XDoclet generator parameters, create a file named
hibernate-generator-params-Sequence.xml
containing the additional parameters and place it in your merge dir.
-->
</generator>
</id>

<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-Sequence.xml
containing the additional properties and place it in your merge dir.
-->

</class>

<sql-query name="get_message_id_seq">
<return alias="seq" class="com.test.vo.SequenceVO"/>
select msg_id_seq.nextval as {seq.num} from dual
</sql-query>

<sql-query name="get_user_session_id_seq">
<return alias="seq" class="com.test.vo.SequenceVO"/>
select SEQ_USER_SESSION_ID.nextval as {seq.num} from dual
</sql-query>

<sql-query name="get_instruction_id_seq">
<return alias="seq" class="com.test.vo.SequenceVO"/>
select SEQ_INSTRUCTION_ID.nextval as {seq.num} from dual
</sql-query>

</hibernate-mapping>