error in running HQL Query

[madhuri kunchala]

hi,
i tried the example for Hibernate what is given in Netbeans site..i had done step-by-step what they had said in that site...but im getting error while running HQL Query...here is the error im getting if i had given 'from Film'..the error im getting is

org.hibernate.hql.ast.QuerySyntaxException: Film is not mapped [from Film]
	at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:158)
	at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:87)
	at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:70)
	at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:255)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3056)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2945)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
	at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228)
	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160)
	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)

can anyone help me out why im getting that error..im new to Hibernate.

thanks,
madhu.

[madhuri kunchala]

i tired once again building the application..im facing the same problem can anyone suggest me why im getting that error.

[Prasad Krishnegowda]

I guess Film is not mapped, can you please post your hibernate.cfg.xml and .hbm.xml files and the query which you are trying to execute..

[madhuri kunchala]

hi prasad,
i tried with another db that is present in mysql...eventhough im getting same error..here is the following hibernate xml files.
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>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/project</property>
    <property name="hibernate.connection.username">root</property>
    <property name="hibernate.connection.password">root</property>
    <property name="hibernate.show_sql">true</property>
    <property name="hibernate.current_session_context_class">thread</property>
    <mapping resource="testdb/User.hbm.xml"/>
  </session-factory>
</hibernate-configuration>

User.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">
<!-- Generated Aug 25, 2010 1:10:04 PM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
    <class name="testdb.User" table="user" catalog="project">
        <id name="id" type="string">
            <column name="id" length="4" />
            <generator class="assigned" />
        </id>
        <property name="username" type="string">
            <column name="username" length="25" />
        </property>
        <property name="pswd" type="string">
            <column name="pswd" length="8" />
        </property>
        <property name="name" type="string">
            <column name="name" length="25" />
        </property>
        <property name="gprs" type="java.lang.Integer">
            <column name="gprs" />
        </property>
        <property name="act" type="string">
            <column name="act" length="5" />
        </property>
        <property name="state" type="string">
            <column name="state" length="20" />
        </property>
    </class>
</hibernate-mapping> 

and im giving query in HQL Query as from user can you check it..and provide me where the code gets wrong.

thanks,madhu.

[Prasad Krishnegowda]

Query should be 'from User'.. Note in User, 'U' should be caps...

[madhuri kunchala]

hi Prasad,
i had done modification what you suggested..i got it..thanks a lot..

[madhuri kunchala]

in HQL Query window....is it restricted to give only one query or more than that...because...i m facing problem if i enter more than one query..if im giving one query..it is working fine..but under that query i had given another query..it is showing error.In HQL Query i had given like this
from User as user where user.name like 'k%'
from User
if i given like this im getting error as

org.hibernate.hql.ast.QuerySyntaxException: unexpected token: from near line 2, column 1 [from testdb.User as user where user.name like 'k%'
from testdb.User]
	at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)
	at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)
	at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
	at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:258)
	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)
	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)

thanks,
madhu.

[Prasad Krishnegowda]

change the query to from User as user where user.name like 'k%'.. Note no need to from User again at the end.. it should work..

[madhuri kunchala]

hi Prasad,
i got what you had said...but my doubt is..if i m using more than one query in HQL Query0 it is showing error..here im providing what i had given in HQL Query0 is

from User  where name like 'k%'
from User where id between 1 and 5

if i had given like that in HQL Query Editor..im getting error

org.hibernate.hql.ast.QuerySyntaxException: unexpected token: from near line 2, column 1 [from testdb.User  where name like 'k%'
from testdb.User where id between 1 and 5
]
	at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)
	at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)
	at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
	at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:258)
	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)
	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)

is there any restriction or rule that only one query should be there in HQL Query0 Editor.

[Prasad Krishnegowda]

oh.. now i understood.. but, you cannot give more than one query..

[madhuri kunchala]

k.i think this may be some disadvantage for HQL Query Editor...everytime user need to clear what ever query entered and type new query..thanks for the info you provided...

[madhuri kunchala]

suppose if we want to execute query we need to write coding in Java file or in HQL Query0 Editor can you suggest me..

[Prasad Krishnegowda]

I suggest to write in java file.. and once in HQL query editor can you check by giving semicolon(;) at the end of each query..

[madhuri kunchala]

i had given semicolon at the end of each query...here is what i coded in HQL Query0 Editor...
from User where id between 1 and 5;
from User;
im getting error as

org.hibernate.QueryException: unexpected char: ';' [from testdb.User where id between 1 and 5;
from User;

]
	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:204)
	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)

according to you if i wrote the query in java file...then how we can execute that query...

[Prasad Krishnegowda]

In the java file, first you need to get the SessionFactory object, open the session and use session.createQuery for excecuting the query..

[madhuri kunchala]

k.i'll try it

[madhuri kunchala]

hi good morning,
i am facing same problem again...unable to execute my query...i had done using the DB which is present in my system...im getting error as

org.hibernate.hql.ast.QuerySyntaxException: Emp is not mapped [from Emp]
	at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:158)
	at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:87)
	at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:70)
	at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:255)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3056)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2945)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
	at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228)
	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160)
	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)

