jfinal 批量导入报错

2019-05-24 15:04:02

[ERROR]-[Thread: Druid-ConnectionPool-Destroy-2017339841]-[com.alibaba.druid.pool.DruidDataSource.removeAbandoned()]: abandon connection, owner thread: http-nio-8080-exec-2, connected at : 1558681379441, open stackTrace

at java.lang.Thread.getStackTrace(Thread.java:1559)

at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1140)

at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4544)

at com.alibaba.druid.filter.logging.LogFilter.dataSource_getConnection(LogFilter.java:854)

at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4540)

at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:670)

at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4540)

at com.alibaba.druid.filter.FilterAdapter.dataSource_getConnection(FilterAdapter.java:2723)

at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4540)

at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1064)

at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1056)

at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:104)

at com.jfinal.plugin.activerecord.Config.getConnection(Config.java:203)

at com.jfinal.plugin.activerecord.DbPro.batch(DbPro.java:1033)

at com.jfinal.plugin.activerecord.DbPro.batchSave(DbPro.java:1170)

at com.jfinal.plugin.activerecord.Db.batchSave(Db.java:626)

at com.lsk.ftmatch.FtmatchService.initimport(FtmatchService.java:426)

at com.lsk.ftmatch.FtmatchController.initimport(FtmatchController.java:126)

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 com.jfinal.aop.Invocation.invoke(Invocation.java:73)

at com.lsk.admin.interceptor.SessionInterceptor.intercept(SessionInterceptor.java:28)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at com.lsk.common.interceptor.CacheInterceptor.intercept(CacheInterceptor.java:22)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at com.lsk.common.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:16)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at com.jfinal.core.ActionHandler.handle(ActionHandler.java:83)

at com.lsk.handler.DruidStatViewHandlerRewrite.handle(DruidStatViewHandlerRewrite.java:75)

at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:73)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:498)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:796)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1374)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:748)

ownerThread current state is RUNNABLE, current stackTrace

at com.alibaba.druid.pool.DruidPooledConnection.checkStateInternal(DruidPooledConnection.java:1140)

at com.alibaba.druid.pool.DruidPooledConnection.checkState(DruidPooledConnection.java:1131)

at com.alibaba.druid.pool.DruidPooledConnection.commit(DruidPooledConnection.java:740)

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 com.jfinal.plugin.activerecord.SqlReporter.invoke(SqlReporter.java:58)

at com.sun.proxy.$Proxy7.commit(Unknown Source)

at com.jfinal.plugin.activerecord.DbPro.batch(DbPro.java:1009)

at com.jfinal.plugin.activerecord.DbPro.batch(DbPro.java:1036)

at com.jfinal.plugin.activerecord.DbPro.batchSave(DbPro.java:1170)

at com.jfinal.plugin.activerecord.Db.batchSave(Db.java:626)

at com.lsk.ftmatch.FtmatchService.initimport(FtmatchService.java:426)

at com.lsk.ftmatch.FtmatchController.initimport(FtmatchController.java:126)

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 com.jfinal.aop.Invocation.invoke(Invocation.java:73)

at com.lsk.admin.interceptor.SessionInterceptor.intercept(SessionInterceptor.java:28)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at com.lsk.common.interceptor.CacheInterceptor.intercept(CacheInterceptor.java:22)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at com.lsk.common.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:16)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at com.jfinal.core.ActionHandler.handle(ActionHandler.java:83)

at com.lsk.handler.DruidStatViewHandlerRewrite.handle(DruidStatViewHandlerRewrite.java:75)

at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:73)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:498)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:796)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1374)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:748)



2019-05-24 15:04:02

[ERROR]-[Thread: http-nio-8080-exec-2]-[com.jfinal.kit.LogKit.error()]: connection holder is null

java.sql.SQLException: connection holder is null

at com.alibaba.druid.pool.DruidPooledConnection.checkStateInternal(DruidPooledConnection.java:1140)

at com.alibaba.druid.pool.DruidPooledConnection.checkState(DruidPooledConnection.java:1131)

