2017-02-17 15:57 GMT+01:00 Fu, Enzhong <enzhong...@pnc.com>: > Different user id and roles are for individuals to access database (using > SQL client or other tools). DBCP is for application, you usually have one > pool with application id. The application id has all the accesses. You can > control access of each individual user within the application. >
Yes but still you can use the requested username as a cache key. This is part of the JCA architecture and all application server pools support it. DBCP has for example the PerUserPoolDatasource and SharedPoolDataSource. (I think there was also somewhere support for proxy users) Gruss Bernd
