enum problem | Java Community | Help. Code. Learn. | Page 1

wet grove Aug 28, 2023, 9:00 PM

#

anyone knows what can be causing problems with enums? i'm attaching the error, my model and how i build my db

granite egretBOT Aug 28, 2023, 9:00 PM

#

⌛ This post has been reserved for your question.

Hey @wet grove! Please use /close or the Close Post button above when you're finished. Please remember to follow the help guidelines. This post will be automatically closed after 300 minutes of inactivity.

TIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here.

calm patio Aug 28, 2023, 9:10 PM

#

Why role user_role not null?

wet grove Aug 28, 2023, 9:11 PM

#

because every user has to have a role - doesn't matter in this context

calm patio Aug 28, 2023, 9:11 PM

#

oh you're using enums in swl as well

#

How are you accessing the DB?

wet grove Aug 28, 2023, 9:11 PM

#

yessir : ]

calm patio Aug 28, 2023, 9:11 PM

#

JDBC? JPA?

wet grove Aug 28, 2023, 9:11 PM

#

straight jdbc, not a single jpa dependency added

#

everything through docker compose

calm patio Aug 28, 2023, 9:12 PM

#

Is this Spring JDBC?

wet grove Aug 28, 2023, 9:12 PM

#

exactly, i will paste you my dependecies but yes

#

calm patio Aug 28, 2023, 9:13 PM

#

https://stackoverflow.com/questions/53190112/mapping-java-enum-in-postgresql-with-spring-data-jdbc

Stack Overflow

Mapping Java Enum in Postgresql with Spring Data JDBC

I want to be able to map a enum declared in java to an enum created in postgres. For example having the following:

CREATE TYPE EYE_COLOR AS ENUM ('BROWN', 'BLUE', 'GREEN');
CREATE TABLE PERSON (
...

#

Try not using enums in your DB/SQL code

#

Spring JDBC doesn't like this I think

wet grove Aug 28, 2023, 9:14 PM

#

exactly, i have seen this post but i was still wondering if this is the only way

#

okay, good to know for sure : ]

calm patio Aug 28, 2023, 9:14 PM

#

or maybe try stringtype=unspecified,as the other answer suggests

wet grove Aug 28, 2023, 9:16 PM

#

it worked for now, but i will need to check if this doesn't affect other things globally - strange stuff : ]

#

thanks for picking this up for me, i am kinda brain damaged when i think about this

granite egretBOT Aug 28, 2023, 9:17 PM

#

wet grove thanks for picking this up for me, i am kinda brain damaged when i think about t...

If you are finished with your post, please close it.
If you are not, please ignore this message.
Note that you will not be able to send further messages here after this post have been closed but you will be able to create new posts.

#enum problem