Hello,

What is the right way to do connection pooling in a J2SE environment with JPA.

I know the normal way to get an EntityManager and that it is not thread save:


Unfortunately I couldn't find much more about connection pooling.

Any pointers are appreciated.

Hi,

I do not understand what your example has to to with connection pooling, but generally the question is in which environment you are running. If, for example, you are using JPA within a managed container and the access to the datasource is via a JNDI setup, then it is a question of configuring the container managed datasource properly in order to use a connection pool. If you are not running within a container or you want to manage your connection pooling via hibernate you can just add the appropriate hibernate configuration options to you config file. Have a look at this: http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#configuration-hibernatejdbc.

Hope this helps.

--Hardy