Connection Pooling
Opening a new database connection for every request is slow and resource-intensive. Connection pooling solves this by reusing a pool of open connections. HikariCP is a popular, high-performance connection pool for Java applications.
Set up HikariCP for CityBook Libraries to improve their application's performance. HikariConfig, HikariDataSource, and database credentials are already imported for you.
Este exercício faz parte do curso
Querying a PostgreSQL Database in Java
Instruções do exercício
- Configure
HikariConfigwith the database URL, username, and password. - Create a
HikariDataSourcefrom the configuration. - Get a connection from the pool.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
public class Main {
public static void main(String[] args) {
// Configure HikariCP with credentials
HikariConfig config = new HikariConfig();
config.____(Credentials.URL);
config.____(Credentials.USER);
config.____(Credentials.PASSWORD);
// Create the connection pool
HikariDataSource ds = new ____(config);
// Get a connection from the pool
try (Connection conn = ____.____()) {
System.out.println("Connected with HikariCP!");
} catch (SQLException e) {
System.out.println("Error: " + e.getMessage());
System.out.println("SQLState: " + e.getSQLState());
}
}
}