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!
Comments
Use version 1.1.0 for the dialect on maven dependency
Fixed, please, change your dependency for 1.1.1:
<dependency>
<groupId>io.github.yurimarx</groupId>
<artifactId>hibernateirisdialect</artifactId>
<version>1.1.1</version>
</dependency>Fixed change your dependency for version 1.1.1:
<dependency>
<groupId>io.github.yurimarx</groupId>
<artifactId>hibernateirisdialect</artifactId>
<version>1.1.1</version>
</dependency>Thanks yurimarx Marx,
Now, I was able to successfully connect to the database also create a table using Enum data type. Thank you very much for your help in this crucial time.