Return-Path: Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org Received: (qmail 76104 invoked from network); 18 Mar 2004 15:12:41 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 18 Mar 2004 15:12:41 -0000 Received: (qmail 29622 invoked by uid 500); 18 Mar 2004 15:12:13 -0000 Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org Received: (qmail 29594 invoked by uid 500); 18 Mar 2004 15:12:12 -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 29476 invoked from network); 18 Mar 2004 15:12:11 -0000 Received: from unknown (HELO slox.sawag.com) (62.138.38.84) by daedalus.apache.org with SMTP; 18 Mar 2004 15:12:11 -0000 Received: by slox.sawag.com (Postfix, from userid 65534) id 9592A3D664; Thu, 18 Mar 2004 16:12:11 +0100 (CET) Received: from karlheinzMOBIL (dsl.sawag.com [62.138.17.46]) by slox.sawag.com (Postfix) with ESMTP id 5624D3D62E for ; Thu, 18 Mar 2004 16:11:40 +0100 (CET) From: "Karl-Heinz Zengerle" To: "'POI Users List'" Subject: AW: AW: AW: can't open workbook Date: Thu, 18 Mar 2004 16:11:38 +0100 Organization: SAW AG Message-ID: <000e01c40cfb$4fed8fb0$3900000a@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 In-Reply-To: <1079622216.30581.22.camel@IT-avik.in.itellix.net> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Spam-Status: No, hits=-102.9 required=5.0 tests=AWL,BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REPLY_WITH_QUOTES,USER_IN_WHITELIST version=2.55 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.55 (1.174.2.19-2003-05-19-exp) X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hi Avik. We call Eclipse the following way: c: cd \eclipse C:\j2sdk1.4.1_05\bin\javaw.exe -cp c:\eclipse\startup.jar org.eclipse.core.launcher.Main -os win32 -ws win32 -arch x86 -showsplash c:\eclipse\eclipse.exe -vmargs -Xmx256M -Xss1024k -showsplash 600 So I'ld say that calling Eclipse we first call javaw which then calls eclipse and tells it its desired memory. Regards, Karl-Heinz. -----Urspr=FCngliche Nachricht----- Von: Avik Sengupta [mailto:avik.sengupta@itellix.com]=20 Gesendet: Donnerstag, 18. M=E4rz 2004 16:04 An: POI Users List Betreff: Re: AW: AW: can't open workbook Are you forking a separate JVM from eclipse to run your tests? That might have its own settings.=20 On Thu, 2004-03-18 at 19:19, Karl-Heinz Zengerle wrote: > Hi Avik. >=20 > The Excel file has 3 MB. The Java VM has 256 MB. In that case > (JSP-Tomcat) it runs successfully. >=20 > Eclipse itselfs seems not to react add the added start parameter > "-vmargs -Xmx256M" (which should increase the max heap size according to > the documentation). Even doubling this value didn't help. >=20 > Regards, Karl-Heinz. >=20 >=20 > -----Urspr=FCngliche Nachricht----- > Von: Avik Sengupta [mailto:avik.sengupta@itellix.com]=20 > Gesendet: Donnerstag, 18. M=E4rz 2004 14:40 > An: POI Users List > Betreff: Re: AW: can't open workbook >=20 > What's your file size? How much JVM memory are you using? if you are > calling from JSP or Eclipse, remember that tomcat(or any other > container)/eclipse itself will use up a large part of the available > memory.=20 >=20 > Check it out standalone first, then add the amount of heap required to > get it to run standalone to the heap setting while running tomcat or > eclipse.=20 >=20 > On Wed, 2004-03-17 at 16:44, Karl-Heinz Zengerle wrote: > > Hi world. > >=20 > > We could improve the situation to the following one: > >=20 > > The things are running being called from a JSP page. > > Being run or debugged in Ecplipse it still crashes with the out > > of > > memory error whatever VM memory we use. > >=20 > > All that happens at > > this.oiWB =3D new HSSFWorkbook(fs); > > i.e. when opening the Excel file and not having processed anything in > > our application. > >=20 > > Does anybody have a further idea? > >=20 > > Regards, Karl-Heinz. > >=20 > >=20 > > -----Urspr=FCngliche Nachricht----- > > Von: Karl-Heinz Zengerle [mailto:karl-heinz.zengerle@sawag.com]=20 > > Gesendet: Montag, 15. M=E4rz 2004 16:52 > > An: 'POI Users List' > > Betreff: AW: can't open workbook > >=20 > > Hi world. > >=20 > > Without shelter measures we receive an out of memory error now. > >=20 > > So I've the following questions: > > Which Excel things doesn't POI allow? > > Up to about what size normally Excel files can be opened without > > increasing the Java VM memory and without having problems? > >=20 > > Regards, Karl-Heinz. > >=20 > >=20 > > -----Urspr=FCngliche Nachricht----- > > Von: Karl-Heinz Zengerle [mailto:karl-heinz.zengerle@sawag.com]=20 > > Gesendet: Montag, 15. M=E4rz 2004 16:42 > > An: poi-user@jakarta.apache.org > > Betreff: can't open workbook > >=20 > > Hi world, > > =20 > > When our application processed the following command > > =20 > > this.oiWB =3D new HSSFWorkbook(fs); > > =20 > > the exception below is thrown. > > =20 > > java.lang.reflect.InvocationTargetException > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > > Method) > > at > > > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA > > ccessorImpl.java:39) > > at > > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons > > tructorAccessorImpl.java:27) > > at > java.lang.reflect.Constructor.newInstance(Constructor.java:274) > > at > > > org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java > > :257) > > at > > > org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.jav > > a:193) > > at > > > org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:207) > > at > > > org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:174) > > <-- POI > > at webCRT.XlCRTImport.(XlCRTImport.java:120) > > <-- our application > > at webCRT.XlCRTImport.importCRTFile(XlCRTImport.java:324) > > at webCRT.XlCRTTstImp.TestImportFiles(XlCRTTstImp.java:275) > > at webCRT.XlCRTImport.main(XlCRTImport.java:186) > > Caused by: java.lang.IllegalArgumentException: Illegal length > > at > > org.apache.poi.util.StringUtil.getFromUnicodeHigh(StringUtil.java:114) > > at > > org.apache.poi.hssf.record.FontRecord.fillFields(FontRecord.java:172) > > at org.apache.poi.hssf.record.Record.fillFields(Record.java:127) > > at org.apache.poi.hssf.record.Record.(Record.java:92) > > at > > org.apache.poi.hssf.record.FontRecord.(FontRecord.java:125) > > ... 12 more > > =20 > > Does anybody have an idea of possible reasons? Opening the workbook is > > the first POI action. So it can't be in our application. > > =20 > > Since several months small files where all sheets are visible and not > > locked in any way the application runs without problems. Now the Excel > > file has grown very much (around our basic handling) and some sheets > are > > hidden and some sheets are locked. > > =20 > > Regards, > > Karl-Heinz Zengerle > > =20 > >=20 > >=20 > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org > > For additional commands, e-mail: poi-user-help@jakarta.apache.org > >=20 > >=20 > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org > > For additional commands, e-mail: poi-user-help@jakarta.apache.org > >=20 >=20 >=20 > --------------------------------------------------------------------- > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org > For additional commands, e-mail: poi-user-help@jakarta.apache.org >=20 >=20 > --------------------------------------------------------------------- > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org > For additional commands, e-mail: poi-user-help@jakarta.apache.org >=20 --------------------------------------------------------------------- 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