Hibernate Postgresql boolean problems

Question

I have object with boolean field like

@Entity

@Table(name = "USERS")
public class User {

    @Id
    @GeneratedValue
    @Column(name = "ID")
    private Integer id;

    @Column(name = "ACTIVE")
    private Boolean active = true;
}

AND query for creating

CREATE TABLE IF NOT EXISTS USERS(
   ID  SERIAL PRIMARY KEY,
   ACTIVE SMALLINT ,
   LOGIN  CHAR(255) NOT NULL,
   NAME   CHAR(255) NOT NULL,
   PASSWORD CHAR(255) NOT NULL,
   ROLE INTEGER NOT NULL REFERENCES ROLE(ID)
);

When i try to take a user object i have next exception ERROR: operator does not exist: smallint = boolean

Why do you use smallint if you want a boolean?

user330315
– user330315

2016-04-01 13:38:38 +00:00
Commented Apr 1, 2016 at 13:38 — user330315
– user330315, Commented Apr 1, 2016 at 13:38

buddemat · Accepted Answer · 2021-02-24 11:07:44Z

6

try adding :

@Type(type = "org.hibernate.type.NumericBooleanType")

edited Feb 24, 2021 at 11:07

buddemat

5,33016 gold badges37 silver badges61 bronze badges

answered Feb 24, 2021 at 10:24

Rastislav S

711 silver badge3 bronze badges

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

Comments

Kayaman · Accepted Answer · 2016-04-01 12:56:10Z

5

In PostgreSQL, SMALLINT maps to Short and BOOLEAN maps to Boolean (hence the name).

You get to decide whether to change the class or the table.

answered Apr 1, 2016 at 12:56

Kayaman

73.8k6 gold badges91 silver badges128 bronze badges

Collectives™ on Stack Overflow

Hibernate Postgresql boolean problems

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related