Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp




StringBuffer clause1=new StringBuffer();
StringBuffer clause2=new StringBuffer();
List changeLogList =null;
List changeLogList1 = null;
String sortBy=form.getSortBy();
String listOrder=form.getListOrder();
String arItemSkey=form.getArItemSkey();
hibSession = HibernateUtil.getSessionFactory().openSession();

clause1.append("select new fit.gdms.viewbeans.AritemChgLogDTO(u.userEmail,TimeStamp(ar.lastUpdTs),ar.chgItem,ar.oldChgValue,ar.newChgValue) from fit.gdms.schemadao.AritemChgLog ar,fit.gdms.schemadao.UserAccProfile u where ar.arItem.arItemSkey ="+arItemSkey+" and ar.lastUpdId=u.user.userCnum ");
clause2.append(" select new fit.gdms.viewbeans.AritemChgLogDTO(u.userEmail,TimeStamp(fr.lastUpdTs),fr.chgItem,fr.oldChgValue,fr.newChgValue) from fit.gdms.schemadao.FcstChgLog fr,fit.gdms.schemadao.UserAccProfile u where fr.forecast.arItem.arItemSkey ="+arItemSkey+" and fr.lastUpdId=u.user.userCnum ");

changeLogList1 = hibSession.createQuery(new String(clause1)).list();
changeLogList = hibSession.createQuery(new String(clause2)).list();
-------------------------------------------------------------------------------------


here Hibernate exception is raising at..here
changeLogList = hibSession.createQuery(new String(clause2)).list();

But changeLogList1 = hibSession.createQuery(new String(clause1)).list();
is working


DB2 8.1 is the database


How can I solve this ?Expecting the immediate reply

If you don't post the exception you are getting nobody will be able to help you.

BTW:
- Why do you use a StringBuffer when you do String concatenation inside the append methods?

- ALWAYS use Bind variables !!

I got the ans. clause2 sytax was not correct .(associated with table relations).