Projection Column Mapping Issue [DATACMNS-927]

[spring-projects-issues]

Michael Gmeiner opened DATACMNS-927 and commented

There seems to be a bug within the projection implementation. I have a native query which result i want to map with projection to a interface. The interface has three getters which have the exact name as the returned columns by the native query. The result is now that the columns are mapped into the wrong properties in the interface (or its proxy).

I found that the problem may be in ResultProcessor Line 262 when the names get mapped to the columns. The names are in a wrong order. This wrong order is already present when the PropertyDescriptor instances are retrieved from the interface in DefaultProjectionInformation Line 48.

Hope this helps :)

---

Affects: 1.12.4 (Hopper SR4)

Issue Links:

• DATAJPA-980 Projections with native queries don't work as expected
  ("duplicates")

[spring-projects-issues]

Oliver Drotbohm commented

This suspiciously sounds like a duplicate of the just filed DATAJPA-980

[spring-projects-issues]

Michael Gmeiner commented

Yes it's a duplicate of the mentionend issue of you. Seems like Robert Hunt and me had the same issue at the same time :D

[spring-projects-issues]

Oliver Drotbohm commented

I just checked and it's definitely the way, Spring Data JPA executes the native query currently. We're getting back a plain list only where actually a Map is expected, as that would allow us a proper mapping of property names to columns returned