We are converting our client/server application to Web and are planning to use Glassfish as the appserver.
One of the requirements for our application is that the users should connect to the database with their credentials, as the code in the application uses it for audit purposes. So typically if there are 20 concurrent users, each connection to the database is to be made with their individual user ids.
The users are authenticated against the ldap and the same user id needs to be carried forward to the database. However the connection pooling module connects to the database as the same (db) user id. This would not work for us.
We explained this in detail to Glassfish folks in Java One conference '08, who were most attentive and interested. They felt that it might not too difficult to implement.
I hope more users are having similar requirements particularly in Banking/Government sector.
[Message sent by forum member 'mramadoss' (mramadoss)]
http://forums.java.net/jive/thread.jspa?messageID=281403