I am having this error as well with the following query
SELECT rank FROM (SELECT @rownum:=@rownum+1 rank, result, user_id FROM (SELECT AVG(result) as result, user_id FROM wod_result where wod_id = :wodId group by user_id order by result desc) as result, (SELECT @rownum:=0) r) AS rank_result where user_id = :userId;
Exception:
Request processing failed; nested exception is org.hibernate.QueryException: Space is not allowed after parameter prefix ':'
I am having this error as well with the following query
SELECT rank FROM (SELECT @rownum:=@rownum+1 rank, result, user_id FROM (SELECT AVG(result) as result, user_id FROM wod_result where wod_id = :wodId group by user_id order by result desc) as result, (SELECT @rownum:=0) r) AS rank_result where user_id = :userId;
Exception:
Request processing failed; nested exception is org.hibernate.QueryException: Space is not allowed after parameter prefix ':'
I am on hibernate-core-4.1.4.Final.jar