Hibernate error – QuerySyntaxException: users is not mapped [from users]

by

In the HQL , you should use the java class name and property name of the mapped @Entity instead of the actual table name and column name , so the HQL should be :

List<User> result = session.createQuery("from User", User.class).getResultList();

Update : To be more precise , you should use the entity name configured in @Entity to refer to the “table” , which default to unqualified name of the mapped java class if you do not set it explicitly.

(P.S. It is @javax.persistence.Entity but not @org.hibernate.annotations.Entity)

More Related Contents:

  1. What are the possible values of the Hibernate hbm2ddl.auto configuration and what do they do
  2. PersistentObjectException: detached entity passed to persist thrown by JPA and Hibernate
  3. What’s the difference between JPA and Hibernate? [closed]
  4. How to convert a Hibernate proxy to a real entity object
  5. Hibernate Error: org.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session
  6. What is the solution for the N+1 issue in JPA and Hibernate?
  7. Is it possible to use raw SQL within a Spring Repository
  8. JPA CascadeType.ALL does not delete orphans
  9. What is the proper way to re-attach detached objects in Hibernate?
  10. Solve Hibernate Lazy-Init issue with hibernate.enable_lazy_load_no_trans
  11. Configure hibernate (using JPA) to store Y/N for type Boolean instead of 0/1
  12. Using Hibernate’s ScrollableResults to slowly read 90 million records
  13. How do we count rows using older versions of Hibernate (~2009)?
  14. Hibernate criteria: Joining table without a mapped association
  15. what is @JoinColumn and how it is used in Hibernate
  16. JPA eager fetch does not join
  17. How can I get the session object if I have the entity-manager?
  18. No Dialect mapping for JDBC type: 1111
  19. Hibernate one-to-one: getId() without fetching entire object
  20. Using javafx.beans properties in model classes
  21. Hibernate/persistence without @Id
  22. Spring Data JPA: Batch insert for nested entities
  23. Hibernate could not fetch the SequenceInformation from the database
  24. Hibernate: Where do insertable = false, updatable = false belong in composite primary key constellations involving foreign keys?
  25. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed
  26. Error “java.lang.NoSuchMethodError: org.jboss.logging.Logger.getMessageLogger”
  27. spring data jpa @query and pageable
  28. Hibernate Error: a different object with the same identifier value was already associated with the session
  29. How to use DTO in JSF + Spring + Hibernate
  30. How to use JTA support in Tomcat 6 for Hibernate?

Leave a Comment