When I attempt to run my unit test im getting the following error

DEBUG - BatcherImpl.log(229) | select hibernate_sequence.nextval from dual
DEBUG - BatcherImpl.getPreparedStatement(252) | preparing statement
DEBUG - JDBCExceptionReporter.logExceptions(49) | SQL Exception
java.sql.SQLException: ORA-02289: sequence does not exist


How do I not use the default sequence (hibernate_sequence).

In my mapping files I have the following, so it should be working right?

<generator class="sequence">
<param name="sequence">id_sequence</param>
</generator>

My sequence is called "id_sequence"

The snippit looks right to me. Not sure whats going on. Need to provide more information, eg, version of hibernate, more complete mapping document etc.