executeAndFetch NullPointerException

[daidge]

members = con.createQuery(sqlFindByIdNumber).addParameter("IdNumber", idnumber).executeAndFetch(Member.class);

java.lang.NullPointerException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.sql2o.reflection.MethodSetter.setProperty(MethodSetter.java:27)
at org.sql2o.DefaultResultSetHandlerFactory$4.setProperty(DefaultResultSetHandlerFactory.java:84)
at org.sql2o.DefaultResultSetHandlerFactory$6.handle(DefaultResultSetHandlerFactory.java:236)
at org.sql2o.PojoResultSetIterator.readNext(PojoResultSetIterator.java:33)
at org.sql2o.ResultSetIteratorBase.safeReadNext(ResultSetIteratorBase.java:88)
at org.sql2o.ResultSetIteratorBase.hasNext(ResultSetIteratorBase.java:52)
at org.sql2o.Query.executeAndFetch(Query.java:598)
at org.sql2o.Query.executeAndFetch(Query.java:587)
.............

[mbraunerDE]

Could you please provide the Query and the class please ?

[daidge]

public class Member {
private String NoBenef;
private String Name1;
private String Name2;
private String Status;

/* Constructor, Getter and Setter
}

final String sqlFindByIdNumber = "SELECT TOP 1 t1.NoBenef, t1.Name1, t1.Name2, t1.Status " +
"from table1 t1 inner join table2 t2 on t1.BenefID=t2.BenefID " +
"where IdNumber = :IdNumber ";

---

What 's wrong ?