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

Folder list php -

-
I want to list folder names in the list. There is a file to show the folder name. There is already a problem, please do a test. Another code would be OK. & lt ;? Php function getFileList ($ folder name, $ fileType = "") {if (substr ($ folderName, strlen ($ folderName) - 1)! = "/") {$ Folder name. = '/'; } Foreach (Globe ($ folderName. '*'. $ FileType) $ filename) {if_dir ($ filename)) {$ type = 'folder'; } And {$ type = 'file'; } Echo str_replace ($ folderName, '', $ filename. ' '); }} // call function getFileList ('folder name'); // List of all files? & Gt; & Lt; Select class = "form" name = "userlevel" size = "1" & gt; & Lt; Option value = "& lt ;? php getFileList ('theme') ;? & gt;" & Gt; فولدر 1 & lt; / Options & gt; & Lt; Option value = "& lt ;? php getFileList ('theme') ;? & gt;" ...
Read more

GO: Serve static pages -

-
I'm trying to display a static page with Go. Go: Package main import "net / http" function main () {fs: = http.FileServer (http.Dir ("static / house")) Http: .handle ("/", fs) http.ListenAndServe (": 4747", zero)} directory: project / stable home Html edit.html project.go When I run it, the web page displays links to edit.html and home.html instead of displaying a static page from home.html is. What am I doing wrong. Is this the best way to serve files? I know that there are other ways like From the HTML / templates package, but I'm not sure what is the difference between each of these methods and when. Thanks! fancy main () {http.Handle ("/", http.FileServer (Http) .ir ("static")) http.ListenAndServe (": 4747", zero)} You do not need static / home , just Static . and when you do not have index.html in / static , the directory instead Content appears. Just change the name of...
Read more

python - Why can't I destroy my StaticText in wxPython? -

-
I am trying to remove statattext from the list and I get an error: AttributeError: 'tuple' object Not attribute 'deleted' I can not seem to find a way around it. My code: import wx square orange (wx.frame): def __init __ (self, guardian, id): wx.frame .__ init __ (self, guardian, id, 'test ', Size = (300,300) self.frame = wx.Panel (self) subtract = wx.Button (self.frame, label =' - ', pos = (80,200), size = (30,30)) self. Bind (wx .EVT_BUTTON, self.sub, subtract) self.trying = [] self.Something = 0 def sub (self, event): for zip (self.trying): i.Destroy () self.something + = 1 self .trying.append (wx.StaticText (self.frame, -1, str (self.something), pos = (200,200)) self.trying.append (wx.StaticText (self.frame, -1, str) (Self). (Some), pos = (250,200)) if __name__ == '__ main__': app = wx.PySimpleApp () window = orange (parent = none, id = -1) and Show () app.MainLoop () I am really confused why the static text is in a tuple, thanks ...
Read more