Hi Andrew,
thanks for that. I see what the problem is.

But if I can’t use EJBQL when generating queries that use dates, can I go down 
any different paths or do I have to revert to writing plain old SQL?

Cheers,
- hugi



> On 12. ágú. 2015, at 05:36, Andrew Lindesay <a...@lindesay.co.nz> wrote:
> 
> Hi Hugi;
> 
> I think this was me; see CAY-1932 for some details on what I did there.
> 
> cheers.
> 
> On 12/08/15 10:09, Hugi Thordarson wrote:
>> Hi all.
>> 
>> I have a utility method that selects a row count given a DataObject class 
>> and an Expression, as seen here:
>> 
>> https://gist.github.com/hugith/d2cdaf60a6ee12aa0d17 
>> <https://gist.github.com/hugith/d2cdaf60a6ee12aa0d17>
>> 
>> I was using this today when I suddenly got the error message "the scalar 
>> type 'Date' is not supported as a scalar type in EJBQL”. Turns out that if I 
>> use a date in an Expression, it can’t be converted to EJBQL.
>> 
>> Can anyone suggest a workaround? Also, should I be creating utility methods 
>> like this in a different way than by using EJBQL? I have quite a few utility 
>> methods that all construct queries using EJBQL, but they become rather 
>> useless if I can’t use dates in them.
>> 
>> Cheers and thanks,
>> - hugi
>> 
> 
> 
> -- 
> Andrew Lindesay

Reply via email to