hi there,
I want to insert a list of records in only one insert.
I tried "hibernate.jdbc.batch_size" but in my log i see one insert statement for each record (displayed with "hibernate.show_sql").
insert into user (email, fullname, name, password) values (?, ?, ?, ?) insert into user (email, fullname, name, password) values (?, ?, ?, ?) insert into user (email, fullname, name, password) values (?, ?, ?, ?)
Is it possible to do a multi-row insert in hibernate like
insert into user (email, fullname, name, password) values (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?)
I want one insert statement for a batch_size instead of several insert statements
Even if it is not possible an answer could help me.
thanks for any help in advance mike
|