1. HQL Bulk insert stackoverflow.comI am using postgresql with hibernate and i would like to bulk insert data from a template table to another. How to do that in a native Query is clear to ... |
2. How to Insert values through HQL Insert :-( coderanch.comHI Everybody, Can any one of you help me,How to insert values in HQL Insert Here i am providing sample code...and i am hard coding the values and insert the values in the table.Can anyone please change my code so tht i can insert the values through HQL Insert(Provide the HQL in my code) //package com.tnzi; // //public class main { ... |
3. insert data into 2 tables using HQL coderanch.comHi, I'm trying to insert data into 2 tables in Hibernate using session.save(). But the issue is one of the column value inserted(generated) to the first table should be inserted as a foreign key value to the second table. In this case, the value generated in the first table is inserted to the second table when I update the existing row ... |
4. Inserting data using HQL on multiple tables. coderanch.com |
5. Help with HQL Insert and Joins using Hibernate 3 / JPA coderanch.comHello there, Need help with some specific HQL queries and / or better techniques for Hibernate / JPA. Created three JPA annotated classes: (1) User: @Entity @Table(name = "user", schema = "test") public class User { /* Data Fields */ private int userid; private String username; private String password; private Device device; public User() { } @Id @GeneratedValue(strategy = IDENTITY) @Column(name ... |
6. How to Insert values through HQL Insert forum.hibernate.orgThanks for the reply .I tried that,But my problem here is,i have two classes for the table t_gb_OrganizationMaster. (1)TGbOrganizationMaster and( 2)TGbOrganizationMasterId is having orgId,stateId,reginId .So i tried something like this. Code: TGbOrganizationMaster hai = new TGbOrganizationMaster(); TGbOrganizationMasterId tgbid = new TGbOrganizationMasterId(); ... |
7. Way to insert SQL comments into HQL generated SQL? forum.hibernate.orgHey all, I need to be able to insert the SQL comment /*+RULE*/ for stinking Oracle to figure out what indexes it should use. However, the SQL I need to insert it into is generated from a fairly complex HQL query. Is there a way that anyone knows of via the Query object or whatever, to instruct the SQL generator to ... |
8. Insert through a HQL forum.hibernate.orgSo then use proxies for those "child objects". Then session.load() will not hit the database. So many misconceptions, so little time ;) In Hibernate3 HQL now has an INSERT-SELECT statement. Currently it is serverely hampered by the fact that it cannot handle associations; that will be rectified before 3.1 goes final though. |
9. HQL bulk insert into - TOO many columns in insert statement forum.hibernate.orgNewbie Joined: Wed Feb 15, 2006 11:31 am Posts: 3 The following SQL works fine in HSQLDB, but fails in PostgreSQL. String hql = "insert into com.otto.profiles.group.dto.GroupPlayerApplicationDTO" + " (recipientGroup, player, created, approved)" + " select gm.group, gm.player, now(), gm.group.open" + " from com.otto.profiles.group.dto.GroupMembershipDTO gm where gm.group.id = :groupId"; Query query = getSession().createQuery(hql); query.setLong("groupId", groupId); query.executeUpdate(); In postgre it correctly maps ... |
10. Problem with HQL INSERT used with IdClass forum.hibernate.orgCaused by: org.hibernate.QueryException: can only generate ids as part of bulk insert with either sequence or post-insert style generators [insert into A (id) select b.id from com.medq.platform.persistence.ejb.entitymanager.example.B b] at org.hibernate.hql.ast.HqlSqlWalker.postProcessInsert(HqlSqlWalker.java:622) at org.hibernate.hql.antlr.HqlSqlBaseWalker.insertStatement(HqlSqlBaseWalker.java:491) at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:253) at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111) ... |
11. HQL update insert forum.hibernate.org |
12. Bulk HQL insert with parameters forum.hibernate.orgAuthor Message npintos Post subject: Bulk HQL insert with parameters Posted: Wed Jun 27, 2007 10:59 am Newbie Joined: Mon Feb 12, 2007 7:56 am Posts: 2 Hello! I'm trying to make a bulk insert with parameters in the 'select from' clause: Code: insert into DominioCuestionario (idDominioCuestionario,idDominioMaestro,idCuestionario,descripcion,formato) select :idNuevo,d.idDominioMaestro,:idCuest,d.descripcion,d.formato from DominioMaestro d where (d.idDominioMaestro = :idMaest1) But on application ... |
13. Insert Statement Not working in HQL forum.hibernate.orgHi, I am trying to insert a row in my table but it doesn't work and gives the error unexpected token: VALUES . My query is: INSERT INTO Trnhst(xwbccd, xwe4nb, xwricd, xwc8dt, xwbncd, xwbdcd, person, xwaacs, xwabcd, xwagcd, xwahcd, xwaicd, xwt8tx, xwordn, xwa5qt, xwvalu) VALUES('ACC44', 00200201, 'INV', 9, 'AG', 'USA', 'STU', 'USA', '000078', '22', '30', '39', 'PR123', 12, 6.0, 77.94) Plz ... |
14. HQL insert of composed objects forum.hibernate.org |