Re: Issue with 5.2.3
Rob Sargent <[email protected]> Mon, 31 Oct 2022 11:02:36 -0600
| Newsgroups | gmane.comp.jakarta.poi.user |
|---|---|
| Message-ID | <[email protected]> |
On 10/31/22 10:10, Campbell, Lance wrote:
> I just started working with POI. . I am just writing out an Excel document. I pulled down the project using Maven for 5.2.3 .
>
> In eclipse everything compiled fine. When I deployed the software to Tomcat I got this error message:
>
> Exception in thread "Thread-6" java.lang.NoSuchMethodError: org.apache.logging.log4j.util.LoaderUtil.getClassLoaders()[Ljava/lang/ClassLoader;
>
> The line it was failing on is the last line listed below "new XSSFWorkbook()":
>
> XSSFWorkbook workbook = null;
> //
> ClassLoader classloader = org.apache.poi.poifs.filesystem.POIFSFileSystem.class.getClassLoader();
> URL res = classloader.getResource("org/apache/poi/xssf/usermodel/XSSFWorkbook.class");
> String path = res.getPath();
> System.out.println("POI Core came from " + path);
> //
> // line with error is below
> workbook = new XSSFWorkbook();
>
>
> After reading some documentation I put in the code directly above the line that was failing. The display showed that the code was found.
> POI Core came fromfile:/folder1/folder2/folder3/application/webapps/ROOT/WEB-INF/lib/poi-ooxml-5.2.2.jar!/org/apache/poi/xssf/usermodel/XSSFWorkbook.class
>
> I tried rebuilding the project in Eclipse and also updating Maven. After redeploying I kept getting the same error message.
>
> I then changed the version to 5.2.2 and everything worked fine. I am wondering if there might be an issue with 5.2.3 .
>
> MAVEN that did NOT work:
>
> <dependencies>
> <dependency>
> <groupId>webserviceslib</groupId>
> <artifactId>webserviceslib</artifactId>
> <version>0.0.1-SNAPSHOT</version>
> </dependency>
> <dependency>
> <groupId>org.apache.poi</groupId>
> <artifactId>poi</artifactId>
> <version>5.2.3</version>
> </dependency>
> <dependency>
> <groupId>org.apache.poi</groupId>
> <artifactId>poi-ooxml</artifactId>
> <version>5.2.3</version>
> </dependency>
> </dependencies>
>
> MAVEN that does work:
>
> <dependencies>
> <dependency>
> <groupId>webserviceslib</groupId>
> <artifactId>webserviceslib</artifactId>
> <version>0.0.1-SNAPSHOT</version>
> </dependency>
> <dependency>
> <groupId>org.apache.poi</groupId>
> <artifactId>poi</artifactId>
> <version>5.2.2</version>
> </dependency>
> <dependency>
> <groupId>org.apache.poi</groupId>
> <artifactId>poi-ooxml</artifactId>
> <version>5.2.2</version>
> </dependency>
> </dependencies>
>
> Thanks,
> Lance Campbell
> Web Services @ Public Affairs @ University of Illinois
>
>
>
Can you build the POI parts NOT in eclipse and deploy that. IDE are
notorious for "helping".