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-tp28165914p28188900.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]
