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

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

java - Gradle dependencies: compile project by relative path -

ruby on rails - Object doesn't support #inspect when used with .include -