HQL Insert Query in Grails

Posted by WaZ on Stack Overflow See other posts from Stack Overflow or by WaZ
Published on 2010-04-29T16:37:21Z Indexed on 2010/04/30 0:17 UTC
Read the original article Hit count: 277

Filed under:

grails

|

groovy

|

hql

|

hibernate

I want to write an insert query in Grails. I have tried all possible combinations but cant get the syntax correct. Can anybody please help?

class Person {
    int age
    int name
}

i tried the following:

Person.executeUpdate("insert into Person  values (20,30)")

p.s.:Please do not mention using save()

© Stack Overflow or respective owner

Related posts about grails

Grails, app-engine, jpa - beginner having trouble with grails generate-all

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to learn about grails with Google App Engine and JPA by following a few tutorials: http://www.morkeleb.com/2009/08/12/grails-and-google-appengine-beginners-guide/ http://inhouse32.appspot.com/index.html http://grails.org/plugin/app-engine I've got grails 1.3.0 RC 2, and App Engine SDK… >>> More
Grails Warnings/Errors during run-app

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm currently seeing the warnings below when trying to run my Google App Engine/Grails test app in Eclipse. Warning, target causing name overwriting of name startLogging Warning: C:\Users\Some Person.grails\1.2.0\projects\test-grails\plugins\app-engine-0.8.8\grails-app\conf\spring not found. Warning:… >>> More
Grails, app-engine, jpa - TargetInvocationException

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to learn about grails with Google App Engine and JPA by following a few tutorials: http://www.morkeleb.com/2009/08/12/grails-and-google-appengine-beginners-guide/ http://inhouse32.appspot.com/index.html http://grails.org/plugin/app-engine I've got grails 1.3.0 RC 2, and App Engine SDK… >>> More
Inject log object in Grails class outside of grails-app

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a class in src/groovy in my grails project. How do i make a log field that gets injected with the correct logger for that class ? Is there a commons logging or just log4j in grails ? >>> More
grails run-war connects to mysql but grails run-war doesn't

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have a unexpected problem. I had create a war with grails war. Then I had deployed in Tomcat. For my surprise the crud works fine but I don't know what persistence is using. So I did this test: Compare grails prod run-app with grails prod run-war. The first works fine, and does conect with… >>> More

Related posts about groovy

Does IntelliJ-Idea support Groovy 2.x?

as seen on Programmers - Search for 'Programmers'
I just tried IntelliJ-Idea 11.x and 12.x (EPA), but when I use Groovy 2.0.1 or 2.0.5, the code can't be run and there are some errors out there. The Groovy plugin of idea has little information about which version of Groovy has been supported. Does idea support Groovy 2.x? I want to try the new… >>> More
grails 1.3.1 Error executing script GenerateViews:

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is the lay of the land. I have an app that I have created. I uninstalled hibernate, installed app-engine plugin and am using jdo. I am able to create a domain-class but the when I run generate-all I run into the following error. Oh and I did try just generating the controller for the domain… >>> More
How to list all (groovy) classes in JVM in groovy

as seen on Stack Overflow - Search for 'Stack Overflow'
I am writing a DelegatingMetaClass that I would like to apply to all groovy classes in my project, but I do not how to get hold of all classes in the project? Here is the code: /* This will work ok, since I know Foo beforehand, but what about classes that do not exist yet? */ def myMetaClass… >>> More
Multiple file access in groovy(Groovy on Grails)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have an application that allows multiple users to access 1 xml file. The problem is that when all the users save at once the other changes by other users does not get saved. How do I detect if the file is in user in groovy? Thanks! >>> More
Geb not working with chrome driver

as seen on Stack Overflow - Search for 'Stack Overflow'
@Grapes([ @Grab("org.gebish:geb-core:0.9.0"), @Grab("org.gebish:geb-spock:0.9.0"), @Grab("org.seleniumhq.selenium:selenium-firefox-driver:2.33.0"), @Grab("org.seleniumhq.selenium:selenium-chrome-driver:2.33.0"), @Grab("org.seleniumhq.selenium:selenium-support:2.26.0"), @Grab( group='org… >>> More