Hi,
The probelm Im facing is as under:

I have two tables A and B where B is parent table and the relation

between A and B is many-to-one.
Also the foreign key is nullable.
Now retrieving records is not a problem. But when I try to update the

retrieved row(of table A) where is the foreign key is null, it throws me

TransientObjectException:

ALso the cascading property has been set as "none". Why does it throw

that error even Im not trying to update the null foreign key . Im just

updating the value of some other column which doesnt have any

association.
Kindly Help:!!

Hi sriguru,

I think it code problem. First know when TransientObjectException comes. It comes when any mapped class has object associated with any parent object. Where parent object is persistent and associated object is not persistent .At session.flush it would give you TransientObjectException .So Post your all mapping and class and also code within transaction scope.

Hi,
The code for my program is:
mapping for A:
<hibernate-mapping package="parms">
<class name="A" table="A" lazy="true" batch-size="20" select-before-update='true' >
<id name="id" column="ID">
<generator class="increment"/>
</id>
<many-to-one name="b" column="Ba_ID" class="B" not-found="ignore"
cascade="lock" lazy="false" not-null="false" unique="false"/>
<property name="place" column="PLACE"/>

</class>

mapping for B:

<class name="B" table="B" lazy="true" batch-size="10" select-before-update="true">
<cache usage="read-write"/>
<id name="id" column="B_ID" >
<generator class="assigned"/>
</id>
<property name="programId" column="GROUP_ID" unique="true"/>
</class>

Now the only difference from a normal condition is that not all the rows in table A have non-null value for the column Ba_ID. That means some of rows have null values for column Ba_ID.
Now retrieval of these rows which have null values for column Ba_ID works fine. And it retrieves a null relationship between the tables for these rows. Now when I try to update column PLACE. It tries to update column Ba_ID also and there it throws me TransientOBjectException.
But I dont want to change anything for that column.

Hi,
The code for my program is:
mapping for A:
<hibernate-mapping package="parms">
<class name="A" table="A" lazy="true" batch-size="20" select-before-update='true' >
<id name="id" column="ID">
<generator class="increment"/>
</id>
<many-to-one name="b" column="Ba_ID" class="B" not-found="ignore"
cascade="none" lazy="false" not-null="false" unique="false"/>
<property name="place" column="PLACE"/>

</class>

mapping for B:

<class name="B" table="B" lazy="true" batch-size="10" select-before-update="true">
<cache usage="read-write"/>
<id name="id" column="B_ID" >
<generator class="assigned"/>
</id>
<property name="programId" column="GROUP_ID" unique="true"/>
</class>

Now the only difference from a normal condition is that not all the rows in table A have non-null value for the column Ba_ID. That means some of rows have null values for column Ba_ID.
Now retrieval of these rows which have null values for column Ba_ID works fine. And it retrieves a null relationship between the tables for these rows. Now when I try to update column PLACE. It tries to update column Ba_ID also and there it throws me TransientOBjectException.
But I dont want to change anything for that column.

A a=_form.getA(id);
a.setPlace("place");
sess.saveOrUpdate(a);
tx.commit();
sess.close();

And the last SQL statement being tried to be executed is:
UPDATE A set ......(all columns )..... where ID =?


And the exception thrown is:

[ERROR] AbstractFlushingEventListener - -Could not synchronize database state with session <org.hibernate.TransientObjectException: B>
at org.hibernate.engine.ForeignKeys.getEntityIdentifierIfNotUnsaved(ForeignKeys.java:219)

Hi sriguru,

Replace hibernate3.jar with v3.2's hibernate3.jar that might help

Are you using replicated database server.

read this

http://forum.springframework.org/archiv ... 37051.html

read this

http://forum.springframework.org/archiv ... 37051.html

I dont have replicated servers. And the problem I have is way different from the link you gave.
Its just a simple unidirectional many-to-one relationship, with the primary key of one table becoming foreign key of the second. The only new thing is that this foreign key column can also have null values.
And the problem occurs when I try to update a row of this child table without updating the foreign key. Also Im already using 3.2 hibernate.