I have JAAS and my connection pool set up in JBoss to assume the users login and password when accessing the database. This is a customer requirement so that the database can track transactions by the users login.
After a user has accessed JBoss the connection pool contains connection(s) that the database recognizes as theirs. This causes problems with our System Admin application since you can not change database roles on a user with an active database connection. Connections on the pool remain connected as the last user who accessed them until they are reused or recycled. Performing connection.close() appears to release the connection back to the pool but it is still live and connected as the last user. Is there a configuration to reset a users pooled connections back to the default login and password after they are finished with them? Is there some step that I may have missed? Thanks Rodney View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3883902#3883902 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3883902 ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
