Hibernate table not mapped error in HQL query

by

The exception message says:

Books is not mapped [SELECT COUNT(*) FROM Books]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: Books is not mapped [SELECT COUNT(*) FROM Books]

Books is not mapped. That is, that there is no mapped type called Books.

And indeed, there isn’t. Your mapped type is called Book. It’s mapped to a table called Books, but the type is called Book. When you write HQL (or JPQL) queries, you use the names of the types, not the tables.

So, change your query to:

select count(*) from Book

Although I think it may need to be

select count(b) from Book b

If HQL doesn’t support the * notation.

More Related Contents:

  1. java.lang.ClassCastException: java.lang.String cannot be cast to
  2. How to solve the “failed to lazily initialize a collection of role” Hibernate exception
  3. How do I use annotations to define different types of relationships in Hibernate 4 and Spring?
  4. Bypass GeneratedValue in Hibernate (merge data not in db?)
  5. What is the proper way to re-attach detached objects in Hibernate?
  6. How does the FetchMode work in Spring Data JPA
  7. In which case do you use the JPA @JoinTable annotation?
  8. No Dialect mapping for JDBC type: 1111
  9. Transaction marked as rollback only: How do I find the cause
  10. Transactional saves without calling update method
  11. Hibernate could not fetch the SequenceInformation from the database
  12. Do you need a database transaction for reading data?
  13. Java / Hibernate – Write operations are not allowed in read-only mode
  14. Manually call Spring Annotation Validation
  15. Difference between save and saveAndFlush in Spring data jpa
  16. The onFlushDirty Hibernate Interceptor method is never called
  17. spring data jpa @query and pageable
  18. compatibility of spring 4.0.0 with hibernate 4.30 [duplicate]
  19. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  20. Hibernate throws strange error: Class is not mapped
  21. Why HibernateTemplate isn’t recommended? [duplicate]
  22. HibernateException: Couldn’t obtain transaction-synchronized Session for current thread
  23. Error creating bean with name ‘entityManagerFactory
  24. Hibernate: CRUD Generic DAO
  25. Mapping JPA or Hibernate projection query to DTO (Data Transfer Object)
  26. org.hibernate.loader.MultipleBagFetchException: cannot simultaneously fetch multiple bags
  27. org.dbunit.dataset.NoSuchTableException: Did not find table ‘xxx’ in schema ‘null’
  28. Autowired Repository is Null in Custom Constraint Validator
  29. Registering a SQL function with JPA and Hibernate
  30. TransactionRequiredException Executing an update/delete query

Leave a Comment