HI I m firing a query like this in my code..

List list=HibernateUtil.getSessionFactory().getCurrentSession() .createQuery("from Person where firstName = :f").setString("f",fName) .list();

i am passing fName="XYZ" as input to this....

but i m getting the following error stating tht the query is gramatically wrong. Now, if i fire the same query appending the db name in the db browser window, it runs just fine.. can somebody plz help me out ??


Hibernate: select person0_.person_seq as person1_4_, person0_.version as version4_, person0_.first_name as first3_4_, person0_.middle_name as middle4_4_, person0_.last_name as last5_4_, person0_.dob as dob4_, person0_.modified_dt as modified7_4_ from myapp.myApp.person person0_ where person0_.first_name=?
Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
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)
at com.dev.dao.PersonDao.findByName(PersonDao.java:186)
at com.dev.client.TestClient.main(TestClient.java:10)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.person person0_ where person0_.first_name='XYZ' at line 1

Is the problem the duplicated table name in from?

from myapp.myApp.person

? I don't know what could cause this. Maybe you have the table for Person entity defined wrongly?

Regards,
Pavol

Use setProperties instead of setString

List list=HibernateUtil.getSessionFactory().getCurrentSession() .createQuery("from Person where firstName = :f").setProperties("f",fName) .list();

The table is proper. The name is not duplicated. The first one is the db and the second "myApp" is the schema..

And setProperties() wont help coz its the same as setString. The only difference being tht its more generic....

So you say, that if you run the query directly on mysql it works?

select person0_.person_seq as person1_4_, person0_.version as version4_, person0_.first_name as first3_4_, person0_.middle_name as middle4_4_, person0_.last_name as last5_4_, person0_.dob as dob4_, person0_.modified_dt as modified7_4_ from myapp.myApp.person person0_ where person0_.first_name=?

Of course change the questionmarks.

If no, try only:

select person0_.person_seq as person1_4_, person0_.version as version4_, person0_.first_name as first3_4_, person0_.middle_name as middle4_4_, person0_.last_name as last5_4_, person0_.dob as dob4_, person0_.modified_dt as modified7_4_ from myApp.person person0_ where person0_.first_name=?

Pavol