Hi,
I'm getting a java.lang.NullPointerException when i'm executing the following query.
String query ="select XYZBEan from XYZBEan"
+ "where corrd = :corrId"
+" and status = :status";
Query q = sess.createQuery(query);
q.setParameter("corrd ",corrd );
q.setInteger(status,status);
q.executeUpdate();


here the XYZBean is a HibernateBean. I'm new to Hibernate, need some guidance on how to write HQL queries....
Thanks in advance.
Kris

Hi,

shouldnt it be


instead of:



?

If not, than you should show us your stacktrace.

Have you read this ? : http://www.hibernate.org/hib_docs/refer ... ryhql.html


Yes, but without the colon (:)

And about the query itself, don't call executeUpdate() on a select.

Your code should look like :


The list l will contain the result of the query, an instance of XYZBean per iteration.

Hi,
Thanks for a quick reply.
I mistyped the code. I actually has a ':' bofore status.
I resolved the problem by using the following code

[i]List corrDetailsList = sess.createCriteria(XYZBean.class,"corrDet").add(Restrictions.sqlRestriction("xId = '"+xId+"' and status = 0")).list();[/i]

Once again thanks for posting your comments for my question.

I feel it's a bit pity that you use sql instead of a non-native one. Is xId the name of your column or the name of your property in your object. If it's the name of the column of the db table, then I think you should try to avoid doing like this.

See Restrictions.and() to create your criteria query.

Please rate the answers...