Hi Rodrigo, if I may quote myself (experienced exceptions in searching the mailing list archiv):
due to the wired BIFF format I reached the out-of-memory quite soon, too. There are small RAM ressources at my client side and I use the hack to send a bytestream with tab separation between the fields, store it with a *.xls extention so Excel open it with the data correct in columns. Doing it this way I'll lose all formatting but I'm able to display more the 20.000 records from the DB2 tables. Beyond the max. of 65.535 recs. Excel display no more lines in a file. I also made an outline to stream the data in blocks or serveral files, but that solution is to time consuming in my enviroment. An other tactic may be avoid fancy formatting and reuse the POI object as heavly a possible. hth, cu Stefan > -----Ursprüngliche Nachricht----- > Von: Rodrigo Martins Bejar [SMTP:[EMAIL PROTECTED] > Gesendet am: Donnerstag, 5. Januar 2006 14:22 > An: [email protected] > Betreff: Large files and the OutOfMemoryError > > Hi, > > I'll start the first thread of 2006 asking about the OutOfMemoryError. :) > Actually there is some reliable solution to create large files, around 40 > columns and 120k rows, using HSSF? > > I already tried set JVM param to -Xmx1024M and still ocurrs the problem. > My server has 4GB memory. > > Thanks, > > Rodrigo Martins > > ********************************************************************** > Informação transmitida destina-se apenas à pessoa a quem foi endereçada e > pode conter informação confidencial, legalmente protegida e para > conhecimento exclusivo do destinatário. Se o leitor desta advertência não > for o seu destinatário, fica ciente de que sua leitura, divulgação ou > cópia é estritamente proibida. Caso a mensagem tenha sido recebida por > engano, favor comunicar ao remetente e apagar o texto de qualquer > computador. > > > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon this information, by person or > entity other than the intended recipient is prohibited. If you received > this in error, please contact the sender and delete the material from any > computer. > ********************************************************************** > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
