What algorithm is used in the Jdbc pool for re-using the pooled connections ?
It is useful to know how the BES Jdbc pool internally works. The Jdbc connection pool that is provided by Borland Enterprise Server reuses connections if it can find them in the pool and opens new ones only if the pool is empty and maxPoolSize hasn’t reached. Two usage models of the pool: • Non-transactional use: This means the application (example an EJB) is not associated with a transaction when it requests a connection. In this case, the connection is put back into the pool as soon as the application calls java.sql.Connection.close(). • Transactional use: This means the application (thread) is associated with an active transaction when it requests a Jdbc connection. In this case, the Jdbc connection returns to be pool for re-use when the transaction ends.
