I was trying to do a simple select using JPA:
So, I give it a try:
And this gives me back a QueryException:
Then, I tried to cast it:
(I have tried to cast it as String and Long. Casting to Integer results in the same exception as above.)
And then I get another QueryException:
What am I doing wrong?
Is there something I can do to solve this issue on the "user" side?
I noticed this error occurs with the following functions:
P.S.: I tried the above query using EclipseLink and it works fine.
P.S.2: POW and POWER don't work and are the same function. But in the SUBSTR and SUBSTRING pair, only the first don't work.
MySQL 5.7.18 (localhost)
MySQL-connector 5.1.42 (driver)
Database: MySQL Default Examples (schema world)