DEV Community

Mahesh
Mahesh

Posted on

Spring Boot r2dbc enum error - org.springframework.r2dbc.BadSqlGrammarException

Facing some issue with postgres enum r2dbc - below gist I have added everything i could
https://gist.github.com/Together-Java-Bot/a05418d75e2f7cca670c9492d5942b1c

Really appreciate the help.

Top comments (1)

Collapse
 
shei254 profile image
Eric Chege

this happens because postgres status is not considered as a varchar but of an actual enum code, you should use the PostgresqlConnectionConfiguration codecRegistrar to handle this