为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:05-20 15:10:30.131 -- ERROR [http-nio-9980-exec-9] ele-archives [com.baiwang.archives.config.DefaultExceptionHandler ?] - [NONE][NONE][0][xWop1209154800779788288] [eleSelectDossierDto_logId:"8d763967-58f0-4f83-82de-5823f8f759ca"] 运行时异常: org.springframework.jdbc.UncategorizedSQLException: Error updating database. Cause: dm.jdbc.driver.DMException: Connection has been switched The error may exist in class path resource [mapper/oracle/EleFileManagementMapper.xml] The error may involve defaultParameterMap The error occurred while setting parameters SQL: update ele_file_management set ARCHIVE_STATUS_PROGRESS=? where MANAGEMENT_ID in ( ? ) Cause: dm.jdbc.driver.DMException: Connection has been switched ; uncategorized SQLException; SQL state []; error code [20800]; Connection has been switched; nested exception is dm.jdbc.driver.DMException: Connection has been switched at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy223.update(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:288) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:67) at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:141) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) at com.sun.proxy.$Proxy267.updateArchivesStatusProgressByIdList(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:241) at com.sun.proxy.$Proxy268.updateArchivesStatusProgressByIdList(Unknown Source) at com.baiwang.archives.service.impl.ArchiveServiceImplWorkFlow.lambda$tickArchive$4(ArchiveServiceImplWorkFlow.java:216) at java.util.HashMap.forEach(HashMap.java:1298) at com.baiwang.archives.service.impl.ArchiveServiceImplWorkFlow.tickArchive(ArchiveServiceImplWorkFlow.java:204) at com.baiwang.archives.service.impl.ArchiveServiceImplWorkFlow.updateArchive(ArchiveServiceImplWorkFlow.java:105) at com.baiwang.archives.service.impl.ArchiveServiceImplWorkFlow$$FastClassBySpringCGLIB$$96038B58.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
这什么原因哈,客户端执行很顺畅,代码报这个错误,怀疑druid配置问题,但是找不到原因,求大佬指教

附 druid 配置
数据源类型(Druid连接池)
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
连接池初始化大小
spring.datasource.druid.initial-size=30
连接池最大活跃连接数
spring.datasource.druid.max-active=200
获取连接的最大等待时间(单位:毫秒)
spring.datasource.druid.max-wait=12000
连接池中的连接最小空闲时间(单位:毫秒)
spring.datasource.druid.min-evictable-idle-time-millis=600000
连接池中的连接最大空闲时间(单位:毫秒)
spring.datasource.druid.max-evictable-idle-time-millis=1800000
连接池最小空闲连接数
spring.datasource.druid.min-idle=20
是否缓存PreparedStatement(PSCache)
spring.datasource.druid.pool-prepared-statements=true
每个连接上PreparedStatement缓存的最大数量
spring.datasource.druid.max-open-prepared-statements=100
borrow连接时是否执行检测
spring.datasource.druid.test-on-borrow=true
return连接时是否执行检测
spring.datasource.druid.test-on-return=false
空闲时是否执行检测
spring.datasource.druid.test-while-idle=true
空闲连接检测的运行间隔(单位:毫秒)
spring.datasource.druid.time-between-eviction-runs-millis=30000
检测连接是否有效的SQL语句(Oracle专用)
spring.datasource.druid.validation-query=SELECT 1 FROM DUAL
连接有效性检测的超时时间(单位:秒)
spring.datasource.druid.validation-query-timeout=5000
数据库连接超时时间(单位:毫秒)
spring.datasource.druid.connectTimeout=60000
数据库Socket超时时间(单位:毫秒)
spring.datasource.druid.socketTimeout=60000
是否开启保活机制
spring.datasource.druid.keep-alive=true
保活检测的时间间隔(单位:毫秒)
spring.datasource.druid.keep-alive-between-time-millis=60000