Jpa Enum error with Smallint type in postgres

Question

I want to put enum in my entity. But I have an error with validation which JPA wonts smallint set as enum. How I can solve this issue.

"Schema-validation: wrong column type encountered in column [status] in table [order]; found [int2 (Types#SMALLINT)], but expecting [int4 (Types#INTEGER)]"[enter image description here]

Did you generate the table using hibernate DDL or SQL query? Your data type for the column is set to SMALLINT but here you will INT. — ImtiazeA
– ImtiazeA, Commented Oct 11, 2020 at 13:59
Is this a requirement to store the enum's ordinal values in a column of type SMALLINT or you don't know how to change the data type for that column? — ImtiazeA
– ImtiazeA, Commented Oct 11, 2020 at 14:05
I know how to change column to int, but I have no permission to do it. — YWILLS
– YWILLS, Commented Oct 11, 2020 at 14:06

Shawrup · Accepted Answer · 2020-10-11 15:33:22Z

12

Add columnDefinition="int2" at OrderStatus in your entity.

    @Column(name = "status", columnDefinition = "int2")
    OrderStatus status;

Tested on spring boot 2.2.10

answered Oct 11, 2020 at 15:33

Shawrup

2,8142 gold badges15 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

Jpa Enum error with Smallint type in postgres

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related