Hi,

In my Persistence Class, I have used

Session session = HibernateUtil.getSessionFactory().getCurrentSession();

in all the methods(save,get,update).

My main java class that calls this class has a call like
PersistenceManaget.get(parm1,parm2),
which calls Hibernate Util, and gets a session and then it goes to this PersistenceManager class. Queries take lot of time to run.
All my queries are written in hbm_xml.

Please suggest something...

use a profiler

Hi,

Following is my HibernateUtil.java class.


public class HibernateUtil
{
private static final SessionFactory sessionFactory;
private static String CONFIG_FILE_LOCATION = "cfg path";
private static final Configuration cfg = new Configuration();
static {
try {
// Create the SessionFactory from hibernate.cfg.xml
cfg.configure(CONFIG_FILE_LOCATION);
sessionFactory = cfg.buildSessionFactory();
System.out.println(sessionFactory);
} catch (Throwable ex) {
ex.printStackTrace();
// Make sure you log the exception, as it might be swallowed
System.err.println("Initial SessionFactory creation failed." + ex);
throw new ExceptionInInitializerError(ex);
}
}

public static SessionFactory getSessionFactory() {
return sessionFactory;
}

}



When the code comes to sessionFactory = cfg.buildSessionFactory(); line. It takes around 1 minute, which is a big issue.
How do I reduce this time? What exactly should be done, so that it takes few seconds...

hi pams,

once application run you are not going to rerun that code .It is in static block. It should not be very big issue.

Yes true, but in my PersistenceManager class:
Session session = HibernateUtil.getSessionFactory().getCurrentSession();

is there, to fetch the session, but it also takes time.... In all, to run a single query which can be run in AS400 in seconds, here it takes 1.30 mins.. which you see isa long time..

In my hbm.xml, I have composite Ids but the database mapping is missing, I want to set lazy="true". Can u suggest me as to how can I give
that without mapping?? I mean, is it possible??

Hi,

As you know, all my queries are in hbm.xml and in my main class,
I simply call PersistenceManager.get(parm1,parm2), in which I have
used
Query q1 = session.getNamedQuery("QueryName");

List result = q1.list();

This list internally calls nullSafeSet and nullsafeget methods of
my user created type class. Whenever, it reaches:

nullSafeSet : it takes 389 milliseconds
nullsafeGet : 406 milliseconds
finally result : 389 milliseconds

In all more than 1 second, which is quite high...
Please help me out as to how to tackle with this problem......

Hi,

As you know, all my queries are in hbm.xml and in my main class,
I simply call PersistenceManager.get(parm1,parm2), in which I have
used
Query q1 = session.getNamedQuery("QueryName");

List result = q1.list();

This list internally calls nullSafeSet and nullsafeget methods of
my user created type class. Whenever, it reaches:

nullSafeSet : it takes 389 milliseconds
nullsafeGet : 406 milliseconds
finally result : 389 milliseconds

In all more than 1 second, which is quite high...
Please help me out as to how to tackle with this problem......