First of all, I don't have much JSF and JAVA experience. I'm a .NET developer.
What I need to do: I need to create a project, which use many (about 20 or 30) databases, but only one at the time. So user will choose which database - on first (login) page.
Every database is large (about 500 tables or more). But not exactly the same.
In .NET simple winforms application I will create provider class, which will use Devart to connect database (Oracle). Inside this provider I will do methods like "doQuery" or sth like that. All I have to do copy 2 dlls inside my project and declare 30 const connection strings.
How can I accomplish that task in JSF? Do I have to create every connection pool in Glassfish admin site?
Thanks for advice!
I use: Oracle 11 and JSF 2, Glasfish 3 in Netbeans 7.2