[eclipselink-users] Using Connection Pools across sessions

[Rohit Banga <rohit.banga@xxxxxxxxxx>]

Hi All

Consider the following usecase.
I have a single database for which multiple table configurations have been defined. Each different configuration is associated with a different Server Session. From the server session, I get the entity manager factory which gives me a JPA Dynamic Helper. So far so good, but I want to have a single connection pool and share it among different sessions. If I share the same connection pool object between multiple server session objects, I get some exceptions because of the conflicting configuration definition.

What is the standard way of sharing the connection pool across different sessions?

--
Thanks and Regards
Rohit Banga
Member Technical Staff
Oracle Server Technologies