at com.alibaba.druid.pool.DruidPooledConnection.setAutoCommit(DruidPooledConnection.java:698)

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 com.jfinal.plugin.activerecord.SqlReporter.invoke(SqlReporter.java:58)

at com.sun.proxy.$Proxy7.setAutoCommit(Unknown Source)

at com.jfinal.plugin.activerecord.DbPro.batch(DbPro.java:1041)

at com.jfinal.plugin.activerecord.DbPro.batchSave(DbPro.java:1170)

at com.jfinal.plugin.activerecord.Db.batchSave(Db.java:626)

at com.lsk.ftmatch.FtmatchService.initimport(FtmatchService.java:426)

at com.lsk.ftmatch.FtmatchController.initimport(FtmatchController.java:126)

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 com.jfinal.aop.Invocation.invoke(Invocation.java:73)

at com.lsk.admin.interceptor.SessionInterceptor.intercept(SessionInterceptor.java:28)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at com.lsk.common.interceptor.CacheInterceptor.intercept(CacheInterceptor.java:22)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at com.lsk.common.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:16)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at com.jfinal.core.ActionHandler.handle(ActionHandler.java:83)

at com.lsk.handler.DruidStatViewHandlerRewrite.handle(DruidStatViewHandlerRewrite.java:75)

at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:73)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: connection holder is null

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)

at com.jfinal.plugin.activerecord.DbPro.batch(DbPro.java:1038)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)

at com.jfinal.plugin.activerecord.DbPro.batchSave(DbPro.java:1170)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

at com.jfinal.plugin.activerecord.Db.batchSave(Db.java:626)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)

at com.lsk.ftmatch.FtmatchService.initimport(FtmatchService.java:426)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:498)

at com.lsk.ftmatch.FtmatchController.initimport(FtmatchController.java:126)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:796)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1374)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at com.jfinal.aop.Invocation.invoke(Invocation.java:73)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at com.lsk.admin.interceptor.SessionInterceptor.intercept(SessionInterceptor.java:28)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at java.lang.Thread.run(Thread.java:748)

at com.lsk.common.interceptor.CacheInterceptor.intercept(CacheInterceptor.java:22)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)


at com.lsk.common.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:16)

JFinal action report -------- 2019-05-24 15:04:02 ------------------------------

Url         : POST /ftmatch/initimport

Controller  : com.lsk.ftmatch.FtmatchController.(FtmatchController.java:1)

Method      : initimport

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

UrlPara     : 1558681365306

at com.jfinal.core.ActionHandler.handle(ActionHandler.java:83)

Interceptor : com.lsk.common.interceptor.ExceptionInterceptor.(ExceptionInterceptor.java:1)

at com.lsk.handler.DruidStatViewHandlerRewrite.handle(DruidStatViewHandlerRewrite.java:75)

              com.lsk.common.interceptor.CacheInterceptor.(CacheInterceptor.java:1)

at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:73)

              com.lsk.admin.interceptor.SessionInterceptor.(SessionInterceptor.java:1)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

--------------------------------------------------------------------------------

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:498)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:796)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1374)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:748)

Caused by: java.sql.SQLException: connection holder is null

at com.alibaba.druid.pool.DruidPooledConnection.checkStateInternal(DruidPooledConnection.java:1140)

at com.alibaba.druid.pool.DruidPooledConnection.checkState(DruidPooledConnection.java:1131)

at com.alibaba.druid.pool.DruidPooledConnection.commit(DruidPooledConnection.java:740)

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 com.jfinal.plugin.activerecord.SqlReporter.invoke(SqlReporter.java:58)

at com.sun.proxy.$Proxy7.commit(Unknown Source)

at com.jfinal.plugin.activerecord.DbPro.batch(DbPro.java:1009)

at com.jfinal.plugin.activerecord.DbPro.batch(DbPro.java:1036)

... 40 more


评论区

JFinal

2019-05-24 15:36

注意看异常:
Caused by: java.sql.SQLException: connection holder is null

难道是你的数据库没连上?

热门反馈

扫码入社