Hi Reza,
First of all, thank for your reply.
This database architecture if from a legacy system, that we can't change right now.
We have some clients that just bought our product because we have this kind of infrastructury, I do not full agree with them, but I undertand.
About the management of those entityManagers, is it possible to do what I described in the first post?
I was thinking:
1) When the client logins, create a SFSB with the correct entityManager for this client.
2) When the client call another service(another EJB, stateful or not) this other EJB will take the correct entityManager from the SFSB(is it possible?How?) and then make what is necessary.
For me, appears to be a good approach, I know it can be not the better, but would solve my actual problem.
What do you think about it? Is it possbible?
Thanks for your time
[ November 21, 2008: Message edited by: Pedro Lobato Sena ]