Retrieving List<Long> from query about sql2o HOT 2 OPEN

The executeAndFetch method expects a model class as a parameter. It expects to use the built-in converter framework to convert the fetched database values to the properties in the model class. It doesn't expect to create a simple list of primitives, as in your example.

The method you are looking for is the executeScalarList method. If you use that, it should work as you expect in your example.

List<Long> longList = myQuery.executeScalarList(Long.class);

from sql2o.

Thanks - this used to work just fine in our version - we must have patched this so that the API was simpler /more consistent. We know the return type - why have two methods to get at a List<> of something

from sql2o.