Hi all,
We're trying to unit test our hibernate DAOs and controllers and we're going down the route of using an in-memory HSQLDB to run the tests.
However, it seems that we're having problems with hbm2ddl/SchemaExport.
Several of our mappings use a hilo generator for the primary key (see examples below). The problem is that the SchemaExport is only creating the column for the first one alphabetically (in this case nextbackinstockemailid). Obviously this means that any tests that depend on the other generator columns fail.
Is this something that the SchemaExport just can't do? Is it something that can be fixed by tweaking the mappings. An obvious fix would be to use a different table for each generator but this isn't ideal since hibernate itself can use the schema just fine and we don't want to be changing our mappings just to satisfy the tests unless it turns out that our mappings are actually wrong.
Hibernate version: 3.2
Mapping documents:
Hibernate properties bean:
Code:
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.HSQLDialect</prop>
<!-- Display generated SQL -->
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">false</prop>
<prop key="default-lazy">true</prop>
<!-- Create this database in-memory each time -->
<prop key="hibernate.hbm2ddl.auto">create-drop</prop>
<!-- Enable Hibernate's automatic session context management -->
<prop key="hibernate.current_session_context_class">thread</prop>
<!-- Apparently this makes HSQL work properly -->
<prop key="hibernate.jdbc.batch_size">0</prop>
<!-- Disable the second-level cache -->
<prop key="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</prop>
<!-- get set info thing -->
<prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
</props>
</property>
</bean>
Several mapping files use generated hilo IDs in the table NextKey.
Code:
<id name="id" column="basketid">
<generator class="hilo">
<param name="table">NextKey</param>
<param name="column">nextbasketid</param>
</generator>
</id>
Code:
<id name="id" column="backinstockemailid">
<generator class="hilo">
<param name="table">NextKey</param>
<param name="column">nextbackinstockemailid</param>
</generator>
</id>
Generated create statement for NextKey:
Code:
create table NextKey ( nextbackinstockemailid integer )
INSERT INTO NEXTKEY VALUES(0)
and several more, all written in the same format.
Full stack trace of any exception that occurs:Console output from running the tests:
Code:
10:18:14,296 ERROR SchemaExport:272 - Unsuccessful: alter table CharacterProduct add constraint FK97C6BDA6AEA3B6D8 foreign key (productid) references Product
10:18:14,296 ERROR SchemaExport:273 - Constraint already exists in statement [alter table CharacterProduct add constraint FK97C6BDA6AEA3B6D8 foreign key (productid) references Product]
10:18:14,312 ERROR SchemaExport:272 - Unsuccessful: alter table Product add constraint FK50C664CFBDCD6E6A foreign key (groupid) references Product
10:18:14,312 ERROR SchemaExport:273 - Constraint already exists in statement [alter table Product add constraint FK50C664CFBDCD6E6A foreign key (groupid) references Product]
10:18:14,312 ERROR SchemaExport:272 - Unsuccessful: alter table ProductArtist add constraint FK4EFD18F6AEA3B6D8 foreign key (productid) references Product
10:18:14,312 ERROR SchemaExport:273 - Constraint already exists in statement [alter table ProductArtist add constraint FK4EFD18F6AEA3B6D8 foreign key (productid) references Product]
10:18:14,312 ERROR SchemaExport:272 - Unsuccessful: alter table PromotionProduct add constraint FK3B39BEECAEA3B6D8 foreign key (productid) references Product
10:18:14,312 ERROR SchemaExport:273 - Constraint already exists in statement [alter table PromotionProduct add constraint FK3B39BEECAEA3B6D8 foreign key (productid) references Product]
10:18:14,312 ERROR SchemaExport:272 - Unsuccessful: alter table Signed add constraint FK939A5B3CAEA3B6D8 foreign key (productid) references Product
10:18:14,312 ERROR SchemaExport:273 - Constraint already exists in statement [alter table Signed add constraint FK939A5B3CAEA3B6D8 foreign key (productid) references Product]
10:18:14,906 WARN JDBCExceptionReporter:71 - SQL Error: -28, SQLState: S0022
10:18:14,906 ERROR JDBCExceptionReporter:72 - Column not found: NEXTBASKETID in statement [select nextbasketid from NextKey]
Name and version of the database you are using:
hsqldb (latest version).
Any help would be greatly appreciated
Login
FAQ
Search
