JCH
Java Community | Help. Code. Learn.•3mo ago
check

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

I have been working on creating a chat_module application with Reactive programming - spring boot 3.4.1, postgres-r2dbc, and mongo reactive. While previously I was using Strings for some columns in the postgres, the application was working fine but after i switched to enums it is giving me error. I tried a lot of things now since last two weeks. Configuring the EnumCodec - custom configs like - but it seems I have hit the rock bottom now. 
@Configuration
public class R2dbcConfig {

    @Bean
    public R2dbcCustomConversions r2dbcCustomConversions() {
        List<Object> converters = new ArrayList<>();
        converters.add(new ChatRoomTypeReadingConverter());
        converters.add(new ChatRoomTypeWritingConverter());
        // Pass PostgresDialect.INSTANCE as the first parameter
        return R2dbcCustomConversions.of(PostgresDialect.INSTANCE, converters);
    }

    @Bean
    public CodecRegistrar enumCodecRegistrar() {
        return EnumCodec.builder()
                .withEnum("chat_room_type", ChatRoomType.class)
                .withEnum("chat_room_visibility", ChatRoomVisibility.class)
                .withEnum("chat_room_member_role", ChatRoomMemberRole.class)
                .withEnum("notification_preference", NotificationPreference.class)
                .withEnum("gender", Gender.class)
                .build();
    }
}
@Configuration
public class R2dbcConfig {

    @Bean
    public R2dbcCustomConversions r2dbcCustomConversions() {
        List<Object> converters = new ArrayList<>();
        converters.add(new ChatRoomTypeReadingConverter());
        converters.add(new ChatRoomTypeWritingConverter());
        // Pass PostgresDialect.INSTANCE as the first parameter
        return R2dbcCustomConversions.of(PostgresDialect.INSTANCE, converters);
    }

    @Bean
    public CodecRegistrar enumCodecRegistrar() {
        return EnumCodec.builder()
                .withEnum("chat_room_type", ChatRoomType.class)
                .withEnum("chat_room_visibility", ChatRoomVisibility.class)
                .withEnum("chat_room_member_role", ChatRoomMemberRole.class)
                .withEnum("notification_preference", NotificationPreference.class)
                .withEnum("gender", Gender.class)
                .build();
    }
}

message.txt

1 Reply
JavaBot
JavaBot•3mo ago
⌛ This post has been reserved for your question.
Hey @check! Please use /close or the Close Post button above when your problem is solved. Please remember to follow the help guidelines. This post will be automatically marked as dormant 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. 💤 Post marked as dormant
This post has been inactive for over 300 minutes, thus, it has been archived. If your question was not answered yet, feel free to re-open this post or create a new one. In case your post is not getting any attention, you can try to use /help ping. Warning: abusing this will result in moderative actions taken against you.

Did you find this page helpful?