topic Re: Update version library in Talend Studio

Update version library

Anonymous — Mon, 21 May 2012 15:00:27 GMT

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

Re: Update version library

Anonymous — Tue, 22 May 2012 04:19:49 GMT

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

Re: Update version library

Anonymous — Tue, 22 May 2012 07:51:17 GMT

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

Re: Update version library

Anonymous — Tue, 22 May 2012 07:55:58 GMT

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

Re: Update version library

Anonymous — Tue, 22 May 2012 08:08:13 GMT

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

Re: Update version library

Anonymous — Tue, 22 May 2012 08:36:06 GMT

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 ?

Re: Update version library

Anonymous — Tue, 22 May 2012 08:37:58 GMT

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

Re: Update version library

Anonymous — Tue, 22 May 2012 08:51:05 GMT

The job is very complicated.

Re: Update version library

Anonymous — Tue, 22 May 2012 08:57:16 GMT

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

Re: Update version library

Anonymous — Tue, 22 May 2012 09:02:44 GMT

Schema :
http://www.hiboox.fr/go/images/informatique/setting2,b83b95301299fba27e28bbe0cbbde114.jpg.html

Settings :
http://www.hiboox.fr/go/images/informatique/setting1,eecb53edd8d02993558edf1cd52fd14f.jpg.html

Re: Update version library

Anonymous — Tue, 22 May 2012 09:04:53 GMT

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

Re: Update version library

Anonymous — Tue, 22 May 2012 09:07:22 GMT

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