Update version library

One Star

Update version library

Hello everybody,
I would like to know if it's possible to update a version of library.
For example, at the moment, TOS has the version 3.6 of poi.jar.
I would like to add the version 3.8. Is it possible to do?
Sorry for my english.
Best regards
Skycer666
One Star

Re: Update version library

Hi
Welcome to Talend Community!
If you are familiar with component creation, updating jar file is easy for you.
If not, this behavior may lead to unexpected errors when you create a talend job.
Which version of TOS do you use?
I notice that poi.jar is related to tFileInputExcel component. It has been updated to 3.8 in TOS 5.1.0.
Regards,
Pedro
One Star

Re: Update version library

Hey Pedro.
Thank you for your response.
I use the version 4.2.2 of Talend.
Yesterday, I installed the version 5.1 and effectively there is the version 3.8 of Poi.
If I copy the library 3.8 of Poi in my directory "lib" of Talend (4.2.2), is it dangerous ?
Do you can replace the version 3.6 of Poi by the version 3.8 ?
Regards.
Skycer666
One Star

Re: Update version library

Hi
I think copying the entire component directory from <TOS installation dir>\plugins\org.talend.designer.components.localprovider is more safe than that you just copy jar file.
But I'm not sure whether you will encounter incompatible issue or unexpected error.
Why don't you just update TOS version?
Regards,
Pedro
One Star

Re: Update version library

I'm trying to update TOS Version.
I'm going to import my different jobs and I will see if all jobs works.
One Star

Re: Update version library

On a job that works with the version 4.2 of Talend, I have an error now with the version 5.1.
Exception in component tFileOutputExcel_1
java.lang.NullPointerException
at org.apache.poi.ss.util.SheetUtil.getCellWidth(SheetUtil.java:120)
at org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:217)
at org.apache.poi.xssf.streaming.SXSSFSheet.autoSizeColumn(SXSSFSheet.java:1153)
at org.talend.ExcelTool.setColAutoSize(ExcelTool.java:261)
at ....

An error on a Excel file justly ?
One Star

Re: Update version library

Hi
Could you show us more detail? The job? The settings?
Regards,
Pedro
One Star

Re: Update version library

The job is very complicated.
One Star

Re: Update version library

Hi
Please show us the settings of tFileOutputExcel_1.
Regards,
Pedro
One Star

Re: Update version library

Hi
The images you uploaded are about tFileInputExcel.
But the error indicates tFileOutputExcel.
Regards,
Pedro
One Star

Re: Update version library

Exact !!!
I'm going to watch that!
I just uncheck the checkbox "Define a auto-size on all columns" (in French "Définir une taille auto sur toutes les colonnes") and it works !!
Thank you very much Pedro