Hello,

I have used Criteria API for a fairly complex query that can return up to 1 million entries.
Unfortunately i have to store this data in a table so i would need something like insert into ... select
because iterating through such a large list and inserting one by one is a performance bottleneck.
Can i find something similar in criteria API?
Is there another efficient technique for such an operation?

Thanks,
Marius H.

See this: http://docs.jboss.org/hibernate/core/3. ... ch-inserts

Thank you for your hint.
I was looking for something like:
String hqlInsert = "insert into DelinquentAccount (id, name) select c.id, c.name from Customer c where ...";
int createdEntities = s.createQuery( hqlInsert )
.executeUpdate();

It seems that HQL has some way of dealing with insert ..select and i was hoping for something similar in Criteria API for performance reasons.
Is there a match in Criteria for that kind of operation? A patch, a workaround, something?
Also i don't return from my select a mapped entity, but rather projections based items.
How can i deal with them?

Thanks again,