problem with named parameter query in hibernate

Question

In order to prevent SQL Injection i am trying to convert dynamic queries to named parameter query.. however, when i am using this code -

String query = "from Ad a left join fetch a.adQueries left join fetch a.aduser u left join fetch u.profile where a.id =:identifier";
        Query q = s.createQuery(query);
        q.setParameter("identifier", id);

No data is returned from DB even though the data is there and the same query in dynamic form return data

and when i use this code -

String query = "from Ad a left join fetch a.adQueries left join fetch a.aduser u left join fetch u.profile where a.id =:identifier";
        Query q = s.createQuery(query);
        q.setLong("identifier", id);

it throws a Null pointer exception..

Please let me know where i am going wrong

Thanks

axtavt · Accepted Answer · 2011-01-11 19:00:27Z

1

Perhaps id is null, it can cause such a behaviour.

answered Jan 11, 2011 at 19:00

axtavt

243k42 gold badges518 silver badges486 bronze badges

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

Collectives™ on Stack Overflow

problem with named parameter query in hibernate

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related