<dependency>

        <groupId>com.zaxxer</groupId>

        <artifactId>HikariCP</artifactId>

        <version>2.6.1</version>

    </dependency>

    <dependency>

        <groupId>com.zaxxer</groupId>

        <artifactId>HikariCP-java7</artifactId>

        <version>2.4.11</version>

    </dependency>

    <dependency>

        <groupId>com.zaxxer</groupId>

        <artifactId>HikariCP-java6</artifactId>

        <version>2.3.13</version>

    </dependency>

HikariConfig config = new HikariConfig();

config.setJdbcUrl("jdbc:mysql://localhost:3306/simpsons");

config.setUsername("bart");

config.setPassword("51mp50n");

config.addDataSourceProperty("cachePrepStmts", "true");

config.addDataSourceProperty("prepStmtCacheSize", "250");

config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");

HikariDataSource ds = new HikariDataSource(config);