Getting org.hibernate.hql.ast.QuerySyntaxException though it works fine sql server?

Question

i have below code snippet. It throws the exception at line 3 but query works fine managemnt studio(sql server 2005)

String query = "select * from user where userId=" + profileId
    + " and spaceName='" + spaceName + "'";

Session session = HibernateUtil.getSession();

List<PersonDetailsData> personDetailsData = new ArrayList<PersonDetailsData>(
    session.createQuery(query).list()); //line 3

Here is the exception

org.hibernate.hql.ast.QuerySyntaxException: unexpected token: * near line 1, column 8 [select * from user where userId=216 and spaceName='DIG']

I am not able to figure out what's the problem with query when it is running fine in management sudio?

Jens Schauder · Accepted Answer · 2012-03-02 09:57:47Z

3

It's native query, not hql. If you have mapped table field to class fields you need

session.createSQLQuery(query, PersonDetailsData.class).list();

or create hql type query -

select p from PersonDetailData p where p.userId = :userId and p.spaceName =:spaceName

and use parameters in query, not direct values.

edited Mar 2, 2012 at 9:57

Jens Schauder

82.6k35 gold badges199 silver badges379 bronze badges

answered Mar 2, 2012 at 9:43

Dainius

1,8512 gold badges25 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

M Sach Over a year ago

Thanks DainusI have one more query i.e if this query does not return any data, will query.list will be null or not null. If it is not null then if i do personDetailsData.get(0) will it be null or not null. (Because i have to to do some operations based on null or not null values)

Dainius Over a year ago

If you call for list() it should not return null, but there's a special method for single object "getSingleResult()", if I good remember it throws exception when there is no result.

subodh · Accepted Answer · 2012-03-02 10:00:08Z

1

As you are using sql query so you have to create a sql query such as

sess.createSQLQuery("SELECT * FROM CATS").list();

see the source source

edited Mar 2, 2012 at 10:00

answered Mar 2, 2012 at 9:45

subodh

6,15813 gold badges53 silver badges73 bronze badges

Collectives™ on Stack Overflow

Getting org.hibernate.hql.ast.QuerySyntaxException though it works fine sql server?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related