plz see the hql query ....let me whether its is correct

pnirala · **Joined:** Wed Sep 10, 2008 1:52 am **Posts:** 2

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

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

Code:

select pcb.strEmpId,pcb.nCurrentBasic from PisEmpCurrentBean pcb,AppointmentBean abo where pcb.nStatus=? and pcb.strLocationId=? and pcb.nCurrPayfixationSeqNo is not null and pcb.strObsDate is null"+
         " and (getdate() >= (select DATEAdd(mm,6,ab.strJoiningDate) from AppointmentBean ab"+
         " where ab.strEmpNo in(select pcbi.strEmpId from PisEmpCurrentBean pcbi where pcbi.nStatus=? and pcbi.strLocationId=? and pcbi.nCurrPayfixationSeqNo is not null and pcbi.strObsDate is null and ab.strEmpNo=pcbi.strEmpId))) and (abo.strEmpNo=pcb.strEmpId) 

Cameron McKenzie · **Posted:** Wed Sep 10, 2008 9:45 am

What is the problem you are getting?