Managing password updates in Commons-DBCP

[Scott Stevens <mm...@yahoo.com>]

Hello Commons-Users,
 
The issue we are having is that we are implementing a policy forcing database account password changes every 90 days.  
 
Our DataSource implementation class uses the SharedPoolDataSource (from commons-dbcp) in managing its PooledConnections. Unfortunately, it appears that SharedPoolDataSource maps the user/password info using the user name. If the user's password changes and the old user/password info is already in the Map, a test in the SharedPoolDataSource prevents client apps from getting a connection on the user.  Also the Map object is private to SharedPoolDataSource, and simply implementing our own version of SharedPoolDataSource will not work, since there's a ton of package level classes being used.
 
Can anyone provide a straight-forward method to replacing the expired username/password mapping such that a SharedPoolDataSource may recognize/replace the new account password?
 
Thank you for any suggestions.
 
Scott Stevens

		
---------------------------------
Do you Yahoo!?
 Yahoo! Small Business - Try our new resources site!