Same application, different DS

[hykiukira]

hi all,

I know that there is already a lot of things about multiple ds in this forum, but i can't find what i need.
I have one application that i would like my clients to use but all with there own tables for security reason.(each client its database in MySql)
This would mean an entity bean should choice a different ds from one client to another.

Is there a way to achieve this,

Thank you

[milowe]

I remember we did some experiments in this field at some point.
The bean used BMP and the primary key included the database name. We used the same DS and each call to get a new connection included database and user, pass.

This was a test thing we did and it was never used in production (although it worked).

/micke

[hykiukira]

Thank you milowe.

But it would be nice if i could do it with CMP.
I don't know if it is possible to install one datasource by client, and to change dinamicaly the ds of the bean before playing with datas.