为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:64 V8 DmJdbcDriver18(8.1.1.193)
【操作系统】:win11,spring-boot2.2.6 mybatis-spring-boot-starter2.1.4
【CPU】:
【问题描述】*:管理台查询正常,mybatis查询后,java收不到返回值,去除ORDER BY MsgId DESC可行
<select id="getMaxExNo" resultType="int">
SELECT
COALESCE(CAST(SUBSTR(MsgId, 12) AS INT), 0)
FROM
delivery_user_info
WHERE
ReceiveMobile = '111111'
ORDER BY
MsgId DESC
LIMIT 1;
</select>
Integer getMaxExNo(String memberMobile);
Integer exNoNum = smsTemplateMapper.getMaxExNo(memberInfo.getMemberMobile());
采用下面也不行
Integer exNoNum = smsTemplateMapper.getMaxExNo(memberInfo.getMemberMobile());
//获取不到
exNoNum = jdbcTemplate.queryForObject(
"SELECT COALESCE(CAST(SUBSTR(MsgId, 12) AS INT), 0) FROM SFJEA.delivery_user_info \n" +
"WHERE ReceiveMobile = '123456' ORDER BY MsgId DESC LIMIT 1;",Integer.class);
//获取到了
exNoNum = jdbcTemplate.queryForObject(
"SELECT COALESCE(CAST(SUBSTR(MsgId, 12) AS INT), 0) FROM SFJEA.delivery_user_info \n" +
"WHERE ReceiveMobile = '123456' LIMIT 1;",Integer.class);
1.你瞅瞅用管理工具执行返回的结果集是int类型吗
2.驱动包是否和数据库版本一致,从数据库的drivers下面获取的