Hibernate version 3.2

i have 3 tables and a single pojo is mapped with three in hbm.file with entity-name defined as ::

<class name="com.hr.dto.CandidateRecruitmentDTO" table="TB_SOFT_INTRV_DETAILS" entity-name="softwareObject">

<class name="com.hr.dto.CandidateRecruitmentDTO" table="TB_SOFT_INTRV_DETAILS" entity-name="bpoObject">

<class name="com.hr.dto.CandidateRecruitmentDTO" table="TB_SOFT_INTRV_DETAILS" entity-name="othersObject">

How to fetch data from table based on entity-name as defined in hbm.file. I am using the following qury in DAO class:
recruitmentlist = session.createSQLQuery(" FROM NewCandidateRecruitmentDTO as e").addEntity("softwareObject", NewCandidateRecruitmentDTO.class).list();

Its throwing exception ::: org.hibernate.MappingException: Unknown entity: com.ebix.hrms.dto.CandidateRecruitmentDTO
help me out.....

There are several problems with your code.

First, when you are using createSQLQuery() the query string must be a valid SQL. You need SELECT ... FROM <table-name>. For example



Second, when you call addEntity() you should only specify the entity-name not the class. For example:

Thanks a lot :-) ... nordborg. It was helpfull.