# # # Error querying the database. Cause: the zaxxer. Hikari. Pool. HikariPool $PoolInitializationException: Failed to initialize the pool: String index out of range: 25978
# # # The error may exist in The 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 the pool: String index out of range: 25978
The at org. Mybatis. Spring. MyBatisExceptionTranslator. TranslateExceptionIfPossible (MyBatisExceptionTranslator. Java: 77)
The at org. Mybatis. Spring. SqlSessionTemplate $SqlSessionInterceptor. Invoke (SqlSessionTemplate. Java: 446)
At com. Sun. Proxy. $Proxy120. SelectOne (Unknown Source)
The at org. Mybatis. Spring. SqlSessionTemplate. SelectOne (SqlSessionTemplate. Java: 166)
The at org. Apache. Ibatis. Binding. MapperMethod. Execute (MapperMethod. Java: 83)
The 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 $$$$9 FastClassBySpringCGLIB e58438a. Invoke (& lt; Generated>)
The at org. Springframework. Additional. Proxy. MethodProxy. Invoke (MethodProxy. Java: 218)
The at org. Springframework. Aop. Framework. CglibAopProxy $DynamicAdvisedInterceptor. Intercept (CglibAopProxy. Java: 684)
At com. Cisdi. Model. Yard. Service. Impl. TagServiceImpl $$$$f68216a8 EnhancerBySpringCGLIB. MaxAnaAvgTagTime (& lt; Generated>)
At com. Cisdi. Model. Yard. Controller. TaskLeanProductionCalController. & lt; 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)
The at Java. Lang. Reflect. Constructor. NewInstance (423) Constructor. Java:
The at org. Springframework. Beans. BeanUtils. InstantiateClass (BeanUtils. Java: 172)
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- here is SQL -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
The select TRUNC (Max (clock), 'hh24)
The from tag_value
Where id BETWEEN 7000 and 7099
The Date maxAnaAvgTagTime ();
Project executing the query is an error, colleagues on a computer can be as far as I can't, have no leaders met ah!!!!!!!!!! Urgent
CodePudding user response:
Seems to be an error in the connection pool, direct check whether there are abnormalCodePudding user response:
Even there is a problem, no problem, here I had problems return null return date is no problem,,CodePudding user response:
Personal feeling is the date in the database and Java date can't conversion,If it is not mandatory suggest resultType="Java. Long. The string", then their own formatting,
Example:
The DateFormat format=new SimpleDateFormat (" MM - dd yyyy - HH: MM: ss ");
String dateString=format. The parse (" return value "); After parsing the Date type
CodePudding user response:
Check whether the driver version is consistent