Hi folks,

I'm using Hibernate 2.1 and I'm trying to map a many-to-many with the following code:

<set
name="setName"
table="ColTableName"
lazy="true"
inverse="false"
cascade="none"
sort="unsorted"
>

<key
column="local_id"
/>

<many-to-many
class="OtherClass"
column="other_id"
outer-join="auto"
/>

</set>

Aditional info: local_id and OtherClass.other_id are of type NUMBER(7,0)

When the DDL is generated the collection table (ColTableName) is created with local_id and other_id of type NUMBER(19,0). I don't think it is needed, but I also tried to insert:
<column name="other_id" sql-type="NUMBER(7,0)" />
inside the many-to-many tag, but it didn't work...

Could some good soul help me ?

Thanks in advance,

Walter