Need Quick Help!! Production Server Issue

2008-06-28 Thread Somendra Paul
These are the following java objects that we store:   Wip  -- Wip Process(related table of Wip) - Wip Qty (related table of Wip) Lot -- Lot Qty(related table of Lot) - Lot Process Location(related table of Lot) Shipment   The way our code works is this Wip,Lot,Shipment data are kept in csv

Handling Large Resultset in Oracle

2008-09-21 Thread Somendra Paul
crashing.   Do we know how to solve this memory issue when executing large resultset in Oracle.   One solution that in the OJB archives for ProgressSQL is that to use fetchSize=somevalue , it will solve this issue ???     Thanks and Regards Somendra Paul

Re: Handling Large Resultset in Oracle

2008-09-21 Thread Somendra Paul
looks is on similar lines.     Do your solutions mentioned of report queries will solve  this kind of issues ?     We might think of 1.5 , depending upon what you say.   Thanks and Regards, Somendra Paul.     - Original Message From: Armin Waibel [EMAIL PROTECTED] To: OJB Users List ojb