How to write HQL Insert query?

Question

I am struggling to write a HQL query for inserting a new record in a table. I have seen some of insert query as below but I don't want insert data from another table as below code.

String hql = "INSERT INTO Employee(firstName, lastName, salary)"  + 
             "SELECT firstName, lastName, salary FROM old_employee";
Query query = session.createQuery(hql);
int result = query.executeUpdate();
System.out.println("Rows affected: " + result);

For example I have a table "User" with three fields like name, age, number and I have entity for this user table. what will be the insert query for this?

Answer 1

In HQL, only the INSERT INTO … SELECT … is supported; there is no INSERT INTO … VALUES. HQL only support insert from another table.

So query INSERT from SELECT is possible like this

Query query = session.createQuery("insert into Stock(stock_code, stock_name)" +
                "select stock_code, stock_name from backup_stock");
int result = query.executeUpdate();

Got from here secion 4

If you have values and Entity just call

MyEntity e=new MyEntity();
e.setXXXX(the XXX values);
save(e);

Answer 2

HQL doesn't support such INSERTs so you have to do this by creating and persisting new entity.

You can read about it here.

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