Hibernate version: 3.2

I am trying to assign the id using Oracle sequence.

i have this xml mapping:

...
<class name="MyObject" table="My_TABLE">
<id name="id" column="ID" type="long" unsaved-value="null">
<generator class="sequence">
<param name="sequence">MY_SEQ</param>
</generator>
</id>
...

Hibernate properties:
<prop key="hibernate.default_schema">MySchema</prop>

When loading my xml mapping files, I'm getting this exception:

Caused by: org.hibernate.HibernateException: Missing sequence or table: MySchema.MY_SEQ

All the other tables work fine with that assigned schema. And when I execute this sql, the object is find correctly:
SELECT MySchema.MY_SEQ.CURRVAL
FROM dual;

Any ideas?

Thanks,
Gabriel

I just deactivated next property and it works. Do not know why though.

<!--prop key="hibernate.hbm2ddl.auto">validate</prop-->

I have encountered the same error when using Oracle & JBoss Seam. Problem is, the property hibernate.hbm2ddl.auto already seems to be disabled. I posted the problem in a separate thread but no response yet:

http://forum.hibernate.org/viewtopic.php?t=971878&highlight=hibernateexception+sequence

I would really like to continue with Seam/Hibernate but this is a roadblock...

On Oracle 10g and Hibernate 3.2.5.ga

I seem to have this problem only if I am trying to use a sequence that is in a schema other than the login user's own schema. It works fine if I use the login user's own schema.

Also, if I use hibernate.hbm2ddl.auto = update it seems to work.

I hope this is somehow helpful.

Thanks,
Ernie