Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#3 "SELECT :queryParameter, ..." returns null in result set col

closed-fixed
Marco Schulze
None
5
2012-02-13
2012-02-01
Marco Schulze
No

If a JDO query contains a query-parameter in the result-clause like the following example, the corresponding column in the result set is null.

---------
SELECT :person, JDOHelper.getObjectId(this), this, this.movieID, this.name
FROM org.cumulus4j.store.test.movie.Movie
WHERE
this.starring.contains(:person) ||
this.writtenBy.contains(:person) ||
this.directedBy.contains(:person) ||
this.producedBy.contains(:person)
---------

The first element in the result-set is the ':person', which is a query-parameter. The query execution works fine and all other result-set-elements are correct, but the first one is null, even though it should be the object passed as query-parameter 'person'.

This bug only occurs when query.executeWithArray(...) is called - it does not occur with query.executeWithMap(...).

Discussion

  • Marco Schulze
    Marco Schulze
    2012-02-13

    Works with DataNucleus 3.0.7 (don't know exactly since when it works, but it didn't require any change in Cumulus4j-codes).

     
  • Marco Schulze
    Marco Schulze
    2012-02-13

    • assigned_to: nobody --> nlmarco
    • status: open --> closed-fixed