Hello All,

I have a problem:
In our datamodel all the many to many relations are normally modelled, but to be in compliance with some European law all data must be historical retrievable. So the bridge tables are also versioned and have 3 extra mandatory date fields. We are using sets with many-to-many relations specified:
<set name="types" inverse="false" lazy="true" table="SDM_VW_PTE_IN_APT">
<key column="APT_ID" />
<many-to-many column="PTE_ID" class="our.package.Type" />
</set>
A fetch works fine, but an insert or update blows because the database (oracle 9.2.0.5.0) does not accept a null inside one of those 3 columns.
Any ideas how to tackle this challenge would be much appreciated.
TIA Jeroen.