记一次解决jar包版本冲突

迷南。 2021-12-23 02:53 871阅读 0赞

*  背景

当时是在将Excel导出从POI转成使用EasyExcel

POI使用的maven坐标如下：

<dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi</artifactId>
      <version>3.8</version>
    </dependency>
    <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi-ooxml</artifactId>
      <version>3.8</version>
    </dependency>

EasyExcel添加的maven坐标如下：

<dependency>
    	<groupId>com.alibaba</groupId>
    	<artifactId>easyexcel</artifactId>
    	<version>1.1.2-beat1</version>
    </dependency>

编写好代码debug启动项目，启动没任何报错，在执行改方法时，控制台报错了，报错信息如下：

org.springframework.web.util.NestedServletException: Handler dispatch failed; nested exception is java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Font.setBold(Z)V
    	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:978)
    	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
    	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
    	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
    	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.doFilterInternal(ApplicationContextHeaderFilter.java:55)
    	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:110)
    	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:167)
    	at org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:80)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
    	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106)
    	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
    	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
    	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
    	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
    	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
    	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    	at java.lang.Thread.run(Thread.java:748)
    Caused by: java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Font.setBold(Z)V
    	at com.alibaba.excel.util.StyleUtil.buildDefaultCellStyle(StyleUtil.java:22)
    	at com.alibaba.excel.context.WriteContext.<init>(WriteContext.java:99)
    	at com.alibaba.excel.write.ExcelBuilderImpl.<init>(ExcelBuilderImpl.java:38)
    	at com.alibaba.excel.ExcelWriter.<init>(ExcelWriter.java:58)
    	at com.alibaba.excel.ExcelWriter.<init>(ExcelWriter.java:34)
    	at com.wyj.controller.EasyExcelDemo.findAllExcelByEasyExcel(EasyExcelDemo.java:45)
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:498)
    	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
    	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
    	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
    	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
    	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
    	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
    	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
    	... 47 common frames omitted

*  报错信息大概的信息是说  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1NjIwNTAx_size_16_color_FFFFFF_t_70]  
    在at com.alibaba.excel.util.StyleUtil类中的buildDefaultCellStyle方法中没找到setBold(Z)V这个方法，点进StyleUtil这个类的源码中，找到setBold(Z)V这个方法，在这里调用了org.apache.poi.ss.usermodel.Font类的setBold(Z)V方法，从源码中进入Font类中，发现的确没有setBold(Z)V这个方法，但是不科学啊，EasyExcel底层是封装了POI的，那么它里面一定引用了POI的jar包，相当于调用自己内部代码的方法，不可能会找不到方法啊
 *  突然意识到  
    ![在这里插入图片描述][20190701152320735.png]  
    既然EasyExcel内部引用了POI的jar包，但是我本来的pom.xml文件中也引用POI的jar，会不会是jar包版本冲突造成的呢？接下来，分别查看了本身pom.xml引用POI的版本，为3.8，EasyExcel版本1.1.2-beat1内部引用的POI版本为3.17
 *  确认猜测

那么就到POI版本为3.8和3.17当中找到org.apache.poi.ss.usermodel.Font类看是否有setBold(Z)V这个方法  
![在这里插入图片描述][20190701152333620.png]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1NjIwNTAx_size_16_color_FFFFFF_t_70 1]  
发现在POI3.8版本中Font这个类中并没有setBold(Z)V这个方法，但是在POI3.17版本中Font这个类中却有setBold(Z)V这个方法

*  确认原因

至此，差不多可以知道到底是什么原因造成控制台抛出这异常了：原因是EasyExcel 1.1.2-beat1版本中本应使用POI 3.17版本中的代码，但是由于版本冲突却使用了POI 3.8版本中的代码，造成类中方法找不到而抛出这个异常的

*  那么为什么会造成版本冲突呢？

maven在做版本管理时有一个重要的原则就是就近原则。啥是就是就近原则呢？就拿本例子来说，POI 3.8版本距离当前jar更近，而POI3.17版本更远(POI 3.17版本还经过了一层EasyExcel 1.1.2-beat1版本)，所以在maven版本管理中，将使用POI 3.8版本

*  那么如何解决呢？

将自身pom.xml文件中的POI 3.8依赖注释掉即可

*  注释了再ReImport

发现还是报这个错

*  还存在的问题

突然想到会不会是依赖其他模块，在其他模块中也依赖了POI 3.8版本，导致在依赖的过程中也将依赖中的POI 3.8版本的jar也依赖进来了，IDEA使用Ctrl+Shirt+F全项目搜索poi，发现果然在依赖的模块中也存在。

*  那么如何解决呢？

在模块的依赖中除去POI的jar包

<dependency>
    	<groupId>com.wyj</groupId>
    	<artifactId>test</artifactId>
    	<version>0.0.1.RELEASE</version>
    </dependency>

换成

<dependency>
    	<groupId>com.wyj</groupId>
    	<artifactId>test</artifactId>
    	<version>0.0.1.RELEASE</version>
    	<exclusions>
    		<exclusion>
    			<groupId>org.apache.poi</groupId>
    			<artifactId>poi</artifactId>
    		</exclusion>
    		<exclusion>
    			<groupId>org.apache.poi</groupId>
    			<artifactId>poi-ooxml</artifactId>
    		</exclusion>
    		<exclusion>
    			<groupId>org.apache.poi</groupId>
    			<artifactId>poi-ooxml-schemas</artifactId>
    		</exclusion>
    	</exclusions>
    </dependency>

*  完成之后再ReImport

运行完美解决

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1NjIwNTAx_size_16_color_FFFFFF_t_70]: /images/20211223/72e0e399488c430585019158fd6cc5f4.png
[20190701152320735.png]: /images/20211223/ad13b5c44e2f46fdaf2bbdeb864905b8.png
[20190701152333620.png]: /images/20211223/b21cec4302ee4cadad4fca42d66960a5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1NjIwNTAx_size_16_color_FFFFFF_t_70 1]: /images/20211223/7dd5ea70c55047efbeee98e403b43eaa.png