mybatis+springboot+oracle：merge报错。不清楚为啥找不到对象。还请各位看一下，指点指点…

-- service调用：
int i = poolRuleRelatedMapper.EditPoolRuleRelatedDetail(riskPoolRelatedS);

--mapper.xml实现：

MERGE INTO T_RISK_POOL_RULE_RELATED A1
USING
(

select #{item.L_SOURCE_POOL_ID}
L_SOURCE_POOL_ID,#{item.N_RULE_ID} N_RULE_ID,#{item.L_TARGET_POOL_ID}
L_TARGET_POOL_ID,#{item.VC_STATUS} VC_STATUS,#{item.VC_ADDED_USER}
VC_ADDED_USER from dual

) A2
ON
(
A1.L_SOURCE_POOL_ID = A2.L_SOURCE_POOL_ID and A1.N_RULE_ID =
A2.N_RULE_ID and A1.L_TARGET_POOL_ID = A2.L_TARGET_POOL_ID
)
WHEN
MATCHED THEN
UPDATE SET A1.VC_STATUS = A2.VC_STATUS,A1.VC_ADDED_USER =
A2.VC_ADDED_USER,A1.VC_ADDED_TIME = SYSDATE

报错信息：
2021-10-19 19:58:56.114 INFO 23952 --- [nio-9090-exec-1] com.zaxxer.hikari.HikariDataSource : HikariPool-6 - Starting...
2021-10-19 19:58:56.114 WARN 23952 --- [nio-9090-exec-1] com.zaxxer.hikari.util.DriverDataSource : Registered driver with driverClassName=oracle.jdbc.driver.OracleDriver was not found, trying direct instantiation.
2021-10-19 19:58:56.147 INFO 23952 --- [nio-9090-exec-1] com.zaxxer.hikari.pool.PoolBase : HikariPool-6 - Driver does not support get/色t network timeout for connections. (oracle.jdbc.driver.T4CConnection.getNetworkTimeout()I)
2021-10-19 19:58:56.148 INFO 23952 --- [nio-9090-exec-1] com.zaxxer.hikari.HikariDataSource : HikariPool-6 - Start completed.
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'riskPoolRelatedS' not found. Available parameters are [collection, list]
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy69.update(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:294)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy199.EditPoolRuleRelatedDetail(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:343)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy200.EditPoolRuleRelatedDetail(Unknown Source)
at com.sjf.demo.service.impl.PoolRuleRelatedServiceImpl.EditPoolRuleRelatedDetail(PoolRuleRelatedServiceImpl.java:41)
at com.sjf.demo.service.impl.PoolRuleRelatedServiceImpl$$FastClassBySpringCGLIB$$d6fa0c78.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
at com.sjf.demo.service.impl.PoolRuleRelatedServiceImpl$$EnhancerBySpringCGLIB$$e38ff261.EditPoolRuleRelatedDetail()
at com.sjf.demo.controller.PoolRuleRelatedController.DeletePoolRuleRelated(PoolRuleRelatedController.java:65)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Registered driver with driverClassName=oracle.jdbc.driver.OracleDriver was not found, trying direct instantiation，把这句话复制到任意搜索引擎上，回车。

解决 Registered driver with driverClassName=oracle.jdbc.driver.OracleDriver was not found, trying dire..._weixin_30834019的博客-CSDN博客 spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver　　改为 spring.datasource.driver-class-name=oracle.jdbc.OracleDriver 　　转载于:https://www.cnblogs.com/6324/p/10903960.... https://blog.csdn.net/weixin_30834019/article/details/95846967

nested exception is org.apache.ibatis.binding.BindingException: Parameter 'riskPoolRelatedS' not found. Available parameters are [collection, list]