Hi Mark.
Thanks for you attention. Yes, I have tempted to get 3.6 but unfortunately
the problem is present. I hope that someone identify a possible solution for
this issue.
MSB wrote:
>
> Hello again Alberto,
>
> I must admit that I would be tempted to get 3.6 or even the latest release
> of 3.7 to see if that helps at all though I do have to admit that I cannot
> say definitively that it will. The ooxml stream of the api which is used
> to process the newer xml based Excel files is very memory hungry largly
> due to the number of objects that are required to successfully parse the
> file I believe.
>
> It will be worth while having a search through the lists - both user and
> dev - as I am certain there will be other posts related to this issue. It
> may be the case that someone else has identified a possible solution to
> the the problem that you are facing. Unfortunately, I do not use this
> stream of the api regularly - well only when trying to develop examples
> for other users which are by their nature small - and so cannot really
> offer any further advise aside from recommending that you take a look at
> the eventusermode rather than the usermodel. Typically, applications that
> use the eventusermodel have a much smaller memory requirement.
>
> Yours
>
> Mark B
>
>
> Alberto Pedrera wrote:
>>
>> Hi Mark.
>>
>> I´m using the version of POI 3.5 and Java 1.6.0_14.
>>
>> Thanks in advance.
>>
>>
>> MSB wrote:
>>>
>>> Hello Alberto,
>>>
>>> Can I ask please which version of POI are you using? I know that there
>>> was a problem with releasing file handles in an earlier version of the
>>> api so it may be worth while downloading and using the very latest
>>> version if you are not already doing so.
>>>
>>> Yours
>>>
>>> Mark B
>>>
>>>
>>> Alberto Pedrera wrote:
>>>>
>>>> Hi all.
>>>>
>>>> I have this code.
>>>>
>>>> public static void main(String[] args) throws Exception{
>>>> try{
>>>> File input = new File("D:/test.xlsx");
>>>> System.out.println("Open the file");
>>>> Workbook wb = new XSSFWorkbook(new FileInputStream(input));
>>>> System.out.println("Open correctly");
>>>> while(true){
>>>> System.out.println("Clean the memory");
>>>> System.gc();
>>>> }
>>>> }catch(Exception e){
>>>> log.error("Error Main", e);
>>>> }
>>>> }
>>>>
>>>> My java process needs great deal of memory but when it executes "clean
>>>> the memory" this memory is never liberate. Test.xlsx has 25000 lines
>>>> and 50 columns and memory consume is 1300MB.
>>>> Someone can help me?
>>>>
>>>> Best regards.
>>>> Alberto.
>>>>
>>>
>>>
>>
>>
>
>
--
View this message in context:
http://old.nabble.com/Process-java-memory-tp28165914p28189059.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
