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

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)

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

坐等大神帮助,跪谢。

Caused by: java.sql.SQLException: Error
at com.alibaba.druid.pool.DruidDataSource.handleConnectionException(DruidDataSource.java:1180)
at com.alibaba.druid.pool.DruidPooledConnection.handleException(DruidPooledConnection.java:127)
at com.alibaba.druid.pool.DruidPooledStatement.checkException(DruidPooledStatement.java:68)
at com.alibaba.druid.pool.DruidPooledResultSet.checkException(DruidPooledResultSet.java:55)
at com.alibaba.druid.pool.DruidPooledResultSet.getMetaData(DruidPooledResultSet.java:432)
at org.apache.ibatis.executor.keygen.Jdbc3KeyGenerator.processBatch(Jdbc3KeyGenerator.java:55)
at org.apache.ibatis.executor.keygen.Jdbc3KeyGenerator.processAfter(Jdbc3KeyGenerator.java:45)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:48)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
at com.sun.proxy.$Proxy18.update(Unknown Source)
at org.apache.ibatis.executor.ReuseExecutor.doUpdate(ReuseExecutor.java:50)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:105)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:71)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:141)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
... 44 more
Caused by: java.lang.NullPointerException
at oracle.jdbc.driver.AutoKeyInfo.initMetaDataKeyFlag(AutoKeyInfo.java:404)
at oracle.jdbc.driver.AutoKeyInfo.initMetaData(AutoKeyInfo.java:392)
at oracle.jdbc.driver.OracleReturnResultSet.getMetaData(OracleReturnResultSet.java:77)
at com.alibaba.druid.filter.FilterChainImpl.resultSet_getMetaData(FilterChainImpl.java:970)
at com.alibaba.druid.filter.FilterAdapter.resultSet_getMetaData(FilterAdapter.java:1637)
at com.alibaba.druid.filter.FilterChainImpl.resultSet_getMetaData(FilterChainImpl.java:968)
at com.alibaba.druid.proxy.jdbc.ResultSetProxyImpl.getMetaData(ResultSetProxyImpl.java:517)
at com.alibaba.druid.pool.DruidPooledResultSet.getMetaData(DruidPooledResultSet.java:430)
... 64 more
2016-05-31 19:16:59 -151523 [DubboServerHandler-192.168.1.111:20880-thread-12] 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:59 -151524 [DubboServerHandler-192.168.1.111:20880-thread-12] INFO - 执行服务,用户分配角色:addRurele
2016-05-31 19:16:59 -151524 [DubboServerHandler-192.168.1.111:20880-thread-12] INFO - 分配的内容{USER_NAM=电饭锅, ROLE_IDS=admin,admin1, USER_ID=56古典风格}
2016-05-31 19:16:59 -151524 [DubboServerHandler-192.168.1.111:20880-thread-12] INFO - 执行服务,用户角色表信息删除:deleteRurele
2016-05-31 19:16:59 -151524 [DubboServerHandler-192.168.1.111:20880-thread-12] INFO - 删除条件{USER_NAM=电饭锅, ROLE_IDS=admin,admin1, USER_ID=56古典风格}
2016-05-31 19:16:59 -151525 [DubboServerHandler-192.168.1.111:20880-thread-12] DEBUG - ==> Preparing: delete from LIMRURELE where USER_ID = ?
2016-05-31 19:16:59 -151526 [DubboServerHandler-192.168.1.111:20880-thread-12] DEBUG - ==> Parameters: 56古典风格(String)
2016-05-31 19:16:59 -151529 [DubboServerHandler-192.168.1.111:20880-thread-12] DEBUG - <== Updates: 2
[Ljava.lang.String;@35e740ee
------admin
2016-05-31 19:16:59 -151530 [DubboServerHandler-192.168.1.111:20880-thread-12] DEBUG - ==> Preparing: insert into LIMRURELE (ROLE_ID,USER_ID) values (?,?)
2016-05-31 19:16:59 -151531 [DubboServerHandler-192.168.1.111:20880-thread-12] DEBUG - ==> Parameters: admin(String), 56古典风格(String)
2016-05-31 19:16:59 -151534 [DubboServerHandler-192.168.1.111:20880-thread-12] DEBUG - <== Updates: 1
返回值:1
------admin1
2016-05-31 19:16:59 -151535 [DubboServerHandler-192.168.1.111:20880-thread-12] DEBUG - ==> Parameters: admin1(String), 56古典风格(String)
2016-05-31 19:16:59 -151538 [DubboServerHandler-192.168.1.111:20880-thread-12] DEBUG - <== Updates: 1
返回值:1
2016-05-31 19:16:59 -151690 [DubboServerHandler-192.168.1.111:20880-thread-13] 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:59 -151692 [DubboServerHandler-192.168.1.111:20880-thread-13] INFO - 执行服务,查询用户信息:findUsers
2016-05-31 19:16:59 -151692 [DubboServerHandler-192.168.1.111:20880-thread-13] INFO - 查询条件:{numPerPage=19, orderField=, pagePath=user/show_user, pageNum=1}
2016-05-31 19:16:59 -151694 [DubboServerHandler-192.168.1.111:20880-thread-13] DEBUG - ==> Preparing: select count(0) from (select USER_ID,USER_NAM,CASE USER_STS WHEN '0' THEN '开启' WHEN '1' THEN '禁用' ELSE NULL END USER_STS,USER_DATE,USER_TEL from LIMUSERINF) tmp_count
2016-05-31 19:16:59 -151695 [DubboServerHandler-192.168.1.111:20880-thread-13] DEBUG - ==> Parameters:
2016-05-31 19:16:59 -151699 [DubboServerHandler-192.168.1.111:20880-thread-13] DEBUG - ==> Preparing: select * from (select tmp_tb.*,ROWNUM row_id from (select USER_ID,USER_NAM,CASE USER_STS WHEN '0' THEN '开启' WHEN '1' THEN '禁用' ELSE NULL END USER_STS,USER_DATE,USER_TEL from LIMUSERINF) tmp_tb where ROWNUM0
2016-05-31 19:16:59 -151699 [DubboServerHandler-192.168.1.111:20880-thread-13] DEBUG - ==> Parameters:
2016-05-31 19:16:59 -151708 [DubboServerHandler-192.168.1.111:20880-thread-13] DEBUG - <== Total: 19
2016-05-31 19:17:14 -166912 [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