I access the database with the Entity Manager like this :

@PersistenceContext(unitName = "jobs")
protected EntityManager em;

public Collection<T_Jobs> getJobs() {
return em.createQuery("from T_Jobs").getResultList();
}

for example to retrieve the jobs, but Id like to do that on the database which I want.
I think at a solution, but I have to create a file -ds.xml fro each database (hence for each client). Then I have to write the list of -ds.xml file in my persistence.xml file.

I would have a number of fix database, that would be great, but that changes everytyme. Therefore, I have to find a best mean.

I know it, thanks anyway. :=)

Im trying to implement the ConnectionProvider interface Hibernate for using my connection pool with my databases. I have to know now how to update dynamically the entityManager with my ConnectionProvider. I cant use the @PersistanceContext annotation, I think.

Im going to look at this.

Thanks.