How to set a field value to null?

gumreal · **Joined:** Wed Oct 20, 2004 8:57 am **Posts:** 5

I am using JBoss3.2.6 with Hibernate 2.1.6.
Everything is OK,But when I want to set a field in my table to null, it fails to do so.
My code goes like:

Code:

Session session =HibernateContext.getSession("java:/hibernate/MySessionFactory");
   List list = null;
   try {
      list = session.find("from EseExperimentUser as eeu where eeu.UserId = ?",userId,Hibernate.INTEGER);
                Iterator iter = list.iterator();
      while(iter.hasNext()){
         MyObject = (MyObject)iter.next();
         MyObject.setFiled1(null); //Filed1 is a filed that allows null value
         session.update(MyObject);
               
      }
   } catch (HibernateException e) {
      e.printStackTrace();
   } 

After running this program, there is no exception; However the field1 in DB is remains no change. Why?

Thanks for your help!

anthony · **Posted:** Mon Nov 01, 2004 6:15 am

maybe you missed begintransaction & commit

gumreal · **Joined:** Wed Oct 20, 2004 8:57 am **Posts:** 5

Thanks for your help.
But that is not the reason.
If I set the value to an integer, it works well.
So why null-value not?

curio · **Joined:** Tue Oct 05, 2004 9:45 am **Posts:** 263

you have "beginTransaction" and "commit" in your code, or not?
If not, trust anthony, and try it with "bT" and "commit" ... i would say without that, it's "luck" if you will see changes in your db ... ;)

gtx
curio

gumreal · **Joined:** Wed Oct 20, 2004 8:57 am **Posts:** 5

Thanks!
I added "beginTransaction" and "commit" in my code, it worked well;-)