druid + mybatis insert 第一次报错，第二次执行就没问题了

Question

2016-05-31 19:16:14 -106908 [New I/O server worker #1-1] DEBUG - [DUBBO] Received heartbeat from remote channel /192.168.1.111:54696, cause: The channel has no data-transmission exceeds a heartbeat period: 60000ms, dubbo version: 2.5.3, current host: 192.168.1.111
2016-05-31 19:16:40 -132424 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - [DUBBO] Decode decodeable message com.alibaba.dubbo.rpc.protocol.dubbo.DecodeableRpcInvocation, dubbo version: 2.5.3, current host: 192.168.1.111
2016-05-31 19:16:40 -132425 [DubboServerHandler-192.168.1.111:20880-thread-11] INFO - 执行服务，用户分配角色：addRurele
2016-05-31 19:16:40 -132426 [DubboServerHandler-192.168.1.111:20880-thread-11] INFO - 分配的内容{USER_NAM=电饭锅, ROLE_IDS=admin,admin1, USER_ID=56古典风格}
2016-05-31 19:16:40 -132426 [DubboServerHandler-192.168.1.111:20880-thread-11] INFO - 执行服务，用户角色表信息删除：deleteRurele
2016-05-31 19:16:40 -132426 [DubboServerHandler-192.168.1.111:20880-thread-11] INFO - 删除条件{USER_NAM=电饭锅, ROLE_IDS=admin,admin1, USER_ID=56古典风格}
2016-05-31 19:16:40 -132427 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - ==> Preparing: delete from LIMRURELE where USER_ID = ?
2016-05-31 19:16:40 -132428 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - ==> Parameters: 56古典风格(String)
2016-05-31 19:16:40 -132431 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - <== Updates: 2
[Ljava.lang.String;@41af159b
------admin
2016-05-31 19:16:40 -132432 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - ==> Preparing: insert into LIMRURELE (ROLE_ID,USER_ID) values (?,?)
2016-05-31 19:16:40 -132441 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - ==> Parameters: admin(String), 56古典风格(String)
2016-05-31 19:16:40 -132445 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - <== Updates: 1
2016-05-31 19:16:40 -132473 [DubboServerHandler-192.168.1.111:20880-thread-11] INFO - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2016-05-31 19:16:40 -132517 [DubboServerHandler-192.168.1.111:20880-thread-11] INFO - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
2016-05-31 19:16:40 -132525 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - {conn-10004, pstmt-20008} enter cache
2016-05-31 19:16:40 -132526 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - {conn-10004, pstmt-20009} enter cache
2016-05-31 19:16:40 -132531 [DubboServerHandler-192.168.1.111:20880-thread-11] ERROR - [DUBBO] Got unchecked and undeclared exception which called by 192.168.1.111. service: com.um.facade.user.services.UserService, method: addRurele, exception: org.springframework.jdbc.UncategorizedSQLException: Error getting generated key or setting result to parameter object. Cause: java.sql.SQLException: Error
; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Error; nested exception is java.sql.SQLException: Error, dubbo version: 2.5.3, current host: 192.168.1.111
org.springframework.jdbc.UncategorizedSQLException: Error getting generated key or setting result to parameter object. Cause: java.sql.SQLException: Error
; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Error; nested exception is java.sql.SQLException: Error
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)
at com.sun.proxy.$Proxy14.insert(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:240)
at com.dao.DaoSupport.save(DaoSupport.java:27)
at com.um.user.impl.UserServiceImple.addRurele(UserServiceImple.java:163)
at com.um.user.impl.UserServiceImple$$FastClassByCGLIB$$367515af.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:698)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:631)
at com.um.user.impl.UserServiceImple$$EnhancerByCGLIB$$9cb2eeef.addRurele()
at com.alibaba.dubbo.common.bytecode.Wrapper5.invokeMethod(Wrapper5.java)
at com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:46)
at com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:72)
at com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:53)
at com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:64)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at com.alibaba.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:42)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at com.alibaba.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:75)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:78)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at com.alibaba.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:60)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at com.alibaba.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:112)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:38)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:38)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:108)
at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:84)
at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:170)
at com.alibaba.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:52)
at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:82)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)

Answer 1

上面是错误日志，同一个操作，执行第二次之后，就不会有问题了。后面如何请求都不会报错。