L.S.,


I'm using Hibernate version 3.2.4 in combination with HSQL DB 1.8.0 for unit testing purposes.

In my mapping document, I have
<set name="products" access="field" table="CATEGORY_PRODUCTS" order-by="RANKING">
<key column="CATEGORY_ID"/>
<many-to-many class="Product" column="PRODUCT_ID"/>
</set>

When hbm2ddl generates the tables, it doesn't generate a RANKING column on the CATEGORY_PRODUCTS table. I guess this is quite normal, because there is no way the hbm2ddl tool can now what type of column to generate. How can I get Hibernate to create this column anyway?


Thank you for any help,

Gert

map the column so it knows what type it is