Mapping Java boolean to Oracle Number column with JPA and Hibernate

Question

I have a property created like this in my model:

    public class Client {
        private Boolean active;
}

My RDBMS is Oracle and the active column is of type NUMBER(1,0).

How can I use the Restrictions API to achieve the following functionality?

criteria.add(Restrictions.eq("active"),object.isActive());

Vlad Mihalcea · Accepted Answer · 2017-12-18 09:09:18Z

52

Hibernate maps the Boolean Java type to Oracle NUMBER(1,0) automatically.

So, you can use a Boolean value in your entity mappings, JPQL or Criteria queries and the generated SQL will use the database NUMBER(1,0) format instead.

edited Dec 18, 2017 at 9:09

answered Mar 4, 2015 at 22:08

Vlad Mihalcea

156k85 gold badges598 silver badges984 bronze badges

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

1 Comment

Tobi Tiggers Over a year ago

just for those who are wondering, number(1) is mapped to true and number(0) to false

idmitriev · Accepted Answer · 2016-09-27 21:36:04Z

1

I don't recommend to use Boolean, you should use boolean instead to prevent NPE, cause boolean value just has two available values - true or false. What does it mean null for boolean?? It's a rare case when you need wrapper type Boolean. Oracle - number(1) default 0 not null.

answered Sep 27, 2016 at 21:36

idmitriev

5,1444 gold badges30 silver badges48 bronze badges

5 Comments

Kaypro II Over a year ago

A null Boolean can mean unknown or unspecified. Not to say you always need that distinction.

idmitriev Over a year ago

in this case you should use Enum, which is suitable for this. Boolean means true or false, nothing more. If you need to have third state - use enum.

Gary Kephart Over a year ago

Sorry, but "boolean" means true or false, nothing more. "Boolean" means true, false, or unspecified. Just like the difference between "long" and "Long"

idmitriev Over a year ago

how unspecified should be treated for boolean type? If there are more than 3 values of some kind of something it's definitely a sign that it should be an enum.

riskop Over a year ago

If the column is nullable, then use Boolean. Boolean can hold the third possibility, "unspecified". If the column is not nullable, then use boolean. Nullable column is not a reason to use Enum.

Collectives™ on Stack Overflow

Mapping Java boolean to Oracle Number column with JPA and Hibernate

2 Answers 2

1 Comment

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related