Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2012-05-21 11:00 AM

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
Labels (2)
Labels
523 Views
0 Likes
11 Replies
Anonymous
Not applicable
‎2012-05-22 12:19 AM
Author

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
445 Views
0 Likes
Anonymous
Not applicable
‎2012-05-22 03:51 AM
Author

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
445 Views
0 Likes
Anonymous
Not applicable
‎2012-05-22 03:55 AM
Author

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
445 Views
0 Likes
Anonymous
Not applicable
‎2012-05-22 04:08 AM
Author

I'm trying to update TOS Version.
I'm going to import my different jobs and I will see if all jobs works.
445 Views
0 Likes
Anonymous
Not applicable
‎2012-05-22 04:36 AM
Author

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 ?
445 Views
0 Likes
Anonymous
Not applicable
‎2012-05-22 04:37 AM
Author

Hi
Could you show us more detail? The job? The settings?
Regards,
Pedro
445 Views
0 Likes
Anonymous
Not applicable
‎2012-05-22 04:51 AM
Author

The job is very complicated.
445 Views
0 Likes
Anonymous
Not applicable
‎2012-05-22 04:57 AM
Author

Hi
Please show us the settings of tFileOutputExcel_1.
Regards,
Pedro
445 Views
0 Likes