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

Popular posts from this blog

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

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

c# - Chart control: Design messed Up after clearing and re-adding Y-Values -

-
Image
The day was struggling with this. I have three series on a chart that looks like this. Note: I am using vanof control. They are being added on the basis of input from the calculation. I am using this code to add value to each series. this.chart1.Series ["green"]. Points. AddY (greenvalue); This.chart1.Series ["totalsaving"] Points.AddY (totalsavingvalue). This.chart1.Series ["blue"] Points.AddY (bluevalue). I have set series properties like this. Both green and totalsaving are set to StackedColumn, the blue chart is set to the column for type. I started then To do is a button that brings the user back to the input field and then I am using this code to clear the series values ​​on the start code. chart 1. Series ["totaling"]. Points. clear (); Chart1.Series ["green"] Points.Clear () .; Chart1.Series ["blue"] Points.Clear () .; The same calculation click above is being calculated for the calculation of th...
Read more

xml - XMLStarlet - UTF-8 Nordic characters -

-
To use an XMLStarlet (windows) to edit an RSS feed, but the Norwegian letter 'ANSA' There are some issues with. I am using an example found on this site () This is my feed. Xml is (Notepad ++ says it is encoded in UTF-8) I am not using the following example because it is for Linux script, but my long command line is similar. # ! / Bin / sh TITLE = "Test Title ÆØÅ" LINK = "http://www.example.com" DATE = "` Saturday, 26 July 2014 01:14:30 + 0200` "xmlstarlet ed -l -a" / / Channel "-tmm-nmad-v" "\ -s" // item [1] "-t emil - t-- v" $ tITLE "\ -s" // item [1] "-t Elem -n link -v "$ LINK" \ -s "// item [1]" -t elem -n pubDate -v "$ DATE" \ -d "// item [condition ()> 10]" Feed .xml; Windows Command Line (What I'm using): xml.exe ed -l -a "// channel" -t elem - N item-v "" -s "// item [1]" -t elem -n title -v...
Read more