Hello everybody,

I am developing a application using hibernate 3.1, and my OldGen memory in the JVM is inscreasing till the system gets collapsed.

I have found that the problem is relared to Lists in Hibernate ( query.list(); ).

Any of you know how can I find out a solution to the problem ?

This is my code :

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

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

session.clear();
session.close();
-----------------------------------------------------------------------------------

How many associations does your channel object have? Are they configured to be loaded lazily or eagerly?
Have you considered pagination?

This is my object channel !!!

public class channel implements java.io.Serializable {


// Fields

private static final long serialVersionUID = -1707963982593947373L;
private Long id;
private Iatrigger iatrigger;
private Itvplat itvplat;
private String channelfunctionalid;
private Date validfrom;
private Date validto;

Where iatrigger and itvplat are other objects !!!

This is the association you mean ?

About lazy or eagerly?

Can you tell me more details please ?

Thanks !

You can configure your associations to be loaded lazily i.e. they will be loaded only when they are accessed. Example

Example:

class A{
B b;
}

class B{
C c;
}

***********************************************
something like this in mapping for class A

<set name="b" cascade="save-update" lazy="true">.
************************************************


*************************************************
something like this in mapping for class B
<set name="c" cascade="save-update" lazy="true">.
*************************************************

The fact that I don´t use lazily, can be the cause of I have such a big consunption of memory in my application ?