java - sql query work when run it in sqlDeveloper but not work using hibernate -
I have a query that I want to run using Hibernate Native SQLLQuery
SQL Developer It works fine, but when hibernate is run, it throws the exception
. . Reason: By: org.hibernate.exception.SQLGrammarException: org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert Could not remove ResultSet (SQLExceptionTypeDelegate.java:82). . . Reason: java.sql.SQLSyntaxErrorException: ORA-00911: Invalid Character
Here is my SQL query:
select car_id from car.plate car where is the car. Order '% 12%' by CAR.CAR_ID;
> your semicolon ";" Remove cheers.
Comments
Post a Comment