calling my oracle hash function in where clause , but this doesn't work. What are the limitations of JPQL ?
posted 7 years ago
JPQL does not support the hash function, it only supports a limited set of common database functions.
You can either use a native SQL query, or use a TopLink Expression query, Expression allow the getFunction() call to add a user defined function, they also support many additional database functions not supported in JPQL and allow user defined ExpressionOperators and mixing of SQL with Expression critieria.