Rest query on LocalDate possible bug

Support
#1

how to make rest query to LocalDate. I have this example where some_LocalDate is LocalDate which allways thows exeption duw to toInstant conversion

Params in request:
?datumOd=2020-01-01&datumDo=2020-01-29&klient=708211&ponuka=NL6201

<query name="findDoprava" entity="doprava_Doprava" view="doprava-view">
        <jpql><![CDATA[select e from doprava_Doprava e
        left join e.klient k
        left join e.ponuka p
        where
        e.some_LocalDate > :datumOd
        and e.some_LocalDate < :datumDo
        and e.master_lock = true
        and k.id = :klient
        and p.id = :ponuka
        order by e.date_of_change ASC]]></jpql>
        <params>
            <param name="datumOd" type="java.util.Date"/>
            <param name="datumDo" type="java.util.Date"/>
            <param name="klient" type="java.lang.Integer"/>
            <param name="ponuka" type="java.lang.String"/>
        </params>
</query>

Exception thrown:

java.lang.UnsupportedOperationException: null
	at java.sql/java.sql.Date.toInstant(Date.java:316) ~[java.sql:na]
	at com.haulmont.cuba.core.sys.QueryImpl$Param.convertValue(QueryImpl.java:847) ~[cuba-core-7.2.7.jar:7.2.7]
	at com.haulmont.cuba.core.sys.QueryImpl$Param.apply(QueryImpl.java:811) ~[cuba-core-7.2.7.jar:7.2.7]
	at com.haulmont.cuba.core.sys.QueryImpl.getQuery(QueryImpl.java:163) ~[cuba-core-7.2.7.jar:7.2.7]
	at com.haulmont.cuba.core.sys.QueryImpl.getResultList(QueryImpl.java:412) ~[cuba-core-7.2.7.jar:7.2.7]
	at com.haulmont.cuba.core.app.RdbmsStore.executeQuery(RdbmsStore.java:895) ~[cuba-core-7.2.7.jar:7.2.7]
	at com.haulmont.cuba.core.app.RdbmsStore.getResultList(RdbmsStore.java:803) ~[cuba-core-7.2.7.jar:7.2.7]
#2

Have you tried to define the parameter as LocalDate?

<param name="datumOd" type="java.time.LocalDate"/>
#3

Yes, it will also throw exception.

#4

Thank you for reporting the problem.
It’s already registered: Support for Java 8 Date/Time API in parameters · Issue #125 · cuba-platform/restapi · GitHub, we’ll implement it for one of the next CUBA bugfix releases.