I work in Insurance/Banking sector. We are converting a legacy application to Web and are using GWT for the web tier. We 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.
Can you suggest a way as we would like to pool the database connections.
[Message sent by forum member 'mramadoss' (mramadoss)]
http://forums.java.net/jive/thread.jspa?messageID=277711