SQL查询, 响应体临时字段报: Unknown column ‘data_json_map‘ in ‘field list‘

    @Overridepublic AjaxResult list(AgentPageReqVO pageReqVO, Integer pageNo, Integer pageSize) {// 1. 查询数据库获取代理列表List<AgentDO> list = agentMapper.selectPage(pageReqVO).getList();// 如果结果为空，直接返回空分页结果if (CollectionUtils.isEmpty(list)) {return PaginationUtil.manualPaging(list, pageNo, pageSize);}// 创建JSON解析器ObjectMapper mapper = new ObjectMapper();// 2. 处理列表中的每个AgentDO对象list.stream().map(agent -> {// 检查dataJson字段是否有值if (!StringUtils.isEmpty(agent.getDataJson())) {try {// 3. 将JSON字符串解析为Map对象Map<String, Object> objectMap = mapper.readValue(agent.getDataJson(),new TypeReference<Map<String, Object>>() {});// 4. 将解析后的Map设置到dataJsonMap属性agent.setDataJsonMap(objectMap);} catch (Exception e) {// 解析失败时设置为nullagent.setDataJsonMap(null);}}return null; // 这里返回null是因为map操作需要返回值，但实际不需要}).collect(Collectors.toList()); // 触发流操作执行// 5. 手动分页并返回结果return PaginationUtil.manualPaging(list, pageNo, pageSize);}

    default PageResult<AgentDO> selectPage(AgentPageReqVO reqVO) {return selectPage(reqVO, new LambdaQueryWrapperX<AgentDO>().eqIfPresent(AgentDO::getUserId, reqVO.getUserId()).eqIfPresent(AgentDO::getUserName, reqVO.getUserName()).eqIfPresent(AgentDO::getClzId, reqVO.getClzId()).likeIfPresent(AgentDO::getClzName, reqVO.getClzName()).eqIfPresent(AgentDO::getTitle, reqVO.getTitle()).eqIfPresent(AgentDO::getIntroduce, reqVO.getIntroduce()).eqIfPresent(AgentDO::getAvatar, reqVO.getAvatar()).eqIfPresent(AgentDO::getVisibleTenantIds, reqVO.getVisibleTenantIds()).eqIfPresent(AgentDO::getStatus, reqVO.getStatus()).eqIfPresent(AgentDO::getTemplateStatus, reqVO.getTemplateStatus()).eqIfPresent(AgentDO::getCreateWay, reqVO.getCreateWay()).eqIfPresent(AgentDO::getTop, reqVO.getTop()).eqIfPresent(AgentDO::getSort, reqVO.getSort()).eqIfPresent(AgentDO::getTemplateId, reqVO.getTemplateId()).eqIfPresent(AgentDO::getAppId, reqVO.getAppId()).eqIfPresent(AgentDO::getHint, reqVO.getHint()).eqIfPresent(AgentDO::getOpening, reqVO.getOpening()).eqIfPresent(AgentDO::getOpeningQuestion, reqVO.getOpeningQuestion()).eqIfPresent(AgentDO::getFollowup, reqVO.getFollowup()).eqIfPresent(AgentDO::getKnowledge, reqVO.getKnowledge()).eqIfPresent(AgentDO::getModel, reqVO.getModel()).eqIfPresent(AgentDO::getTool, reqVO.getTool()).eqIfPresent(AgentDO::getBackgroundImage, reqVO.getBackgroundImage()).eqIfPresent(AgentDO::getRoleCode, reqVO.getRoleCode()).eqIfPresent(AgentDO::getDeptId, reqVO.getDeptId()).likeIfPresent(AgentDO::getDeptName, reqVO.getDeptName()).betweenIfPresent(AgentDO::getCreateTime, reqVO.getCreateTime()).orderByDesc(AgentDO::getTop).orderByDesc(AgentDO::getSort).orderByDesc(AgentDO::getCreateTime));}

selectPage查询结果: Cause: java.sql.SQLSyntaxErrorException: Unknown column 'data_json_map' in 'field list'

问题分析与解决方案

问题原因

在 AgentDO 实体类中定义了 dataJsonMap 字段，它是一个临时字段用于存储解析后的 JSON 数据，不需要持久化到数据库。但在 SQL 查询中自动包含了这个字段，导致数据库报错 Unknown column 'data_json_map'。

解决方案

方法一：使用 @TableField(exist = false) 注解

在 AgentDO 类中，为 dataJsonMap 字段添加注解，明确表示它不是数据库字段：

@TableField(exist = false)  // 表示这不是数据库字段
private Map<String, Object> dataJsonMap;

OK

{"msg": "操作成功","code": 0,"data": {"total": 4,"list": [{"createTime": 1747803847000,"updateTime": 1747803847000,"creator": "1","updater": "1","deleted": false,"id": 12,"userId": 1,"userName": "admin","clzId": null,"clzName": null,"title": "天气预报","introduce": "我是天气预报的好帮手","avatar": null,"visibleTenantIds": "[]","status": 1,"templateStatus": 1,"createWay": null,"top": 0,"sort": 0,"templateId": "cd50493b-3222-4665-a08f-363595df4b35","appId": "f64c6f9e-b21c-4b46-abc2-64cf3cdef9b9","hint": null,"opening": null,"openingQuestion": null,"followup": null,"knowledge": null,"model": null,"tool": null,"backgroundImage": null,"roleCode": null,"deptId": 103,"deptName": "研发部门","tenantId": 1,"tenantName": "企业租户","scope": 1,"dataJsonMap": {"pre_prompt": "string","opening_statement": "string","suggested_questions": ["string"],"suggested_questions_after_answer": {"enabled": true},"dataset_configs": {"datasets": {"datasets": [{"dataset": {"enabled": true,"id": "0828c38c-05e6-4b18-b065-d1a89d1dfdd2"}}]},"reranking_enable": true,"reranking_mode": "string","reranking_model": {"reranking_model_name": "string","reranking_provider_name": "string"},"retrieval_model": "string","top_k": 0},"model": {"completion_params": {"stop": []},"mode": "string","name": "string","provider": "string"},"agent_mode": {"enabled": true,"max_iteration": 0,"prompt": "string","strategy": "string","tools": [{"enabled": true,"notAuthor": true,"provider_id": "string","provider_name": "string","provider_type": "string","tool_label": "string","tool_name": "string","tool_parameters": {"prompt": "string","timestamp": "string","traceId": "string"}}]},"background_image": "string"}}]}
}

 

一线网资源-全网一站式平台