Hello java fellows,

I was refactoring a web application where I was using JPA - Hibernate - MySql.

When I was testing the application I noticed the database connections were growing and growing.

I figured out that the entitymanager did not close the connections.

The problem was in this line of code :

EntityManagerFactory emf = Persistence.createEntityManagerFactory("databasename");

I was using this code in a function. It created a EntityManagerFactory at each execution of the function.

The solution was creating a singleton which needs to check if there already is an instance of the EntityManagerFactory. If there was an instance I needed to grab the instance instead of creating an new EntityManagerFactory.

The full explanation I found on this blog :

http://javanotepad.blogspot.com/2007/05/jpa-entitymanagerfactory-in-web.html

0 Comments