当前位置: 动力学知识库 > 问答 > 编程问答 >

hql - problem with named parameter query in hibernate

问题描述:

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

网友答案:

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

分享给朋友:
您可能感兴趣的文章:
随机阅读: