达梦数据库线上报错,本地执行sql是好的,将sql拷出来在线上达梦终端执行也是好的,但是程序就是报错,百度无结果,跪求大佬。
### Error querying database. Cause: dm.jdbc.driver.DMException: session request timeout
### The error may exist in URL [jar:file:/xxxx/xxxx/StDataReportMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select ADCD as areaId, count(STCD) as reportNum from ( select concat(substr(b.ADDVCD,0,6),'000000000') as ADCD, a.STCD from (
select STCD from ST_RIVER_R where 1=1 and TM >= ? and ? > TM group by STCD
) a left join ST_STBPRP_B b on a.STCD = b.STCD ) group by ADCD### Cause: dm.jdbc.driver.DMException: session request timeout
; session request timeout; nested exception is dm.jdbc.driver.DMException: session request timeout