Hibernate setting boolean value

Question

I am new to JSF and Hibernate so I am sorry if this question is simple for here.

I am using MySQL database and my users table has a boolean column. Hibernate mapped the value in hbm.xml as

<property name="verified" type="boolean">
    <column name="verified" not-null="true"/>
</property>

When I run the query using the HQL Query Window in NetBeans

update Users set verified = false where email = '[email protected]'

it perfectly sets the boolean value true and false. But in my helper class I have this method to set the value

public void setIsVerified(Users user, Boolean isVerified){
    Transaction tx = null;

    try{
        tx = session.beginTransaction();
        Query q = session.createQuery("update Users set verified = :verified where email = :email");
        q.setParameter("verified", isVerified);
        q.setParameter("email", user.getEmail());
        q.executeUpdate();
    }catch(RuntimeException e){
        if(tx != null)
            tx.rollback();
        throw e;
    }
}

but it doesn't set the value. I tried setting the value manually as q.setParameter("verified", true); it also didn't work. (email is unique field, I also tried using ID field which is primary key.)

Interesting part is when I run this method using JUnit it doesn't produce any error message or warning. It seems it works perfectly but doesn't change the value in the database.

Any tip will be appreciated since I don't get any messages I don't know where to search for. I don't know what happens in the background. Thanks in advance..

Robert Moskal · Accepted Answer · 2016-02-20 22:24:43Z

1

Since you explicitly call beginTransaction at the beginning of your method, you must call tx.commit() before you finish your unit of work.

One of the pluses of using hibernate is that you can do your transaction management declaratively http://docs.spring.io/spring/docs/current/spring-framework-reference/html/transaction.html.

edited Feb 20, 2016 at 22:24

answered Feb 20, 2016 at 22:12

Robert Moskal

22.7k8 gold badges69 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Faruk Akın Over a year ago

Sorry I have mistyped it. Both is Users

Faruk Akın Over a year ago

Thank you very very much. You won't believe but all of my helper methods I have tx.commit(). Just laughing at myself. It took me two days just that line... It worked now.

Faruk Akın Over a year ago

It's my first time using Hibernate. Thanks for the document. I will be reading.

Collectives™ on Stack Overflow

Hibernate setting boolean value

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related