Four Stars

Incompatibility between tJasperReportExec and tFileInPutExcel in TDI 6.3.1

Hello,

There's a mismatch with poi lib when using tFileInputExcel with Excel 2007 format and tJasperReportExec.


tFileInputExcel/tFileInputExcel_java.xml :

<IMPORT NAME="poi" MODULE="poi-3.11-20141221_modified_talend.jar" MVN="mvnSmiley Surprisedrg.talend.libraries/poi-3.11-20141221_modified_talend/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.excel/lib/poi-3.11-20141221_modified_talend.jar" REQUIRED_IF="(VERSION_2007 == 'true')" />

tJasperReportExec/pom.xml :

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.16</version>
    <exclusions>
        <exclusion>
            <artifactId>stax-api</artifactId>
            <groupId>stax</groupId>
        </exclusion>
    </exclusions>
</dependency>

So when using both components in the same job, an exception occurs :

Exception in thread "main" java.lang.NoSuchMethodError: org.apache.poi.util.POILogger.log(ILjava/lang/ObjectSmiley WinkV
at org.apache.poi.openxml4j.opc.PackageRelationshipCollection.parseRelationshipsPart(PackageRelationshipCollection.java:313)
at org.apache.poi.openxml4j.opc.PackageRelationshipCollection.<init>(PackageRelationshipCollection.java:163)
at org.apache.poi.openxml4j.opc.PackageRelationshipCollection.<init>(PackageRelationshipCollection.java:131)
at org.apache.poi.openxml4j.opc.PackagePart.loadRelationships(PackagePart.java:559)
at org.apache.poi.openxml4j.opc.PackagePart.<init>(PackagePart.java:112)
at org.apache.poi.openxml4j.opc.PackagePart.<init>(PackagePart.java:83)
at org.apache.poi.openxml4j.opc.PackagePart.<init>(PackagePart.java:128)
at org.apache.poi.openxml4j.opc.ZipPackagePart.<init>(ZipPackagePart.java:78)
at org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java:243)
at org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:673)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:226)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:186)
at org.apache.poi.POIXMLDocument.openPackage(POIXMLDocument.java:74)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:296)

Except desactivating 2007 feature, do you have any suggestion ?

Thanks in advance,

Lionel
 

PS : I have open an issue on composant GitHub repository : https://github.com/jlolling/talendcomp_tJasperReportExec/issues/1

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

Re: Incompatibility between tJasperReportExec and tFileInPutExcel in TDI 6.3.1

Hello,

The tJasperReportExec is a custom component written by talend community user and shared on talend exchange portal.

The third party custom components on Talend Exchange are not supported by Talend, since we don't have the source code of these components.  It is the ownership of the person who built it.

Feel free to contact the author please.

Best regards

Sabrina

 

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
1 REPLY
Moderator

Re: Incompatibility between tJasperReportExec and tFileInPutExcel in TDI 6.3.1

Hello,

The tJasperReportExec is a custom component written by talend community user and shared on talend exchange portal.

The third party custom components on Talend Exchange are not supported by Talend, since we don't have the source code of these components.  It is the ownership of the person who built it.

Feel free to contact the author please.

Best regards

Sabrina

 

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.