Hibernate version:2.1
Name and version of the database you are using:Oracle 9
I am using the Hibernate Property:
Quote:
default_schema
I set it to a schema, different then the user's schema.
So a mapping of table 'users' becomes 'default_schema.users' in sql
I am also using the hilo method of generating the id. My problem is that the id genertor class does not use the default schema I added in the Hibernate properties.
Everytime Hibernate is trying to read the 'HIBERNATE_UNIQUE_KEY' it doesn't add the default_schema to it and as a result I get a 'table not found exception'
I know that there are several workarounds such as setting your own id generation class or creating oracle synonym but I believe the real solution would be that if someone is setting a default schema it should be added as a default when Hibernate is looking for 'HIBERNATE_UNIQUE_KEY' or 'HIBERNATE_SEQ'
Is this a bug? or is there a reason for this?
Any info would be great,
Thanks
Igal