Hibernate version:3.1.3

Mapping documents:

Here is the mapping of the Auto-Generated ID column of my object...



When I try to run the validation of the configuration I get this error...

10:28:59,208 INFO DatabaseMetadata:91 - table not found: NB_GENERIC_SEQ

Name and version of the database you are using: Oracle 9i

It seems that it cannot resolve the Sequence in the DB, however executing SELECT NB_GENERIC_SEQ.nextval FROM dual works fine...

Is there anything I'm missing here?

I guess, the schema name is missing, specify the schema at the top level.

<hibernate-mapping
schema="SCHEMA_NAME"
>



---------
Don't forget to rate! (if the answer helped)

That didn't fix the problem, both as a declaration in the XML as well as specifying the schema in the sequence name...



The fact that it is looking for it as a table is somewhat concerning.

The reason I asked in this forum is because this works perfectly in my unit tests using hsqdb and the hibernate.hbm2ddl.auto=create option. I did see an article somewhere where they actually extended a hibernate class to add sequence fetching capabilities, but I don't want to get involved at that level, I just want it to work :)

[/code]

Can you show us the sql hibernate generates ?

I'm having the same problem with PostgreSQL 8.1 and Hibernate 3.1.3. When I have a mapping file that looks like this:



I get the following errors when I set the hbm2ddl.auto property to update in my hibernate.cfg.xml file:



Any ideas how to fix this?

Bruce