[OPENJPA-2849] select(max) etc of LocalDate, LocalDateTime etc leads to ClassCastException

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.2
• Fix Version/s: 3.2.0
• Component/s: jdbc
• Assignee: Mark Struberg
• Reporter: Mark Struberg
• Created: 28/Mar/21 12:26
• Updated: 14/May/21 08:16
• Resolved: 30/Mar/21 12:41

Description

The following code leads to a ClassCastException:

        final TypedQuery<LocalDate> maxLocalDateQry = em.createQuery("select max(t.localDateField) from Java8TimeTypes AS t", LocalDate.class);
        final LocalDate maxLocalDate = maxLocalDateQry.getSingleResult();
        assertEquals(VAL_LOCAL_DATE, maxLocalDate);

Caused by: java.lang.ClassCastException: Cannot convert object "01.01.19 00:00" of type "class java.sql.Date" into an instance of "class java.time.LocalDate".
	at org.apache.openjpa.kernel.Filters.convert(Filters.java:336)
	at org.apache.openjpa.kernel.Filters.convert(Filters.java:264)
	at org.apache.openjpa.jdbc.kernel.exps.UnaryOp.load(UnaryOp.java:142)