Re: Issue with 5.2.3

 The issue is with your log4j jars. They are not matching up with each other.POI 5.2.3 defaults to log4j-api 2.18.0.
There are a lot of things that go wrong with deploying logging jars and I think you would be better off reading the log4j docs and checking stackoverflow.com for details about how to set up log4j logging in Tomcat.
Tomcat might have a different version of log4j and you might need to do some configuration of your web.xml deployment descriptor - again best to ask a Tomcat expert about that.


    On Monday 31 October 2022 at 16:49:48 GMT, Campbell, Lance <[email protected]> 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 from file:/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