Improvement of request Function

delildor · **Joined:** Wed Aug 11, 2010 10:35 am **Posts:** 2

Hello,

I would like to know if there is a way to improve performance of this request

Code:

    public static boolean existModule(String _name){
        sessionFactory = HibernateFactory.getSessionFactory();
        session = sessionFactory.getCurrentSession();
        transaction = session.beginTransaction();
        Query query = session.createQuery("select module.name from Module module where module.name = '" + _name + "'");
        boolean test = query.iterate().hasNext();
        return test;
    }

like for exemple, if i have understood this request instantiate an object. It is possible to don't instanciate this object and have the same result.

Best regards,

Florent.

PS: Sorry for my english, i'm french.

delildor · **Joined:** Wed Aug 11, 2010 10:35 am **Posts:** 2

Anybody can help me ???

shynate26 · **Posted:** Thu Aug 12, 2010 5:14 am

hi delidor,

public static boolean existModule(String _name){
sessionFactory = HibernateFactory.getSessionFactory();
session = sessionFactory.getCurrentSession();
transaction = session.beginTransaction();
return session.createQuery("select count(module.name) from Module module where module.name = '" + _name + "'").uniqueResult() > 0 ? true :false;
}

try this modified query!