Interview Questions

Can I enable requests to a JDBC connection pool for a database connection to wait until a connection is available?

BEA WebLogic Questions and Answers


(Continued from previous question...)

Can I enable requests to a JDBC connection pool for a database connection to wait until a connection is available?

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

(Continued on next question...)

Other Interview Questions