注册

select语句报错

马尔克ov 2025/06/23 150 3

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8_20250506_x86_rh7_64
【操作系统】:centos7.9
【CPU】:
【问题描述】*:
之前这套系统在arm架构下部署没有出现这个问题,怀疑是数据库有什么默认设置不同?

2025-06-17 16:16:21.838 WARN 53121 --- [io-18094-exec-2] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: -2007, SQLState: 42000
2025-06-17 16:16:21.839 ERROR 53121 --- [io-18094-exec-2] o.h.engine.jdbc.spi.SqlExceptionHelper : 第 1 行, 第 665 列[model]附近出现错误:
语法分析出错
2025-06-17 16:16:21.853 ERROR 53121 --- [io-18094-exec-2] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not prepare statement; SQL [select model0_.uid as uid1_3_, model0_.alt as alt2_3_, model0_.data_size as data_siz3_3_, model0_.data_type as data_typ4_3_, model0_.description as descript5_3_, model0_.entry as entry6_3_, model0_.evaluation as evaluati7_3_, model0_.lat as lat8_3_, model0_.lon as lon9_3_, model0_.name as name10_3_, model0_.pitch as pitch11_3_, model0_.roll as roll12_3_, model0_.scalex as scalex13_3_, model0_.scaley as scaley14_3_, model0_.scalez as scalez15_3_, model0_.sid as sid16_3_, model0_.timestamp as timesta17_3_, model0_.type as type18_3_, model0_.upload_time as upload_19_3_, model0_.weight as weight20_3_, model0_.worker as worker21_3_, model0_.yaw as yaw22_3_ from model model0_ where 1=1 order by model0_.upload_time desc limit ? ]; nested exception is org.hibernate.exception.SQLGrammarException: could not prepare statement] with root cause

在disql里面查询select * 不会报错
286b451866a690b5637fdb45f4a580b.jpg

回答 0
暂无回答
扫一扫
联系客服