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

[Ankur Sharma]

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

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 
<hibernate-mapping>
<class name="events.Person" table="PERSON"
discriminator-value="P">
<id name="id" column="PERSON_ID">
<generator class="native" />
</id>
<property name="age" />
<property name="firstname" />
<property name="lastname" />
<property name="byteData" type="blob" column="BYTE_DATE" />
<component name="event" class="events.Event">
<property name="date" type="timestamp" column="EVENT_DATE" />
<property name="title" column="TITLE" />
</component>
</class>
</hibernate-mapping>

Event.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 
<hibernate-mapping>
<class name="events.Event" table="person">
<id name="id" column="EVENT_ID">
<generator class="native" />
</id>
<property name="date" type="timestamp" column="EVENT_DATE" />
<property name="title" />
</class>
</hibernate-mapping>

Hibernate Configuration File (hibernate.cfg.xml)

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
 
<hibernate-configuration>
 
<session-factory>
 
<!-- Database connection settings -->
<property name="connection.driver_class">
com.mysql.jdbc.Driver
</property>
<property name="connection.url">
jdbc:mysql://localhost:3306/hibernate
</property>
<property name="connection.username">root</property>
<property name="connection.password">walgreens</property>
 
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>
 
<!-- SQL dialect -->
<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>
 
<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>
 
<!-- Disable the second-level cache  -->
<property name="cache.provider_class">
org.hibernate.cache.NoCacheProvider
</property>
 
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
 
<!-- Posible values for hbm2ddl.auto (update | create | create-drop)-->
<property name="hbm2ddl.auto">create-drop</property>
<property name="hibernate.query.factory_class">
org.hibernate.hql.classic.ClassicQueryTranslatorFactory
</property>
<mapping resource="events/Event.hbm.xml" />
<mapping resource="events/Person.hbm.xml" />
</session-factory>
 
</hibernate-configuration>

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

private List listEvents() {
Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
List result = session.createQuery("from PERSON").list();
session.getTransaction().commit();
return result;
}

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]

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:

from Person

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

[mohamed yousuf]

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:

from Person

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

thank you jai....im also faced same issue solved now....

[bikramjit mandal]

Thanks this was just what I also faced and its solved! Thanks a lot Jai!