Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

HIBERNATE hql.ast.QuerySyntaxException: (table name) is not mapped

 
Shaan Shar
Ranch Hand
Posts: 1249
Java Spring Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi I am receiving the above problem. Here are my configuration files.

Exception name is "org.hibernate.hql.ast.QuerySyntaxException: <table name> is not mapped"

person.hbm.xml



Event.hbm.xml


Hibernate Configuration File (hibernate.cfg.xml)



And here is the code I am using to get the data of Person table


And table structure I am using is

Field Type Collation Null Key
---------- ------------ ----------------- ------ ------
PERSON_ID bigint(20) (NULL) NO PRI
age int(11) (NULL) YES
firstname varchar(255) latin1_swedish_ci YES
lastname varchar(255) latin1_swedish_ci YES
BYTE_DATE blob (NULL) YES
EVENT_DATE datetime (NULL) YES
TITLE varchar(255) latin1_swedish_ci YES


Please let me know if you need some more details.
[ May 19, 2008: Message edited by: Ankur Sharma ]
 
Jaikiran Pai
Marshal
Pie
Posts: 10447
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
List result = session.createQuery("from PERSON").list();


Remember that when you write HQLs, you don't refer to the table or its columns. Instead you use the mapped class and their properties. In your example, you have mapped PERSON table to events.Person, so your HQL should be:


[ May 20, 2008: Message edited by: Jaikiran Pai ]
 
mohamed yousuf
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Jaikiran Pai:


Remember that when you write HQLs, you don't refer to the table or its columns. Instead you use the mapped class and their properties. In your example, you have mapped PERSON table to events.Person, so your HQL should be:



[ May 20, 2008: Message edited by: Jaikiran Pai ]


thank you jai....im also faced same issue solved now....
 
bikramjit mandal
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks this was just what I also faced and its solved! Thanks a lot Jai!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic