Hello Hibernate community!

I am currently in the situation to make a decision between using JPA/Hibernate or plain JDBC. One task of my scenario the software will have to achieve, is to PLAIN COPY huge amounts of data between tables (>100,000 rows). When using Hibernate Entities for this, I imagine the heap space of the JRE will be stressed quite a lot. Also, iterating over the data entries seems to be a severe performance concern. One could make use of native SQL to copy these rows, however this appears to be bad practice, as I would mix Hibernate queries with plain SQL in the software.

Do you know about any functionality JPA/Hibernate provides, to execute huge copy transactions AS FAST AS PLAIN SQL would do without using native SQL?

Highly appreciate your input!

INSERT INTO ... SELECT ... FROM .... is supported as described in:

http://docs.jboss.org/hibernate/core/3. ... tch-direct

That's true! And this is what I need! Thank you!