JDBC connection pool

Question

Can I enable requests to a JDBC connection pool for a database connection to wait till a connection is accessible?

Answer 1

No, there's no way to let a request to wait for a pool connection, and from the system view point there should not be. Each request waits for a connection ties up one of the fixed number of execute threads in the server, which could or else be running another server task. Too many waiting requests could tie up all execute threads and freeze the server.