Question
· Sep 8, 2023

Using an enum in the entity class not creating the table via Quarkus

This question originally appeared in the comments of the post: Using the new InterSystems IRIS Hibernate 6 Dialect for a Springboot Project
 

Hello @Yuri Marx 
greetings for the day!

I am unable to fix this issue (using an enum in the entity class; it's not creating the table). I have using your dialect foder, but I am facing this issue. In I was searching on the website all of them are using Quarkus versions below 3, and the InterSystems jar version is 3.3.0. No one can use Quarkus version 3, and no one has published a suitable dialect for Quarkus 3. Could you please provide a solution or a dialect folder to help me solve this issue?

The important note it was trying to create the table, but the query is SQL COMMENT error. I have added below in the generated query

create table action_reason (
id integer identity,
purpose VARCHAR(255) null check (purpose in ('DROP_OUT','CANCEL','RETURN_TO_QUEUE','REACTIVATE')),
reason varchar(255) null,
primary key (id)
)

Note: I am annotated with my above enum column @Enumerted(EnumType.STRING). Only check is performed in query.

Actully this is am I expected.
create table action_reason (
id integer identity,
purpose VARCHAR(255) null,
reason varchar(255) null,
primary key (id)
)

can you please anyone assist me to resolve this issue?

Thank you!

Discussion (4)1
Log in or sign up to continue