[ https://issues.apache.org/jira/browse/CAY-2700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrus Adamchik updated CAY-2700: --------------------------------- Description: We need to standardize date[time] String representation in Cayenne expressions to be ISO8601. Some background ... When parsing Cayenne expressions we do not attempt any type conversion of parameter values. This is usually not a problem for Cayenne users, as they can pass parameters already converted to a need type (e.g. LocalDateTime). However this is an [issue for frameworks like Agrest|https://groups.google.com/g/agrest-user/c/MxFktjHhXGI] that can not do proper parameter conversion as they are not aware of the left-hand side of an expression matched with the parameter. So let's implement a more robust conversion inside the Cayenne stack. We can probably do it right in the ExtendedType. E.g. ExtendedType for String can do a ISO-8601 String to date[time] conversion based on the passed JDBC type. was: When parsing Cayenne expressions we do not attempt any type conversion of parameter values. This is usually not a problem for Cayenne users, as they can pass parameters already converted to a need type (e.g. LocalDateTime). However this is an [issue for frameworks like Agrest|https://groups.google.com/g/agrest-user/c/MxFktjHhXGI] that can not do proper parameter conversion as they are not aware of the left-hand side of an expression matched with the parameter. So let's implement a more robust conversion inside the Cayenne stack. We can probably do it right in the ExtendedType. E.g. ExtendedType for String can do a ISO-8601 String to date[time] conversion based on the passed JDBC type. > Convert expression String parameters to date[time] when appropriate > ------------------------------------------------------------------- > > Key: CAY-2700 > URL: https://issues.apache.org/jira/browse/CAY-2700 > Project: Cayenne > Issue Type: Improvement > Reporter: Andrus Adamchik > Priority: Major > > We need to standardize date[time] String representation in Cayenne > expressions to be ISO8601. > Some background ... When parsing Cayenne expressions we do not attempt any > type conversion of parameter values. This is usually not a problem for > Cayenne users, as they can pass parameters already converted to a need type > (e.g. LocalDateTime). However this is an [issue for frameworks like > Agrest|https://groups.google.com/g/agrest-user/c/MxFktjHhXGI] that can not do > proper parameter conversion as they are not aware of the left-hand side of an > expression matched with the parameter. > So let's implement a more robust conversion inside the Cayenne stack. We can > probably do it right in the ExtendedType. E.g. ExtendedType for String can do > a ISO-8601 String to date[time] conversion based on the passed JDBC type. -- This message was sent by Atlassian Jira (v8.3.4#803005)