Hibernate SQLQuery doesn't INSERT INTO SELECT

Question

When I do an executeUpdate on this SQL query in Hibernate 3.5:

Query insert = session.createSQLQuery(
"INSERT INTO unmapped_table_1 (column_name) "
    + "SELECT column_name "
    + "FROM source_table;");
insert.executeUpdate();

Hibernate returns the number of entries but does not insert the entries. When I do the query directly on the MySQL Server, the entries do get inserted.

Set the hibernate.show_sql=true, what is the log output for query execution? — DimaSan
– DimaSan, Commented Nov 2, 2017 at 10:41
Have you tried select columns into unmapped_table_1 from source_table. ? — Vipin CP
– Vipin CP, Commented Nov 2, 2017 at 11:17

hiren · Accepted Answer · 2017-11-02 11:57:53Z

1

May be your autocommit is not set to true, in this case you have to call commit() after query execution. By default Hibernate auto commit is false you can set autocommit to true withsetAutocommit(true)

answered Nov 2, 2017 at 11:57

hiren

1,81214 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Hibernate SQLQuery doesn't INSERT INTO SELECT

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related