HikariTest

@Test    
public void hikariTest() {     
    try {     
        HikariConfig config = new HikariConfig();    
        config.setJdbcUrl("jdbc:sqlite://C:/mydatabases/mydb.db");  
        config.setUsername("bart");
        config.setPassword("51mp50n");
        config.setMinimumIdle(1);    
        config.setMaximumPoolSize(5);    

        HikariDataSource ds = new HikariDataSource(config);    
            
        Connection conn = ds.getConnection();    
            
        Statement stmt = conn.createStatement();    
            
        ResultSet rs = stmt.executeQuery("SELECT count(*) as ct from MY_TABLE");    
            
        while (rs.next()) {     
            System.out.println(rs.getInt("ct"));    
        }    
            
        } catch (Exception e) {     
            e.printStackTrace();    
        }    
}