durid配置:
public void configPlugin(Plugins me) { Prop p = PropKit.use("a_little_config.txt"); // C3p0Plugin c3p0Plugin = new C3p0Plugin(p.get("jdbcUrl"), // p.get("user"), p.get("password")); CommonKit.initComonKit(); DruidPlugin dp = new DruidPlugin(CommonKit.getJdbcUrl(), CommonKit.getUserName(), CommonKit.getPassWord()); // 配置初始化大小、最小、最大 dp.setInitialSize(10); dp.setMinIdle(10); dp.setMaxActive(200); dp.setTestWhileIdle(true); // 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 dp.setTimeBetweenEvictionRunsMillis(1000 * 60 * 5); // 配置获取连接等待超时的时间 dp.setMaxWait(1000 * 60 * 5); //dp.setRemoveAbandonedTimeoutMillis(300000); // 配置一个连接在池中最小生存的时间,单位是毫秒 dp.setMinEvictableIdleTimeMillis(1000 * 60 * 5); // 获取连接时检测连接的有效性 dp.setTestOnBorrow(false); // 返还连接时检测连接的有效性 dp.setTestOnReturn(false); me.add(dp); ActiveRecordPlugin arp = new ActiveRecordPlugin(dp).setShowSql(true); _MappingKit.mapping(arp); me.add(arp); // ehcache缓存插件 me.add(new EhCachePlugin()); //DruidPlugin dp2 = new DruidPlugin(p.get("jdbcUrl2"), p.get("user2"), p.get("password2"),p.get("jdbcDriver2")); DruidPlugin dp2 = new DruidPlugin(CommonKit.getOracleUrl(),CommonKit.getOracleUser(),CommonKit.getOraclePassword(),CommonKit.getOracleDriver()); // C3p0Plugin cp2 = new C3p0Plugin(PropKit.get("jdbcUrl2"), // PropKit.get("user2"), // PropKit.get("password2"),PropKit.get("jdbcDriver2")); /* * cp2.setInitialPoolSize(3); cp2.setMaxIdleTime(10); * cp2.setMinPoolSize(3); cp2.setMaxIdleTime(6); */ // 配置初始化大小、最小、最大 dp2.setInitialSize(10); dp2.setMinIdle(10); dp2.setMaxActive(100); // 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 dp2.setTimeBetweenEvictionRunsMillis(10000); // 配置获取连接等待超时的时间 dp2.setMaxWait(80000); // 配置一个连接在池中最小生存的时间,单位是毫秒 dp2.setMinEvictableIdleTimeMillis(300000); dp2.setValidationQuery("SELECT 1 FROM DUAL"); dp2.setTestWhileIdle(true); dp2.setTestOnBorrow(false); dp2.setTestOnReturn(false); me.add(dp2); ActiveRecordPlugin arp2 = new ActiveRecordPlugin("db2", dp2).setShowSql(true); // arp2.setDialect(new AnsiSqlDialect()); // com.seo.modeloracle._MappingKit.mapping(arp2); me.add(arp2); //配置任务调度插件 //Cron4jPlugin cp = new Cron4jPlugin(); //cp.addTask("*/5 * * * *", new UpdateProductTask()); //me.add(cp); }
报错内容信息:
2019-10-15 17:38:22 [com.jfinal.core.ActionHandler]-[ERROR] /seo/admin/adminUser com.jfinal.plugin.activerecord.ActiveRecordException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 7,711 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago. at com.jfinal.plugin.activerecord.Model.find(Model.java:586) at com.jfinal.plugin.activerecord.Model.find(Model.java:596) at com.seo.controller.AdminController.adminUser(AdminController.java:28) 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:497) at com.jfinal.aop.Invocation.invoke(Invocation.java:73) at com.seo.intercepter.StoreInterceptor.intercept(StoreInterceptor.java:20) at com.jfinal.aop.Invocation.invoke(Invocation.java:67) at com.seo.intercepter.LoginSessionInterceptor.intercept(LoginSessionInterceptor.java:51) at com.jfinal.aop.Invocation.invoke(Invocation.java:67) at com.jfinal.core.ActionHandler.handle(ActionHandler.java:83) at com.seo.silian.SilianHandler.handle(SilianHandler.java:34) at com.seo.silian.SilianHandler.handle(SilianHandler.java:34) at com.jfinal.ext.handler.FakeStaticHandler.handle(FakeStaticHandler.java:58) at com.seo.silian.SilianHandler.handle(SilianHandler.java:34) at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:73) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 7,711 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:422) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3589) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3478) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4019) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2310) at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:228) at com.jfinal.plugin.activerecord.Model.find(Model.java:567) at com.jfinal.plugin.activerecord.Model.find(Model.java:584) ... 34 more Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3039) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3489) ... 44 more
不知道到底是哪儿问题呢?之前一直都好端端的!~重启过服务器,还是不行!~!
项目:JFinal