Grails with more than one DB (changed dynamically)

[rodrigo]

Hello,

I am about to build an admin application which has to access different Oracle schemas(DBs) with the same structure. Can it be done? I saw the datasources plugin but it seems to be a static approach. Basically, what I need is the posiibility that the user can select from a combo box which DB he wants to work with, and change it every time he needs to.

Any ideas?

Thanks!!!

 

[dave]

Have a look at this link : http://www.leebutts.com/2008/07/switchable-grails-datasource.html It looks like it may provide you with what you need.