in HQL Query0 i had given as 'from Emp'...here is the 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>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/project</property>
    <property name="hibernate.connection.username">root</property>
    <property name="hibernate.connection.password">root</property>
    <property name="hibernate.show_sql">true</property>
    <property name="hibernate.current_session_context_class">thread</property>
    <mapping resource="testHibernate/Emp.hbm.xml"/>
  </session-factory>
</hibernate-configuration> 

and my Emp.hbm.xml is

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Aug 26, 2010 11:34:42 AM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
    <class name="testHibernate.Emp" table="emp" catalog="project">
        <id name="empId" type="string">
            <column name="emp_id" length="20" />
            <generator class="assigned" />
        </id>
        <property name="pwd" type="string">
            <column name="pwd" length="10" not-null="true" />
        </property>
        <property name="name" type="string">
            <column name="name" length="50" not-null="true" />
        </property>
        <property name="gen" type="string">
            <column name="gen" length="7" not-null="true" />
        </property>
        <property name="phno" type="java.lang.Integer">
            <column name="phno" />
        </property>
        <property name="address" type="string">
            <column name="address" length="100" not-null="true" />
        </property>
        <property name="qlfy" type="string">
            <column name="qlfy" length="20" not-null="true" />
        </property>
        <property name="doj" type="date">
            <column name="doj" length="10" not-null="true" />
        </property>
        <property name="desg" type="string">
            <column name="desg" length="20" not-null="true" />
        </property>
        <property name="dept" type="string">
            <column name="dept" length="100" not-null="true" />
        </property>
    </class>
</hibernate-mapping> 

yesterday it worked fine...i deleted that file and again i had done freshly...i used NetBeans6.9.1..may i know why im getting that problem.

thanks,
madhu.

[madhuri kunchala]

i tried by running the project and Run HQL Query it is getting executed....i had doubt is it necessary to run the project for execution of the query...any help regarding this...

[Prasad Krishnegowda]

First the project should be executed, then only the hibernate.cfg.xml will be loaded and the necessary mappings will be done.

[madhuri kunchala]

k..can you provide me information how to insert values in HQL Query0 Editor..is it possible or not..

[madhuri kunchala]

any help regarding my post

[madhuri kunchala]

i had searched and found the insert command in one of the sites...i applied in my application...but it is showing errors..i used as insert into Test1 (tid, tname) select oo.tid, oo.tname from Test1 oo and im getting error in 'Result' as

 org.hibernate.hql.QueryExecutionRequestException: Not supported for DML operations [insert into Test1 (tid, tname) select oo.tid, oo.tname from test.Test1 oo]
	at org.hibernate.hql.ast.QueryTranslatorImpl.errorIfDML(QueryTranslatorImpl.java:272)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:321)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)

and in SQL im getting as 'null'
can anyone suggest me how to do..here is my java file where i wrote insert commandtest.java code

package test;
import org.hibernate.Query;
import org.hibernate.Session;
public class test {
    Session session = null;
    public test() {
        this.session = HibernateUtil.getSessionFactory().getCurrentSession();
        Query q = session.createQuery("insert into test1(tid,tname)"+ "select tid,tname from backup_stock");
        int result = q.executeUpdate();
        System.out.println("Result "+result);
    }
}

thanks,
madhu.

[Jagadeeswara Yaramala]

I think you have taken the query example from this page.

The given query works fine for me.

You have to notice that the HQL query needs to have the class names (not the database table names and fields).
And also you need to map the entity classes (Test1, BackupStock) to the database tables using proper hibernate mapping files.
Also, the transaction start and end is required for the insert to become effective in the database.


Here is the code snippet that works for me.

   
            SessionFactory factory = cfg.buildSessionFactory();
		Session session = factory.openSession();
		//starting a transaction
		Transaction tx = session.beginTransaction();
		Query q = session.createQuery("insert into Test1(tid,tname)"+ "select tid,tname from BackupStock");  
		System.out.println(q.toString());
        int result = q.executeUpdate();  
        System.out.println("Result "+result);  		
		tx.commit();
		session.close();
 

[madhuri kunchala]

hi good morning,

Jagadeeswara Yaramala wrote
SessionFactory factory = cfg.buildSessionFactory()

can anyone explain what does cfg and BackupStock takes and where should it be declared..and i modified my code as suggested by 'Jagadeeswara Yaramala' eventhough im getting same error..here is my code..

import org.hibernate.Query;
import org.hibernate.Session;
public class test {
    Session session = null;
    public test() {
        this.session = HibernateUtil.getSessionFactory().getCurrentSession();
        org.hibernate.Transaction tx = session.beginTransaction();
        Query q = session.createQuery("insert into test1(tid,tname)"+ "select tid,tname from BackupStock");
        System.out.println(q.toString());
        int result = q.executeUpdate();
        System.out.println("Result "+result);
        tx.commit();
        session.close();
    }
}

thanks,
madhu.

[madhuri kunchala]

any help regarding my post.