hibernate - 使用 Hibernate 3.5 批量插入

Question

如何使用 hibernate 3.5 执行以下操作

INSERT INTO Table (Column1, Column2 ) VALUES
(Value1, Value2), (Value1, Value2)

Answer 1

您可能需要考虑使用无状态 session 。但是，请小心，因为返回的结果(在本例中为客户)是分离的。

http://docs.jboss.org/hibernate/orm/3.5/reference/en/html/batch.html#batch-statelesssession

StatelessSession session = sessionFactory.openStatelessSession();
Transaction tx = session.beginTransaction();

ScrollableResults customers = session.getNamedQuery("GetCustomers")
    .scroll(ScrollMode.FORWARD_ONLY);
while ( customers.next() ) {
    Customer customer = (Customer) customers.get(0);
    customer.updateStuff(...);
    session.update(customer);
}

tx.commit();
session.close();