This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund 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
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Reply Bookmark "hql with select , where " Watch "hql with select , where " New topic
Author

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
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: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: hql with select , where
 
Similar Threads
Invalid MySQL syntax when using 'select new list()'
[Resolved]java.util.NoSuchElementException problem after displaying the information from text file
Can i delete an object based on his reference
sequence generator with mysql
Hibernate HQL Delete query problem