problem with update

seven-12 · **Joined:** Thu Jun 22, 2006 8:56 am **Posts:** 22

Hello,

i dont know why my update does not work:

Code:

Integer nr = 5;
Query query = session.createQuery("from Source as source where source.nr = '"+ nr + "' " );
Source found_final =(Source)query.uniqueResult(); 
if (found_final == null){
found = new Source(source);
session.save(found);
}
                  
else{   
session.saveOrUpdate(found_final);
}

Can anyoune help?

Thank you,
seven-12

radu · **Joined:** Wed Jun 15, 2005 4:17 am **Posts:** 156

Two things:

1. Learn how to post a proper request for help.
2. Are you aware that this is the NHibernate forum which deals with the C# port of Hibernate and NOT the main Hibernate forum?

Cheers,
Radu

gert · **Joined:** Thu Jan 19, 2006 4:29 pm **Posts:** 348

seven-12 wrote:

i dont know why my update does not work:

Code:

Integer nr = 5;
Query query = session.createQuery("from Source as source where source.nr = '"+ nr + "' " );
Source found_final =(Source)query.uniqueResult(); 
if (found_final == null){
found = new Source(source);
session.save(found);
}
                  
else{   
session.saveOrUpdate(found_final);
}

Can anyoune help?

I have never worked with Hibernate (for Java), but in NHibernate Session.SaveOrUpdate only associates the detached persistent object with session - and is needed only if You loaded object trogh another session and then disconnected it. In order to save changes to database, call session.Flush();

Gert