Return-Path: Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org Received: (qmail 2453 invoked from network); 17 Nov 2004 17:37:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 17 Nov 2004 17:37:04 -0000 Received: (qmail 3127 invoked by uid 500); 17 Nov 2004 17:36:51 -0000 Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org Received: (qmail 3069 invoked by uid 500); 17 Nov 2004 17:36:51 -0000 Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "POI Users List" Reply-To: "POI Users List" Delivered-To: mailing list poi-user@jakarta.apache.org Received: (qmail 3023 invoked by uid 99); 17 Nov 2004 17:36:51 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from [62.138.38.84] (HELO slox.sawag.com) (62.138.38.84) by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 17 Nov 2004 09:36:45 -0800 Received: from apollo (localhost [127.0.0.1]) by apollo (Postfix) with SMTP id 8E5FCEC736 for ; Wed, 17 Nov 2004 18:36:12 +0100 (CET) Received: by slox.sawag.com (Postfix, from userid 65534) id 50AF3EC737; Wed, 17 Nov 2004 18:36:12 +0100 (CET) Received: from karlheinzmobil (thor.sawag.com [62.138.17.46]) by slox.sawag.com (Postfix) with ESMTP id 57676EC731 for ; Wed, 17 Nov 2004 18:36:08 +0100 (CET) Reply-To: From: "KHZ (SAW)" To: "'POI Users List'" Subject: AW: Large Excel Files and java.lang.OutOfMemoryError Date: Wed, 17 Nov 2004 18:36:33 +0100 Organization: SAW Message-ID: <000001c4cccb$fad0ecc0$9500000a@karlheinzmobil> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Importance: Normal In-Reply-To: <10BE6BF91ACAE14C9444FDCB3D24747CCE02AB@uschd00mx11usr.AVNET.COM> X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on apollo.sawag.com X-Spam-Level: X-Spam-Status: No, hits=-104.7 required=5.0 tests=AWL,BAYES_00, USER_IN_WHITELIST autolearn=ham version=2.63 X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hi Dave. Then you'ld have to use the event model which is quite different from the user model. Regards, Karl-Heinz. -----Urspr=FCngliche Nachricht----- Von: Hamu, Dave [mailto:Dave.Hamu@Avnet.com]=20 Gesendet: Mittwoch, 17. November 2004 18:30 An: POI Users List Betreff: RE: Large Excel Files and java.lang.OutOfMemoryError Yes. This is my greatest concern. - Dave=20 -----Original Message----- From: Pravin Pillai [mailto:Pravin.Pillai@neoforma.com]=20 Sent: Wednesday, November 17, 2004 10:29 AM To: POI Users List; karl-heinz.zengerle@sawag.com Subject: RE: Large Excel Files and java.lang.OutOfMemoryError If ur memory setting is so high, none of the other processes on ur machine will be able to run. U might end up crashing something else.=20 -----Original Message----- From: Hamu, Dave [mailto:Dave.Hamu@Avnet.com] Sent: Wednesday, November 17, 2004 6:33 AM To: POI Users List; karl-heinz.zengerle@sawag.com Subject: RE: Large Excel Files and java.lang.OutOfMemoryError Karl-Heinz, Thank you. This suggestion worked. However, I remain concerned that it will not be a wholly reliable solution, because I've yet to attempt the largest file that I have to work with to meet the requirements of my application. My largest file must support about 65K rows (32 columns wide) spread across 5 tabs. In order to meet the memory needs of 41K of these rows, I had to set the -Xmx setting to 2048m!!! Thoughts? It seems that the next version of POI-HSSF needs to invest some time in memory management. Thanks again, David=20 -----Original Message----- From: KHZ (SAW) [mailto:karl-heinz.zengerle@sawag.com] Sent: Wednesday, November 17, 2004 2:42 AM To: 'POI Users List' Subject: AW: Large Excel Files and java.lang.OutOfMemoryError Hi Dave. E.g. -Xmx256m (or more). In Eclipse you would declare it per main(). In Tomcat it would be in a configuration file. In other systems it would surely work similar. Regards, Karl-Heinz. -----Urspr=FCngliche Nachricht----- Von: Hamu, Dave [mailto:Dave.Hamu@Avnet.com] Gesendet: Dienstag, 16. November 2004 23:11 An: poi-user@jakarta.apache.org Betreff: Large Excel Files and java.lang.OutOfMemoryError I have noticed that several people have run into this problem, but I have not found any solutions. In short, I receive a java.lang.OutOfMemoryError when I am writing particularly large Excel Files (several thousand rows of data). Has anyone found a clean solution to this problem that does not involve adding more memory (I have 3Gig on my workstation). - Dave --------------------------------------------------------------------- To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: poi-user-help@jakarta.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: poi-user-help@jakarta.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: poi-user-help@jakarta.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: poi-user-help@jakarta.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: poi-user-help@jakarta.apache.org