MySQL database depending on user

[mhassel]

Our (ejb based) application is accessed by multiple clients. Each client is identified by a "username" (=licence number). Each client has its own database.
I would like to enable the JBoss installation to connect the ejb's to the right database depending on the clients licence number...

Any suggestions on how to do this????

[erich_lol]

Then you should maybe deploy one ear file per client. Each ear should then state the correct db to use.

[stedo]

hi,

Why not create a database to hold references to client databases (data sources), then just update the database and the datasource each time you get a new client.

Thanks
Steve