Why this ORMLite query is not working?

Asked Mar 15 '18 at 03:27

Active Mar 17 '18 at 19:16

Viewed 138 times

I have a select with multiple columns:

select columnA,AVG(columnB),AVG(columnC),AVG(columnD),AVG(columnE)...

columnA is an Integer and all the others are Double. Here is how i initialize the GenericRawResults object:

GenericRawResults<Object[]>rawResults = dao.queryRaw(
    "SELECT columnA,AVG(columnB),AVG(columnC),AVG(columnD),AVG(columnE)...",
    new DataType[]{DataType.INTEGER,DataType.DOUBLE,DataType.DOUBLE,...});

When I run a for statement...

for(Object[] result: rawResults) {
     //some code here
 }

I get this Exception:

Attempt to invoke virtual method 'boolean com.j256.ormlite.stmt.SelectIterator.hasNext()' on a null object reference

Am I doing something wrong?

edited Mar 17 '18 at 19:16

y.allam

1,446
13
24

asked Mar 15 '18 at 03:27

mrv

When you are providing information about a problem, always provide the _entire_ exception? – Gray Mar 17 '18 at 16:32
`rawResults` is null ... – PeterMmm Mar 17 '18 at 19:22
@PeterMmm yes i know, but I don't why! – mrv Mar 20 '18 at 15:54

Why this ORMLite query is not working?

0 Answers0