Mapping Java boolean to Oracle Number column with JPA and Hibernate

java database oracle hibernate hibernate-criteria
Rafael Roque picture Rafael Roque · Mar 4, 2015 · Viewed 22.5k times · Source

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());

Answer

Vlad Mihalcea picture Vlad Mihalcea · Mar 4, 2015

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.

Related questions

Java Oracle localhost connection error (ORA-12505)

I am trying to currently connect to a database on my current computer. import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class Main { public static void main(String[] argv) throws Exception { Connection connection = null; try { // …

Read More
How to connect in java as SYS to Oracle?

I receive this error: java.sql.SQLException: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER How to fix? (I need to be SYS). Thanks.

Read More
WFMLRSVCApp.ear file not found

I am trying to install Oracle 11g in my laptop. Im downloading the setup files from here: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html I have downloaded win64_11gR2_database_1of2.zip and win64_11gR2_database_2…

Read More