This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes hql with select , where Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "hql with select , where " Watch "hql with select , where " New topic

hql with select , where

indu iyengar
Ranch Hand

Joined: Jul 30, 2010
Posts: 115
Hi all am trying to get the records with where clause using hql from mysql db, then it shows the exception as

in my java source class..

am using hibernate 3 and mysql 5.1

please help me guys..

thanks ,
indu iyengar
Ranch Hand

Joined: Jul 30, 2010
Posts: 115
my code is ::
Bogdan Baraila
Ranch Hand

Joined: May 23, 2011
Posts: 43
Like the name of the method you use is saying (createSQLQuery) you are not creating a hql query but a native sql query that will apply directly to the database. Try using the createQuery method.
I agree. Here's the link:
subject: hql with select , where
It's not a secret anymore!