When have field with type LocalDateTime in Projection, get Projection type must be an interface! [DATACMNS-1847]

[spring-projects-issues]

Aiksandr opened DATACMNS-1847 and commented

In Spring boot 2.4.1 & 2.4.0
When use projection with field typed LocalDateTime
example
public interface Report { UUID getId(); LocalDateTime getCreateDate(); }
after fetch it from DB, get exception when try access to LocalDateTime field getCreateDate()

 

i made sample project, if You run it like usual Spring app, that will throw this exception
https://github.com/Aiksandr/spring-jpa-demo

{{Caused by: java.lang.IllegalArgumentException: Projection type must be an interface!
at org.springframework.util.Assert.isTrue(Assert.java:121)
at org.springframework.data.projection.ProxyProjectionFactory.createProjection(ProxyProjectionFactory.java:105)
at org.springframework.data.projection.SpelAwareProxyProjectionFactory.createProjection(SpelAwareProxyProjectionFactory.java:45)
at org.springframework.data.projection.ProjectingMethodInterceptor.getProjection(ProjectingMethodInterceptor.java:160)
at org.springframework.data.projection.ProjectingMethodInterceptor.potentiallyConvertResult(ProjectingMethodInterceptor.java:108)
at org.springframework.data.projection.ProjectingMethodInterceptor.invoke(ProjectingMethodInterceptor.java:85)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)}}

And in previews versions it works ok

 

This issue already was reproduced in spring boot issue spring-projects/spring-boot#24528)

---

Reference URL: spring-projects/spring-boot#24528

Issue Links:

• DATACMNS-1836 Native projection stopped working with Java8 datetime
  ("duplicates")

0 votes, 6 watchers

[idkw]

Any news ? This is a breaking change for us too.

[idkw]

@christophstrobl Since you worked on that issue
This issue is a duplicate of #2223, should be fixed in spring boot 2.4.3 then ?
Thanks !

[christophstrobl]

Fixed via #479 included in spring-data 2.4.3, picked up by Spring Boot 2.4.2

[ajobra76]

Since the ObjectToObjectConverter is removed one workaround whould be to wite a own ConverterService and use a @value Annotation with Spel Expression like
@value("#{@entityToDtoConvertingHelperService.convertObjectToObject(target)}") in the Projection interface

[sgflt]

As previous comment says, conversion of custom objects is now broken.

interface X {
  MyObject getMyObject();
}

with standard javax.persistence.AttributeConverter<MyObject, String>,

Throws projection type must be an interface! during call of X.getMyObject().

[mp911de]

Complex object conversion was never subject to the conversion service used for projections. The conversion service can adjust for slight conversions (long to int) but in no case for String to complex object conversion.

The underlying entity is what dictates the type that needs to be used in your projection. Alternatively, use SpEL through @Value.

[sgflt]

Umm, the code worked in Spring Boot 2.2.10, so it was jut unintended "side effect" and we are supposed to Use @Value Annotation? I really liked the previous behavior that magically used JPA converter.

Or did own conversion?

[sgflt]

I have to clarify, the projection is used in native query.

[mp911de]

Feel free to file a ticket directly against Spring Data JPA along with a minimal reproducible sample so we can specifically look into that issue. JPA typically returns the appropriate result and with a sample we can trace down the cause.

[NicklasWallgren]

We're still seeing this issue while trying to upgrade from spring boot 2.3.8 to 2.4.3.

The projection in question includes two LocalDateTime fields, and is backed by a named query.

[NicklasWallgren]

@mp911de

The issue in my case particular case was that the column property was defined as ZonedLocalDateTime in the entity, and the Projection for the same field was defined as LocalDateTime. The error is a bit misleading (Projection type must be an interface), and I don't know if this can be considered as a bug, since the conversion from ZonedDateTime to LocalDateTime in projections worked in 2.3.

[schauder]

@NicklasWallgren please open a new issue, since this on e is closed.