Hi everyone.. I have a huge ORDERS table to work with and each customer has a set of ORDERS within the orders table. There are over 2 million records in the ORDERS table. I tried to run the following in Hibernate (
Java) but got a java.lang.OutOfMemoryError: Java heap space error. HELP!!
What is the best move I can make to fix this problem?
"select sum(orderz.result03),sum(orderz.result05),sum(orderz.result07),sum(orderz.result08),sum(orderz.result09),sum(orderz.result26)," +
// "sum(orderz.result02),sum(orderz.result04),sum(orderz.result06),sum(orderz.result13),sum(orderz.result16),sum(orderz.result18)," +
// "sum(orderz.result19),sum(orderz.result25)," +
// "sum(orderz.result15),sum(orderz.result17),sum(orderz.result00),sum(orderz.result01)" +
//" from DialingListEntry as orderz where orderz.CUSTOMER_ID = :custId")
// .setInteger("custId", custId);
Anyone have any suggestions??? Help is much appreciated... In either DB work or hibernate.. Thanks