why many-to-one only performance insert but not update ?

kiwionly · **Joined:** Mon Dec 17, 2007 11:08 pm **Posts:** 47

hi, I had a class like this

Code:

public class User {
 private Address address; 
  //setter and getter..
}

<many-to-one name="address" 
           column="address_id" 
           unique="true"
           not-null="false" cascade="all"/>

my question is when i call session.save(user), it perform SQL insert to a new row into address table, but not SQL update ? why ?

how can i make it to perform SQL update the row instead of perform SQL insert ?

any idea ?

kiwi

SIau_Tie · **Posted:** Mon Dec 15, 2008 3:47 am

kiwionly wrote:

hi, I had a class like this

Code:

public class User {
 private Address address; 
  //setter and getter..
}

<many-to-one name="address" 
           column="address_id" 
           unique="true"
           not-null="false" cascade="all"/>

my question is when i call session.save(user), it perform SQL insert to a new row into address table, but not SQL update ? why ?

how can i make it to perform SQL update the row instead of perform SQL insert ?

any idea ?

kiwi

Please post your code, how you save your user. You should retrieve the address exists in database, and set it to user instead of creating the new address.

Code:

Address addr = ... // load from the database
User user = new User();
...
user.setAddress(addr);
session.save(user);

kiwionly · **Joined:** Mon Dec 17, 2007 11:08 pm **Posts:** 47

hi, my code is something like this..

Code:

Address add = user.getAddress();

add.setPostcode("some value");

user.setAddress(add);
session.save(user);

the problem is it create a new one instead of update the current one.

any idea ?

kiwi

SIau_Tie · **Posted:** Mon Dec 15, 2008 4:35 am

kiwionly wrote:

hi, my code is something like this..

Code:

Address add = user.getAddress();

add.setPostcode("some value");

user.setAddress(add);
session.save(user);

the problem is it create a new one instead of update the current one.

any idea ?

kiwi

Why do you not use :

Code:

Address add = user.getAddress();

add.setPostcode("some value");

session.update(add);

kiwionly · **Joined:** Mon Dec 17, 2007 11:08 pm **Posts:** 47

hi, i had try that, but it just not work!

i doubt is related to the relationship i define in my hbm.

Code:

<many-to-one name="address"
           column="address_id"
           unique="true"
           not-null="false" cascade="all"/>

SIau_Tie · **Posted:** Mon Dec 15, 2008 5:01 am

kiwionly wrote:

hi, i had try that, but it just not work!

i doubt is related to the relationship i define in my hbm.

Code:

<many-to-one name="address"
           column="address_id"
           unique="true"
           not-null="false" cascade="all"/>

I have tried your code. No problem with your configuration

kiwionly · **Joined:** Mon Dec 17, 2007 11:08 pm **Posts:** 47

hi, are u mean it performance an update instead of insert ?

I use it with spring MVC. in fact all my code work accept this one, i still need to debug on this.

SIau_Tie · **Posted:** Mon Dec 15, 2008 5:30 am

kiwionly wrote:

hi, are u mean it performance an update instead of insert ?

I use it with spring MVC. in fact all my code work accept this one, i still need to debug on this.

yes, it performance update

kiwionly · **Joined:** Mon Dec 17, 2007 11:08 pm **Posts:** 47

hi, i had find out the problem.

u r right.. actually I not reuse the detach object. (i had solve it by reattach the object retrieve from database and put into spring mvc @controller 's @session attributes).

since the new object with session.merge(user) will insert a new object into database (because the new object id is null).

thx.

kiwi