当前位置: 首页 > 面试题库 >

数据库连接池[Hikari]初始化错误

周承天
2023-03-14
问题内容

我正在尝试为我的Web应用程序配置HikariCP。我没有使用任何框架,它是一个简单的简单Java
Web应用程序。当我尝试通过普通的JDBC建立连接时,它成功了,并且能够执行所有数据库操作。

但是,当我尝试与连接池建立连接时,初始化后却收到了一个我不知道的异常。

下面是我正在使用的配置,我正在上下文侦听器中对其进行初始化。我在Java 1.7上运行,带有使用HikariCP Java
6依赖项2.3.2的Tomcat容器

import java.sql.Connection;
import java.sql.SQLException;
import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;
import com.mkgcorp.travelweb.util.TLog;
import com.sun.jersey.core.util.Base64;
import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;

public class CPInit implements ServletContextListener{

    private final static String TAG = CPInit.class.getSimpleName();
    private static HikariConfig mConfig;
    private static HikariDataSource mDataSource;

    public static String POOL_NAME = "TripPool";
    public static int POOL_SIZE = 10;
    public static int TIME_OUT = 30*1000;
    public static int MIN_IDLE_SIZE = 2;
    public static boolean isDebuggable;

    private String PASSWORD = "YWRtaW4=";


    public CPInit(){
        String string = new String(Base64.decode(PASSWORD));
        TLog.info(TAG, "Password = " + string);
        mConfig = new HikariConfig();
        mConfig.setDataSourceClassName("com.mysql.jdbc.jdbc2.optional.MysqlDataSource");
        mConfig.addDataSourceProperty("url", "jdbc:mysql://127.0.0.1:3306/travlemate");
        mConfig.addDataSourceProperty("cachePrepStmts", "true");
        mConfig.addDataSourceProperty("prepStmtCacheSize", "250");
        mConfig.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");
        mConfig.addDataSourceProperty("useServerPrepStmts", "true");
        mConfig.addDataSourceProperty("user", "root");
        mConfig.addDataSourceProperty("password", string);
        mConfig.setMaximumPoolSize(POOL_SIZE);
        mConfig.setMinimumIdle(MIN_IDLE_SIZE);
        mConfig.setPoolName(POOL_NAME);
        mConfig.setConnectionTimeout(TIME_OUT);
        mConfig.setAutoCommit(true);
        mConfig.setInitializationFailFast(false);
        mDataSource = new HikariDataSource(mConfig);
    }

    @Override
    public void contextDestroyed(ServletContextEvent arg0) {
        TLog.info(TAG, "CP has being destroyed");
        mDataSource.close();

    }

    public static Connection getConnection() throws SQLException{
        TLog.info(TAG, "get data connection");
        return mDataSource.getConnection();
    }

    @Override
    public void contextInitialized(ServletContextEvent arg0) {
        TLog.info(TAG, "CP has been initilizing");
        String parm = arg0.getServletContext().getInitParameter("debugging");
        isDebuggable = Boolean.valueOf(parm);
    }

}

这是我得到的例外:

java.sql.SQLTimeoutException: Timeout after 30005ms of waiting for a connection.
    at com.zaxxer.hikari.pool.BaseHikariPool.getConnection(BaseHikariPool.java:228)
    at com.zaxxer.hikari.pool.BaseHikariPool.getConnection(BaseHikariPool.java:183)
    at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:91)
    at com.mkgcorp.travelweb.controller.CPInit.getConnection(CPInit.java:68)
    at com.mkgcorp.travelweb.data.Database.getConnection(Database.java:47)
    at com.mkgcorp.travelweb.data.DataManager.getConnection(DataManager.java:100)
    at com.mkgcorp.travelweb.data.DataManager.authenticateUser(DataManager.java:135)
    at com.mkgcorp.travelweb.webservices.TripResource.isUserValid(TripResource.java:169)
    at com.mkgcorp.travelweb.webservices.SyncResource.getContactStatus(SyncResource.java:70)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
    at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
    at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
    at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
    at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
    at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
    at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
    at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
    at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
    at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
    at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
    at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
    at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
    at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:540)
    at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:715)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1085)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)
    at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1556)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1513)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: JDBC4 Connection.isValid() method not supported, connection test query must be configured
    at com.zaxxer.hikari.pool.BaseHikariPool.addConnection(BaseHikariPool.java:399)
    at com.zaxxer.hikari.pool.HikariPool$1AddConnection.run(HikariPool.java:78)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    ... 1 more

问题答案:

实际上我得到了答案,Hikari需要设置一个连接测试查询,如果那完成了JDBC4 isValid将不会被调用。

因此,只需添加属性,我就能使其正常工作。

mConfig.setConnectionTestQuery("show tables");


 类似资料:
  • 我的服务器上有一个Spring启动项目。我有时会遇到“Hikari池连接不可用”错误。我想不出原因。我看起来有很多这样的问题。一些人建议关闭一些@交易。但是,在我的应用程序中,我没有使用任何@Transactional注释。以下是我的Hikari池配置: 当我检查我的卡塔琳娜。在日志文件外,我注意到活动连接数有时会增加。例如,昨天没有活动的连接。所有连接都处于空闲状态。现在池中有2个活动连接。是否

  • 我是Grails新手。在DataSource.groovy中进行了一些基本配置后,我的grails应用程序无法启动。我得到以下错误 数据库radb存在。我已经核实过了 我的datasource.groovy文件供参考,如下所示

  • Hibernate Utils正在创建带有Hikari配置的会话工厂。目前我们正在做@Setup方法的ParDo,但它打开了太多的连接。那么有没有什么好的例子来初始化每个工作人员的连接池呢?

  • 问题内容: 我无法确定为什么在我的Hibernate应用程序中初始化c3p0连接池需要2分钟。 这是在我的Hibernate.cfg.xml中: 构建会话工厂时,连接设置在我的HibernateUtil文件中设置。 当测试中的第一个事务为openend时,池将初始化。之后,连接和查询数据库就可以正常工作,它在开始之前仅在以下行上挂起一会儿。我对输出进行了格式化,因为我认为问题可能出在这里提到的一种

  • 问题内容: 我在玩图书馆。我想从PostgreSQL数据库中检索数据。我得到的错误对我来说很奇怪。即使我手动配置CP: 我仍然看到错误。这是我的DAO: 该应用程序: 我的档案 错误: 我错过了什么? 问题答案: 要加载,应提前调用scalikejdbc-config 。 http://scalikejdbc.org/documentation/configuration.html#scalike