Set the connection timeout when using HikariCP

Configure a connection timeout when connecting to Cloud SQL for MySQL by using the HikariCP JDBC connection pool library.

Explore further

For detailed documentation that includes this code sample, see the following:

• Manage database connections

Code sample

Java

To authenticate to Cloud SQL for MySQL, set up Application Default Credentials. For more information, see Set up authentication for a local development environment.

// setConnectionTimeout is the maximum number of milliseconds to wait for a connection checkout.
// Any attempt to retrieve a connection from this pool that exceeds the set limit will throw an
// SQLException.
config.setConnectionTimeout(10000); // 10 seconds
// idleTimeout is the maximum amount of time a connection can sit in the pool. Connections that
// sit idle for this many milliseconds are retried if minimumIdle is exceeded.
config.setIdleTimeout(600000); // 10 minutes

What's next

To search and filter code samples for other Google Cloud products, see the Google Cloud sample browser.