multiple datasources

[jack70_chen]

I am using SEAM, up to now, I think it's a great product comparing with anything i used before.

the question i'm asking is not directly related with SEAM, but I believe some of you must know the answer.

How can i make the EJB 3.0 entity beans access different datasources based on the user who login at runtime?

Right now my application servers different client, but each client has its own schema. Is there a way to dynamically assign the datasource to the entity beans at runtime based on the user?

thanks
Jack

[gavin.king]

Perhaps the best way to do this would be by using a custom Hibernate ConnectionProvider, and declaring that in persistence.xml.