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