注册

springboot查询dm7报错

叫我小李就好 2022/02/08 1363 2 已解决

【DM版本】:DM7 V7.6.1.108
【操作系统】:centos7
【问题描述】*:

  1. 项目原先使用springboot+jpq+mysql,现正在迁移至dm7。首先使用dts将项目原先的mysql表整体迁移到了dm7中。
  2. 随后修改了datasource配置,使用springboot可成功连接dm7数据库。
  3. 问题一:在查询某些表时,报错Sort or calculate in blob or clob(text),此时hibernate打印的sql语句为:

org.springframework.dao.DataIntegrityViolationException: could not prepare statement; SQL [select distinct platformab0_.id as id1_0_, platformab0_.code as code2_0_, platformab0_.concurrent_num as concurre3_0_, platformab0_.created_by as created_4_0_, platformab0_.created_time as created_5_0_, platformab0_.demo_address as demo_add6_0_, platformab0_.division_ratio as division7_0_, platformab0_.dummy_concurrent_num as dummy_co8_0_, platformab0_.gateway_id as gateway_9_0_, platformab0_.image as image10_0_, platformab0_.name as name11_0_, platformab0_.remark as remark12_0_, platformab0_.status as status13_0_, platformab0_.type_id as type_id14_0_, platformab0_.updated_by as updated15_0_, platformab0_.updated_time as updated16_0_, platformab0_.used_concurrent_num as used_co17_0_ from platform_ability platformab0_ where 1=1 order by platformab0_.created_time desc limit ?]

  1. 问题二:在查询另一个表时,报错Order by item beyond distinct query column,此时hibernate打印的sql语句为:

org.springframework.dao.DataIntegrityViolationException: could not prepare statement; SQL [select distinct platformap0_.app_id as col_0_0_ from platform_app_order platformap0_ where (platformap0_.status in (0)) and (platformap0_.status<>-3 or platformap0_.create_by<>?) order by platformap0_.create_time desc]

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