Re: [eclipselink-users] nearestNeighbor returns only 1 result

[Tom Ware <tom.ware@xxxxxxxxxx>]

Hi Mark,

  Try turning our logging to the FINEST level and take a look at the generated 
SQL.  Does it look correct?  When you run it in an SQL console, does it return 
more than one result?

  Use the persistence unit property eclipselink.logging.level=FINEST to set the 
logging level.

-Tom

Mark Robinson wrote:
> So I have this snippet of code
>
>      ReadAllQuery raq = new ReadAllQuery(NavteqPoiBean.class);
>      ExpressionBuilder eb = raq.getExpressionBuilder();
>      SpatialParameters parameters = new SpatialParameters();
>
>
>      Expression spatialExp = 
> SpatialExpressionFactory.nearestNeighbor(eb.get("geom"), geom, parameters);
>
>      raq.setSelectionCriteria(spatialExp);
>      raq.prepareForExecution();
>      Session session = ((EntityManagerImpl)getEm()).getSession();
>      List<RowInterface> pois = (List)session.executeQuery(raq);
>
> When I run it, I only get one result which I think is wrong, the table 
> has about 7000 rows.  Does EclipseLink not support returning more than 
> one result from this query or am I doing this wrong?
>
> Mark