我正在尝试为我的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");
<