Mostly your requirements are not sufficiently specified.
If you want to, for example, change the db url, user. and pw for a pool once a day, and kill all the old connections and start over, you should be able to do this right now through jmx. If you store the settings in ldap please explain how you would notify the pool that the settings have changed.
On the other hand, if you want the database connected to to depend on the identity of the user logging in, you need a special login module and modified jca-jdbc wrapper. Someone wrote one where the user/pw/dburl info is stored in a db: I considered committing it to cvs but it required quite a bit of cleanup that I haven't had time for. However, I think I can find it and send it to you if you want.
Or perhaps you have something else in mind.
yes it would be quite helpful if i can get that module and have a hands on to whatever it has to offer.
Secondly i am still working on making my requirements more refined.
Will get back soon
>If you want to, for example, change the db url, user. >and pw for a pool once a day, and kill all the old >connections and start over, you should be able to do >this right now through jmx. If you store the settings in >ldap please explain how you would notify the pool that >the settings have changed
Is it possible to reload the configuration settings automatically after a pre-defined period ?
right now i guess it loads/caches the connection specifications from the db-service.xml descriptor in the deploy folder the very first time and then uses same connection till the server is reloaded or the Mbean is re-started.
Can this be achieved :
Scheduled reload of the connection parameters ?
You can use the Scheduler mbean to periodically run something that reads the config parameters (from ldap?), stops the adapter mbeans, changes the config, and restarts them.
I'm having network problems with the machine that has the adapter I mentioned, I can't get to it right now.
Could you post said code, we need to have the user/password in a separate DB, and not in the config files... ??
That is exactly what I need - to be able to connect to the db on-the-fly on-runtime based on the user/pw/dburl. Could I also have a copy of that code you've mentioned.
Or if you could tell how I can programmatically build connection pools. I suppose I have to create an instance of the MBean server and register some MBean class, and then I should be able to set pool properties. I'm not sure what MBean class I need to use for that purposes.
Thank you in advance,