[OPENJPA-2851] argument CURRENT_DATE cannot handle java.time.LocalDateTime entity fields

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.2
• Fix Version/s: 3.2.0
• Component/s: jpa
• Environment: h2 database
• Assignee: Mark Struberg
• Reporter: Karl Grosse
• Created: 30/Mar/21 15:13
• Updated: 14/May/21 08:16
• Resolved: 01/Apr/21 20:01

Description

Using CURRENT_DATE as argument in queries for LocalDateTimeFields yields a 

org.apache.openjpa.persistence.ArgumentException: Attempt to compare incompatible types "class java.time.LocalDateTime" and "class java.util.Date".

 

Field in entity:

@NotNull
@Column(name = "USEDUNTIL", nullable = false)
private LocalDateTime usedUntil;

Example Query:

@NamedQuery(name = QUERY_COUNT_BY_IDS,
query = "SELECT COUNT(t) FROM Dokumente t WHERE t.dokumentId IN :dokumentId AND t.usedUntil >= CURRENT_DATE")