Hi friends,
I have implemented custom-sql queries in osgi module LR7.in *finderImpl class i am using openSession() but am getting NullpointerException in openSession().
Session session = null;
try{
session = openSession(); // here Null pointer exception
String sql = CustomSQLUtil.get(getClass(),FETCH_DATA_FOR_CAROSIL);
SQLQuery query = session.createSQLQuery(sql);
query.setCacheable(false);
query.addEntity("Test", TestImpl.class);
QueryPos pos = QueryPos.getInstance(query);
pos.add(storeId);
pos.add(deltaPeriod);
return (List<Order>)query.list();
}catch(Exception e){
throw new SystemException(e);
}
finally{
/
closeSession(session);
}
any one have idea about this?
