vikas27 vikas27 - 1 year ago 122
Java Question

Hibernate Return integer value

I am new to hibernate . I want to pass 2 column values and want hibernate to return primary key of that table.

String queryString = "select perId from Permission where document.docId=1 and";
return getHibernateTemplate().find(queryString);

But this method return List.
How can i return int value.

Answer Source

Use the uniqueResult() method in Query. see here for an example or read the api here.

Here is an example. Replace the place holders as need to use them.

    sessionFactory = getHibernateTemplate().getSessionFactory();
    Session session = sessionFactory.getCurrentSession();
    Query query = session
            .createQuery("select value from table where ...");
    query.setParameters("param1", value1);
    result = (Type) query.uniqueResult();
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download