• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1155
  • Last Modified:

Hibernate connection memory leak problem

Opening a session using a Hibernate SessionFactory is using lots of memory. Even when the session is closed the allocated memory doesn’t reduce. We observed, using the JProfiler/CPU tab view, that the buildSessionFactory used about 30% of the CPU time. This particular behavior is approximately similar in Hibernate 3.2.4, 3.3.1 and 3.5.4. We tested using the attached code.

Even this simple test used up HUGE memory.


public void useSession(String database)

throws Exception {

	Session session = null;

	try {

		Configuration myConfig = new  Configuration().setProperty(

					CONNECTION_DRIVER, SYBASE_DRIVER).setProperty(

					CONNECTION_DIALECT, SYBASE_DIALECT).setProperty(CONNECTION_URL,

					CommonConfiguration.get(database + CC_URL))

					.setProperty(CONNECTION_USERNAME,

									CommonConfiguration.get(CC_SYBASE_USER_ID))

					.setProperty(CONNECTION_PASSWORD,

									CommonConfiguration.get(CC_SYBASE_PASSWORD))

					.setProperty(CONNECTION_POOL_SIZE, ZERO).setProperty(

									CONNECTION_HOW_SQL, TRUE);



				SessionFactory factory = myConfig.buildSessionFactory();

				session = factory.openSession();

		}

		finally {

			if (session != null) {

					session.close();

			}

		}                               

	}

Open in new window

0
M_SYED
Asked:
M_SYED
  • 2
1 Solution
 
HegemonCommented:
Not clear what your question is. Yes, SessionFactory is a heavyweight and slow object and you normally create it only once. It consumes a lot of memory as it uses a number of libraries.

". Even when the session is closed the allocated memory doesn’t reduce. "

That's [almost] correct, SessionFactory should be kept in memory once built. However, Session objects are GC'd after closing and going out of scope.
0
 
sandeep1984Commented:
You are creating session factory for every request which is wrong. This is a costly operation and need to be performed only once, and the same session factory should be used thereafter.

A sample util which will create session factory once. could be tweaked based on your needs.

http://www.koders.com/java/fid9CBB4F8729E37C58C6D34C7C5E0583BA9D0450D3.aspx?s=O#L3
0
 
M_SYEDAuthor Commented:
Thank you for the comments.

We are in the process of reviewing and rewriting our code to ensure that SessionFactory is reused when possible.

I will keep this thred updated with the results.
0
 
M_SYEDAuthor Commented:
I had to do more research but the basic premise pointed out by the response was accurate.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now