How to resolve this error nested exception is java.lang.IllegalArgumentException: org.hibernate.QueryException: Space is not allowed after parameter prefix
Whitelabel Error Page This application has no explicit mapping for /error, so you are seeing this as a fallback. Wed Apr 29 15:01:33 IST 2020 There was an unexpected error (type=Internal Server Error, status=500). org.hibernate.QueryException: Space is not allowed after parameter prefix ':' [select * from table_A a JOIN TABLE_B b on a.offering:'XYZ' AND a.ID=b.ID]; nested exception is java.lang.IllegalArgumentException: org.hibernate.QueryException: Space is not allowed after parameter prefix ':' [select * from table_A a JOIN TABLE_B b on a.offering:'XYZ' AND a.ID=b.ID]
Answer: To resolve this issue, kindly check and execute the sql script of native query, which you want to execute at run time from a jpa repository in spring boot.
Same issue can be found in java programming in hibernate, if you are not correcting your created sql script that will execute on runtime.