JPA-Unknown entity type error when i actually have the entity in my DB

[ambika mullasseri]

i have a table employee_details

i tried to fire the query

Query query = em.createQuery(queryString);

where queryString = select emp.Emp_Id from employee_details emp


exception in thread "main" java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1067)
at com.myoffice.hr.dao.Utils.Connection_Util.doSelection(Connection_Util.java:30)
at com.myoffice.hr.dao.Access_Employee_Detail.getEmployeeByName(Access_Employee_Detail.java:36)
at com.myoffice.hr.dao.Access_Employee_Detail.main(Access_Employee_Detail.java:44)
Caused by: Exception [EclipseLink-8034] (Eclipse Persistence Services - 1.1.2.v20090612-r4475): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Error compiling the query [select emp.Emp_Id from employee_details emp]. Unknown entity type [employee_details].


but when i try to insert using em.persist(obj);
the data is getting inserted,which means the connection is correct.

please help me regarding this.

[Vijitha Kumara]

Is your domain object (POJO) you are trying to query against named "employee_details" ?

[ambika mullasseri]

no it is

@Entity
@Table(name="employee_details")
public class Employee_detail

[Vijitha Kumara]

Then you should use "Employee_detail" in your query.

[ambika mullasseri]

Thanks a lot .i am just trying out JPA for the first time.You really helped me out.

[Vijitha Kumara]

no problem