Hi,

Say for eg.
I have an enum user_type defined in database
I have table user and column usertype which is of type user_type. i.e my column type is user defined which is enum.

how to define and use above column in jpa entity via setter and getters?

Also, I have define same enum in java and using like this
@Enumerated(EnumType.STRING)
@Column(name="usertype")
private EnumUserTypes userType;

I am getting below error
org.postgresql.util.PSQLException: ERROR: column "usertype" is of type user_type but expression is of type character varying

how to resolve this?

Thanks.

You have two options:

1. You use a custom Hibernate UserType, like this one while you retain the DB column as enum_type.

2. You create a separate table: user_type which has an id column (PK) and an enum_value column which is of type enum_type. The id can also be the String representation if that's what you want.
This way, your mapping mapping will work:



The "usertype" column will have to be a FK to the id in the user_type table. The only drawback is that you have to manually maintain the user_type table, as well as to create the FK because Hibernate cannot do that for you. However, this should be the default schema management strategy anyway, taking that you also use FlywayDb or Liquibase to automate schema migrations.

Hi,

Thanks, solution -1 works for me.