hi all

am making a test to migrate from postgres to MSSQL 2005 i got a problem that i couldn't insert a record in the after using a spy i found that the insert statement is generated dublicate so the transaction is roled back

log for MSSQL 2005:-
1194517178278|0|4|statement|insert into COMPANY (COMPANY_SETTING_FK, UNIT_FK, ID) values (?, ?, ?)|insert into COMPANY (COMPANY_SETTING_FK, UNIT_FK, ID) values ('', '', '2c928a85127622e501127622eee70002')
1194517178435|0|4|statement|insert into COMPANY (COMPANY_SETTING_FK, UNIT_FK, ID) values (?, ?, ?)|insert into COMPANY (COMPANY_SETTING_FK, UNIT_FK, ID) values ('', '', '2c928a85127622e501127622eee70002')
1194517178450|0|4|rollback||


log for postgres:-
1194515470006|15|4|statement|insert into COMPANY (COMPANY_SETTING_FK, UNIT_FK, ID) values (?, ?, ?)|insert into COMPANY (COMPANY_SETTING_FK, UNIT_FK, ID) values ('', '', '2c928a85127622e501127622eee70002')


my driver : net.sourceforge.jtds.jdbc.Driver


hbm:-
<class name="CompanyImpl" table="COMPANY" dynamic-insert="false" dynamic-update="false">
<id name="id" type="java.lang.String" unsaved-value="null">
<column name="ID" sql-type="VARCHAR(255)"/>
<generator class="foreign">
<param name="property">organization</param>
</generator>
</id>
<one-to-one name="organization" class="OrganizationImpl" foreign-key="COMPANY_ORGANIZATION_FKC" cascade="none" constrained="true" lazy="proxy" fetch="select"/>


dialact & sqlmappings are configured for sql server

all other operations work fine just this is the only case i use generator class="foreign"