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