I would like to know if there is a way to use DB roles with this connection pool DataSource?
Generally, I would like to know if database roles are still used in a J2EE application (that uses DataSource objects in order to connect to the DB)? Or is there a general trend to stop using DB roles and move to J2EE roles?
I would say no, they are not used much these days to provide user-level security although there may be people out there who still use them to a large degree. Usually DB roles are too limited in functionality to be used in any great degree so most db systems I have worked on use the same set of username/passwords for all users with the condition that the J2EE server ultimately protects the database server from unauthorized access (assuming the DB server is not exposed externally).