We want to start using @Transactional annotations throughout our applications, but before we make such a switch, we want to make sure we understand how connections we'll be retrieved doing this. If I understand correctly, the first time it needs a connection, it will retrieve it from the pool, and then bind it to the thread. Does this mean that that connection is now inaccessible to any other threads and won't be returned to the pool until that thread dies? We have a lot of traffic, and we don't want to max out our database connections because each thread is holding onto it's own connection. Say we have 6 app servers and 250 incoming requests at any time. Does this mean there would be 1500 (250 * 6) connections to the database at any given time? Please help me if I'm not understanding something correctly. Thanks.
Connection usage when using Spring transaction management Page Title Module
Move Remove Collapse