How do you store a Java Boolean type variable in a PostgreSQL table with corresponding column data type defined as "bit"?

Question

Now, the data type of the variable in my Java class is "boolean". I want to store it in a PostgreSQL table. The column in which I want to store my data has data type defined as "bit". But when I try to save the object which has this boolean variable, I get the error:

ERROR: column "isdeleted" is of type bit but expression is of type boolean

I'm using Hibernate to store the data. My code snippet for defining and mapping my variable:

@Column(name = "isDeleted")
private boolean isDeleted;

How do I save my object? Thank you!

postgresql-archive.org/…

StanislavL
– StanislavL

2017-07-28 14:03:58 +00:00
Commented Jul 28, 2017 at 14:03 — StanislavL
– StanislavL, Commented Jul 28, 2017 at 14:03

Boris Schegolev · Accepted Answer · 2017-07-28 14:21:52Z

2

Please use a proper boolean type in Postgres. Although it is possible to store boolean values in bit streams, it makes later usage complicated.

With the usual boolean you can do this:

SELECT * FROM table WHERE isdeleted;

Whereas with bit type you have to do bitwise operations:

SELECT * FROM table WHERE isdeleted > B'0'

answered Jul 28, 2017 at 14:21

Boris Schegolev

3,7115 gold badges23 silver badges35 bronze badges

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

1 Comment

K Sharma Over a year ago

Thanks for responding! I know that and I want to, but this is the specification given to me. I can't make any changes to the table schema.

Boris Schegolev · Accepted Answer · 2017-07-28 15:22:57Z

2

Try using BOOLEAN data type, define your @Column annotation like that:

@Column(name = "isDeleted", columnDefinition = "boolean default true", nullable = false)
private boolean isDeleted = true;

Also, I think in NHibernate the column type is TrueFalse, which expects 'T' or 'F'. You would need to change the column type to Boolean. Try this link

edited Jul 28, 2017 at 15:22

Boris Schegolev

3,7115 gold badges23 silver badges35 bronze badges

answered Jul 28, 2017 at 14:12

Chetan chadha

5681 gold badge4 silver badges19 bronze badges

1 Comment

K Sharma Over a year ago

Sorry, can't make changes to the specifications!

mounika pasumarti · Accepted Answer · 2020-04-06 07:15:54Z

0

Try adding PostgreSQL Dialect in your code "org.hibernate.dialect.PostgreSQLDialect"

answered Apr 6, 2020 at 7:15

mounika pasumarti

1

Comments

dev_2014 · Accepted Answer · 2022-07-15 10:31:54Z

0

Add below annotation above the field name, if using hibernate

@Type(type = "org.hibernate.type.NumericBooleanType")
@Column(name = "isDeleted")
private boolean isDeleted;

answered Jul 15, 2022 at 10:31

dev_2014

3814 silver badges6 bronze badges

Collectives™ on Stack Overflow

How do you store a Java Boolean type variable in a PostgreSQL table with corresponding column data type defined as "bit"?

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related