ejb 3.0 - DATE_SUB named query MYSQL -

ejb 3.0 - DATE_SUB named query MYSQL -

have named query written this

select u user u u.creationdate < date_sub(curdate(),interval :upperdate day) , status=:status , reminder_counter =:counter

but syntax error parsing.

any ideas`?

p

the function date_sub using mysql specific, resulting in parsing error.

create named native query utilize date_sub function. else, can calculate duration explicitly & setting parameter.

ejb-3.0 named-query