Skip to main content

Dinamically create connection pool

Please note these java.net forums are being decommissioned and use the new and improved forums at https://community.oracle.com/community/java.
No replies
josesuero
Offline
Joined: 2009-07-17

I have a service that uses a seperate database for each client, so we currently create a new connection pool on glassfish for each client, so I'd like to create a connection pool "on the fly" if one does not exists, keep this connection in memory for a specific time and then remove it after it times out. We have considered removing the pool all togheter and just connecting to the database for every connection, but we really like the advantages of polling connections.

I have seen (and tested) something similar on tomcat, is this possible?? any other ideas??

thanks in advance

Jose Suero