private ConnectionSource setupConnection(DatabaseConfig dbConfig) throws SQLException {
HikariDataSource ds = new HikariDataSource();
if (!dbConfig.getUser().isEmpty()) {
ds.setUsername(dbConfig.getUser());
}
if (!dbConfig.getPassword().isEmpty()) {
ds.setPassword(dbConfig.getPassword());
}
ds.setJdbcUrl(dbConfig.getJDBCUrl());
ds.setMaximumPoolSize(dbConfig.getMaxConnections());
/* Keep the connection open for 5 minutes */
// ds.setMaxLifetime(300000);
return new DataSourceConnectionSource(ds, new MySQLDatabase());
}
