I just want some direction/clarification on something i don't understand. If I configure a datasource I must supply the user and password directly in the xml file. What if I want to have more than just one user connect to the database. Oracle 9i/10g provides Proxy Authentication to where one user can create the connection pool and other users can proxy through that user to connect. Is there any way to take advantage of this in JBoss connection pooling? If not is there any way to supply user credentials dynamically? Ideally I would store the user credentials in an HttpSession and use this information to log into the database.
Thanks for any help.