-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Jukka,
On 2/25/13 12:52 AM, Jukka Ruohonen wrote: > A question related to pools. Background: a big application in which > it is preferable to enforce different roles for different databases > and tables. This implies that there are different user names and > passwords for different connections. As I understand, there are two > options for connection pooling in a scheme like this: > > A. Create different resources for the different roles, each having > the user names and passwords defined as constants in the Tomcat > configuration files. > > B. Group the different roles into a bigger scheme and use the > option 'alternateUsernameAllowed' to obtain the connections with > the specific user names and passwords. C. I believe that tomcat-pool (*not* the stock one based upon commons DBCP) supports the DataSource.getConnection(username, password) call and might even be smart enough to search-through existing connections for one that matches those credentials. This will allow you to have a single DataSource but still have different credentials for your connection on-demand. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.17 (Darwin) Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iEYEAREIAAYFAlEv9WcACgkQ9CaO5/Lv0PC96wCfThPzq93bKI/zgh+EygvHbxnQ wJUAn1o7h5KBvCNGc68xSdJGcl7sorXJ =DVTs -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
