unexpected token: VALUES near line 1, column 57

playframework syntax-error sql-in
doniyor picture doniyor · Jun 20, 2012 · Viewed 16.7k times · Source 
JPA.em("default").createQuery("insert into USER (FULLNAME, EMAIL, USERNAME, PASSWORD) " + " VALUES (\'"+fullname+"\',\'"+email+"\',\'"+username+"\',\'"+password+"\');");

is it a wrong query? i get this error: 

[IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: VALUES near line 1, column 57 [insert into USER (FULLNAME, EMAIL, USERNAME, PASSWORD) VALUES ('Doniyor','[email protected]','jurabayev','er');]]

i dont know why this is happening, the query string is actually okay, right?

would appreciate any help!

thanks

Answer

duffy356 picture duffy356 · Jun 20, 2012

i think you should use

.createNativeQuery(...);

instead of 

.createQuery(...);

but I'm not sure about it.

if you are using annotations

@Query(value = "your_query_here", nativeQuery = true)

Related questions

Error: Argument is not a function, got undefined

Using AngularJS with Scala Play, I'm getting this error. Error: Argument 'MainCtrl' is not a function, got undefined I'm trying to create a table consisting of the days of the week. Please take a look at my code. I had …

Read More
How do I change the default port (9000) that Play uses when I execute the "run" command?

How can I change the default port used by the play framework in development mode when issueing the "run" command on the play console. This is for playframework 2.0 beta. Using the http.port configuration parameter either on the command line …

Read More
Understanding implicit in Scala

I was making my way through the Scala playframework tutorial and I came across this snippet of code which had me puzzled: def newTask = Action { implicit request => taskForm.bindFromRequest.fold( errors => BadRequest(views.html.index(Task.all(), errors)), …

Read More