解决com.mysql.cj.exceptions.DataConversionException: Cannot determine value type from string

蒾酒

已于 2025-05-29 12:00:12 修改

阅读量1.7k

点赞数 27

CC 4.0 BY-SA版权

分类专栏：踩坑日记文章标签： mybatis

于 2024-06-17 23:18:37 首次发布

本文链接：https://blog.csdn.net/qq_62262918/article/details/139755631

问题场景

这是一个查询接口

 @Override
    public List<AiRoleVO> getAiRoleList() {
        return new LambdaQueryChainWrapper<>(this.getBaseMapper())
                .select(AiRole::getId,AiRole::getName, AiRole::getPrompt,AiRole::getUseCount,
                        AiRole::getIsShare,AiRole::getAvatar)
                .eq(AiRole::getUserId, UserHolder.getInfoByToken().getId())
                .list()
                .stream()
                .map(this::aiRoleToVO)
                .toList();
    }

接着报错信息如下:具体内容是有个字段不知道类型，解析异常。

com.mysql.cj.exceptions.DataConversionException: Cannot determine value type from string 'https://chat.7jm.cn/'
	at com.mysql.cj.result.BooleanValueFactory.createFromBytes(BooleanValueFactory.java:116) ~[mysql-connector-j-8.2.0.jar:8.2.0]
	at com.mysql.cj.result.BooleanValueFactory.createFromBytes(BooleanValueFactory.java:47) ~[mysql-connector-j-8.2.0.ja