Inserting data in one table using HQL in Hibernate

by

You don’t need to use hql to insert if the data is from another table.

Simply get a reference to your entity, get a hold of a Hibernate session, and call save().

According to http://docs.jboss.org/hibernate/orm/4.0/devguide/en-US/html/ch04.html#d0e2116

Pseudo-syntax for INSERT statements

INSERT INTO EntityName properties_list select_statement

Only the INSERT INTO … SELECT … form is supported. You cannot specify explicit values to insert.

More Related Contents:

  1. How do you do a limit query in JPQL or HQL?
  2. What is the difference between JOIN and JOIN FETCH when using JPA and Hibernate
  3. JPA and Hibernate – Criteria vs. JPQL or HQL
  4. Hibernate criteria: Joining table without a mapped association
  5. How can you call custom database functions with Hibernate?
  6. Hibernate Named Query Order By parameter
  7. Hibernate HQL Query : How to set a Collection as a named parameter of a Query?
  8. How to escape reserved words in Hibernate’s HQL
  9. IN-clause in HQL or Java Persistence Query Language
  10. HQL Hibernate INNER JOIN
  11. HQL left join of un-related entities
  12. HQL – row identifier for pagination
  13. No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode HQL
  14. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  15. How to write a like query in HQL
  16. HQL recursion, how do I do this?
  17. Mapping PostgreSQL JSON column to a Hibernate entity property
  18. proper hibernate annotation for byte[]
  19. How to map a PostgreSQL array with Hibernate
  20. JPA/Hibernate Native Queries do not recognize Parameters
  21. Difference Between One-to-Many, Many-to-One and Many-to-Many?
  22. Error : java.lang.NoSuchMethodError: org.objectweb.asm.ClassWriter.(I)V
  23. Found shared references to a collection org.hibernate.HibernateException
  24. How to get distinct results in hibernate with joins and row-based limiting (paging)?
  25. Strange Jackson exception being thrown when serializing Hibernate object
  26. Hibernate, Postgres & Array Type
  27. How can I set Datasource when I’m creating Hibernate SessionFactory?
  28. Hibernate, Java 9 and SystemException
  29. Difference between @GeneratedValue and @GenericGenerator
  30. FetchMode join makes no difference for ManyToMany relations in spring JPA repositories

Leave a Comment