org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: String index out of range: 25978
### The error may exist in file [D:\WorkCode\mg-yard\model-yard\build\resources\main\com\cisdi\model\yard\dao\TagCustomMapper.xml]
### The error may involve com.cisdi.model.yard.dao.TagCustomDao.maxAnaAvgTagTime
### The error occurred while executing a query
### Cause: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: String index out of range: 25978
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy120.selectOne(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:83)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy158.maxAnaAvgTagTime(Unknown Source)
at com.cisdi.model.yard.service.impl.TagServiceImpl.maxAnaAvgTagTime(TagServiceImpl.java:279)
at com.cisdi.model.yard.service.impl.TagServiceImpl$$FastClassBySpringCGLIB$$9e58438a.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
at com.cisdi.model.yard.service.impl.TagServiceImpl$$EnhancerBySpringCGLIB$$f68216a8.maxAnaAvgTagTime(<generated>)
at com.cisdi.model.yard.controller.TaskLeanProductionCalController.<init>(TaskLeanProductionCalController.java:71)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:172)
-----------------------------------下面是sql--------------------------------------------
<select id="maxAnaAvgTagTime" resultType="java.util.Date">
select TRUNC(max(clock), 'hh24')
from tag_value
where id BETWEEN 7000 and 7099
</select>
Date maxAnaAvgTagTime();
專案一執行這個查詢就報錯，同事電腦上是可以的就我不行，有沒得大佬遇到過的呀！！！！十萬火急
uj5u.com熱心網友回復：
好像是連接池出錯了，直連查一下是否還有例外uj5u.com熱心網友回復：
直連沒有問題 就這里有問題， 我回傳date就有問題 回傳null就沒問題。。轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/9685.html
標籤：Web 開發
上一篇：Nginx配置了默認輪詢方式,但是輪詢失效,重繪后只能訪問一個tomcat服務器
下一篇：當再次查詢資料的時候，如何判斷是從redis中讀取資料還是從資料庫讀取資料， 因為先要經過判斷redis中是否有值這步操作，如果有值，那就讀取。那么如何 獲取得