EDIT: nevermind guys, I figured this was a bug that was resolved in the more recent versions of Hibernate...
Hi all.
As the title says, I'm having a problem with the default schema not being applied to sequences.
I specified the default schema using the hibernate.default_schema property in the hibernate.properties file.
The sequence name is specified in the mapping file as follows:
Code:
<id name="id" column="id_myitems" type="java.lang.Long">
<generator class="sequence">
<param name="sequence">sq_myitems</param>
</generator>
</id>
The default schema works fine for the tables, but I see that it keeps using the username as the schema for the sequences.
I know I can just hardcode the schema in the mapping file, but for me that is not an option for maintenability reasons.
I'm using Hibernate 2.? and DB2 9.5.
Any help would be appreciated.[/code]