Hi, I have an issue in Hibernate mapping...

i am using Informix database. And i am try to map two tables. In the first table i am having the foreign key of the second table. When i am inserting a row in the second table and insert the foreign key in the first table, it inserts a zero(0).

[code]
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
<class table="tab1" name="tab1">

<id name="catExtSrlNo" type="long" column="CAT_EXT_SRL_NO">
<generator class="identity"/>
</id>


<property name="lastUpdatedUser" type="string" not-null="false" column="LAST_UPD_USER"/>
<property name="lastUpdatedTimestamp" type="timestamp" not-null="false" column="LAST_UPD_DT"/>

<many-to-one name="tab2" class="tab2" column="EXT_SRL_NO" not-null="true" lazy="true" cascade="all"/>


</class>
</hibernate-mapping>
[/code]



the ext_srl_no is an auto incremented column. it is the foriegn key of the tab1 . I call the hibernate.save(tab1) and insert a value in tab2 and then insert the foriegn key in tab1. but it is inserting zero(0). can i know why zero is getting inserted.

thanks in advance

Ciao,

I guess your mapping is not right. You say that "ext_srl_no" is an auto incremented column but in the same time is a foreign key. If you map tab1 then you can only reference columns from that table. So if on tab1 you have a column that references a foreign key then it cannot be auto incremented.

I think your classes and mappings should look something like this:

Tab2 class:



Tab2 mapping:



Tab1 class:



Tab1 mapping:



The "ColumnNameFromTab1ReferencingTab2" column should not be auto-incremented.

I hope this helps. Good luck!

Hi,

thank you for the answer. I think you did not understand my question. the ext_srl_no is an auto incremented field in tab2 and not in tab1 and it is inserted in tab1.

Anyway i solved the problem. i had to give the generator class as "increment" for both the tables' mapping file.

thanks and regards
prasram83

Hi,

thank you tomaandtoma for the answer. I think you did not understand my question. the ext_srl_no is an auto incremented field in tab2 and not in tab1 and it is inserted in tab1.

Anyway i solved the problem. i had to give the generator class as "increment" for both the tables' mapping file.

thanks and regards
prasram83