Hello everybody,

I am developing an application using Jboss and Hibernate 3.1, and I have lots of problems because my system JVM heap gets full after some minutes of loadtests.

I have profiled the memory of jboss and I have realized that class org.hibernate.hql.QueryTranslator is instantiating, and instances of the class are never deallocaed from memory.

Do you have any idea, what could be the problem ?

Are you closing the session after each test?

Yes, this is the Code :

public List<Iatrigger2channel> listIatrigger2channelByPlatformNotExpired(String itvplat_fk, String channelfid) throws HibernateException {

Session session = null;
try {

session = sessionFactory.openSession();
String sQuery = "FROM Iatrigger2channel WHERE 1=1 AND ITVPLAT_FK ="+itvplat_fk+" AND CHANNELFUNCTIONALID='"+channelfid+"'";
java.sql.Timestamp timestamp = getCurrentJavaSqlTimestamp();
sQuery+=" AND VALIDFROM <= '" + timestamp + "' AND '" + timestamp + "' <= VALIDTO";
log.debug("listIatrigger2channelByPlatformNotExpired.sQuery: " + sQuery);
Query query = session.createQuery(sQuery);

if ( query != null )
{
query.setMaxResults(10);

}

List<Iatrigger2channel> result = query.list();


session.close();
return result;

} catch (HibernateException e) {
throw e;
}
}

poor use of exceptions.
add the session.close(); to a finally{} block

I change the code to this, but still the QueryTranslator stucks in memory !!!

public List<Iatrigger2channel> listIatrigger2channelByPlatformNotExpired(String itvplat_fk, String channelfid) throws HibernateException {

Session session = null;
try {

session = sessionFactory.openSession();
log.debug("Opening Session for Hibernate");
String sQuery = "FROM Iatrigger2channel WHERE 1=1 AND ITVPLAT_FK ="+itvplat_fk+" AND CHANNELFUNCTIONALID='"+channelfid+"'";
java.sql.Timestamp timestamp = getCurrentJavaSqlTimestamp();
sQuery+=" AND VALIDFROM <= '" + timestamp + "' AND '" + timestamp + "' <= VALIDTO";
log.debug("listIatrigger2channelByPlatformNotExpired.sQuery: " + sQuery);
Query query = session.createQuery(sQuery);

if ( query != null )
{
query.setMaxResults(10);

}

List<Iatrigger2channel> result = query.list();


//session.close();
//log.debug("Closing Session for Hibernate");
return result;

} catch (HibernateException e) {
throw e;
} finally {
if (session != null){
try {
session.close();
log.debug("Closing Session for Hibernate");
} catch ( HibernateException ignore) {
// Ignore
}
}
}
}

The problem is related with the compilation of HQL, I will open a new thread about this problem