Issue in fetching records from database using Hibernate

Question

The method shown below is not fetching data from db with the criteria strProductId. I'm getting the value of strProductId inside the method. Can anyone please help..Thanks in advance....

public List<ProductServices> getAllServices(String strProductId){
        Session session = sessionFactory.getCurrentSession();
        Criteria cr = session.createCriteria(ProductServices.class);
        cr.add(Restrictions.eq("productId", strProductId));
        return (List<ProductServices>) cr.list();
    }

you tryto get the value of strProductId inside the method and strProductId is here param, thast is strange. — Abdelhak
– Abdelhak, Commented Nov 19, 2015 at 7:35
yes i'm getting strProductId from service layer as parameter but is there any mistake while giving criteria — Bichu
– Bichu, Commented Nov 19, 2015 at 7:41

v.ladynev · Accepted Answer · 2015-11-19 08:47:27Z

1

Method getAllServices must be in a transaction. Check it, please.

Updated

You must open a transaction, do a request and close a transaction. It can be done by Spring of course. See this example. UserManagerImpl has a @Transactional annotation on methods.

edited Nov 19, 2015 at 8:47

answered Nov 19, 2015 at 7:46

v.ladynev

20.1k9 gold badges50 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Abdelhak · Accepted Answer · 2015-11-19 08:40:09Z

0

you can do some thing like this

Session session = factory.openSession();
Transaction tx = null;
try {
    tx = session.beginTransaction();
    Criteria cr = session.createCriteria(ProductServices.class);
    cr.add(Restrictions.eq("productId", strProductId));
    return (List<ProductServices>) cr.list();
      tx.commit();
     }
   catch (Exception e) {
      if (tx!=null) tx.rollback();
       e.printStackTrace(); 
  }finally {
  session.close();
 }

answered Nov 19, 2015 at 8:40

Abdelhak

8,4154 gold badges25 silver badges37 bronze badges

Collectives™ on Stack Overflow

Issue in fetching records from database using Hibernate

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related