JPA mapping QuerySyntaxException foobar is not mapped

Question

I ve been playing around with a very simple JPA example and am trying to tweak it to an existing database   But I can t get past this error    Below    It just has to be some simple thing I am not seeing   org hibernate hql internal ast QuerySyntaxException  FooBar is not mapped  SELECT r FROM FooBar r    org hibernate hql internal ast util SessionFactoryHelper requireClassPersister SessionFactoryHelper java 180    org hibernate hql internal ast tree FromElementFactory addFromElement FromElementFactory java 110    org hibernate hql internal ast tree FromClause addFromElement FromClause java 93    In the DocumentManager class below  a simple servlet  as that is my target goal  does two things    insert a row return all rows   The insertion works perfectly--all is good there   The problem is with the retrieval   I ve tried all sorts of values for the Query q   entityManager createQuery parameters  but no luck  and I ve tried variously more explicate annotations of the class  like column types   all without success   Please save me from myself   I m certain it is something small   My inexperience with JPA is preventing me from going any farther   My   src ch geekomatic jpa FooBar java file    Entity  Table  name    foobar    public class FooBar        Id       GeneratedValue strategy GenerationType IDENTITY        Column name  id       private int id        Column name  rcpt who       private String rcpt who        Column name  rcpt what       private String rcpt what        Column name  rcpt where       private String rcpt where       public int getId             return id            public void setId int id            this id   id             public String getRcpt who             return rcpt who            public void setRcpt who String rcpt who            this rcpt who   rcpt who               snip   the other getters setters are here     My   src ch geekomatic jpa DocumentManager java class  public class DocumentManager extends HttpServlet       private EntityManagerFactory entityManagerFactory   Persistence createEntityManagerFactory   ch geekomatic jpa          protected void tearDown   throws Exception           entityManagerFactory close               Override    public void doGet HttpServletRequest request  HttpServletResponse response  throws IOException  ServletException          FooBar document   new FooBar           document setRcpt what  my what           document setRcpt who  my who            persist document           retrieveAll response            public void persist FooBar document           EntityManager entityManager   entityManagerFactory createEntityManager           entityManager getTransaction   begin           entityManager persist  document           entityManager getTransaction   commit           entityManager close              public void retrieveAll HttpServletResponse response  throws IOException           EntityManager entityManager   entityManagerFactory createEntityManager            entityManager getTransaction   begin                     PROBLEM LINE             Query q   entityManager createQuery   SELECT r FROM foobar r   FooBar class            List lt FooBar gt  result   q getResultList             for   FooBar doc   result                 response getOutputStream   write event toString   getBytes                 System out println   Document     doc getId                         entityManager getTransaction   commit            entityManager close              The  tomcat-home  webapps ROOT WEB-INF classes METE-INF persistance xml file   lt persistence xmlns  http   java sun com xml ns persistence      xmlns xsi  http   www w3 org 2001 XMLSchema-instance      xsi schemaLocation  http   java sun com xml ns persistence http   java sun com xml ns persistence persistence 2 0 xsd      version  2 0  gt    lt persistence-unit name  ch geekomatic jpa  gt       lt description gt test stuff for dc lt  description gt        lt class gt ch geekomatic jpa FooBar lt  class gt        lt properties gt           lt property name  javax persistence jdbc driver    value  com mysql jdbc Driver    gt           lt property name  javax persistence jdbc url       value  jdbc mysql   svr 3306 test    gt           lt property name  javax persistence jdbc user      value  wafflesAreYummie    gt           lt property name  javax persistence jdbc password  value  poniesRock    gt            lt property name  hibernate show sql      value  true    gt           lt property name  hibernate hbm2ddl auto  value  create    gt       lt  properties gt    lt  persistence-unit gt   lt  persistence gt    The MySQL table description   mysql gt  describe foobar   ------------ -------------- ------ ----- --------- ----------------    Field        Type           Null   Key   Default   Extra             ------------ -------------- ------ ----- --------- ----------------    id           int 11         NO     PRI   NULL      auto increment     rcpt what    varchar 255    YES          NULL                         rcpt where   varchar 255    YES          NULL                         rcpt who     varchar 255    YES          NULL                        ------------ -------------- ------ ----- --------- ----------------  4 rows in set  0 00 sec

User · Answer

You have declared your Class as    Table  name    foobar    public class FooBar     You need to write the Class Name for the search  from FooBar

User · Answer

JPQL mostly is case-insensitive  One of the things that is case-sensitive is Java entity names  Change your query to    SELECT r FROM FooBar r

User · Answer

There is also another possible source of this error  In some J2EE   web containers  in my experience under Jboss 7 x and Tomcat 7 x  You have to add each class You want to use as a hibernate Entity into the file persistence xml as    lt class gt com yourCompanyName WhateverEntityClass lt  class gt   In case of jboss this concerns every entity class  local - i e  within the project You are developing or in a library   In case of Tomcat 7 x this concerns only entity classes within libraries

User · Answer

I got the same error while using other one entity  He was annotating the class wrongly by using the table name inside the  Entity annotation without using the  Table annotation  The correct format should be   Entity   default name similar to class name  FooBar  OR  Entity  name    foobar    for differnt entity name  Table  name    foobar       Table name  public class FooBar

[java] JPA mapping: "QuerySyntaxException: foobar is not mapped..."

Examples related to java

Examples related to mysql

Examples related to hibernate

Examples related to jpa