Incompatibility between tJasperReportExec and tFileInPutExcel in TDI 6.3.1

lfrugere — Sat, 16 Nov 2024 09:00:40 GMT

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="mvnrg.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/ObjectV
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

Re: Incompatibility between tJasperReportExec and tFileInPutExcel in TDI 6.3.1

Anonymous — Thu, 30 Nov 2017 07:10:22 GMT

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

topic Re: Incompatibility between tJasperReportExec and tFileInPutExcel in TDI 6.3.1 in Talend Studio

Incompatibility between tJasperReportExec and tFileInPutExcel in TDI 6.3.1

Re: Incompatibility between tJasperReportExec and tFileInPutExcel in TDI 6.3.1