Servlet appServlet的HTTP状态500-Servlet.init（）在spring MVC中引发异常

Question

在stackoverflow中有很多这样的错误，但我无法解决我的问题。下面是我的简单配置：

来自TOMCAT服务器的context.xml，我在该服务器上配置了用于访问oracle 11g服务器的数据源

<?xml version="1.0" encoding="UTF-8"?>
<Context>

    <WatchedResource>WEB-INF/web.xml</WatchedResource>
    <WatchedResource>${catalina.base}/conf/web.xml</WatchedResource>

    <!--Oracle DataSource-->
        <Resource
             name="jdbc/MonDataSource"
             auth="Container"
             type="javax.sql.DataSource"
             driverClassName="oracle.jdbc.OracleDriver"
             url="jdbc:oracle:thin:@localhost:1521:orcl"
             username="system"
             password="Azerty123"
             connectionProperties="SetBigStringTryClob=true"
             accessToUnderlyingConnectionAllowed="true"
             maxTotal="60"
             maxIdle="20"
             maxWaitMillis="10000"
         />

</Context>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">

    <!-- The definition of the Root Spring Container shared by all Servlets and Filters -->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>/WEB-INF/spring/root-context.xml</param-value>
    </context-param>

    <!-- Creates the Spring Container shared by all Servlets and Filters -->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>

    <!-- Processes application requests -->
    <servlet>
        <servlet-name>appServlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>/WEB-INF/spring/appServlet/servlet-context.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>

    <servlet-mapping>
        <servlet-name>appServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

</web-app>

servlet-context.xml以显示我的bean配置

    <beans:bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
        <beans:property name="jndiName" value="java:comp/env/jdbc/MonDataSource"/>
    </beans:bean>

    <beans:bean id="ArticleDAO" class="com.projet.testjdbc.ArticleDAOImpl">
        <beans:constructor-arg>
            <beans:ref bean="dataSource" />
        </beans:constructor-arg>
    </beans:bean>

</beans:beans>

我不知道它是否有用，但你的动作低于我的控制

@Controller
public class HomeController {

    @Autowired
    private ArticleDAO aricleDAO;

    @RequestMapping(value="/liste")
    public ModelAndView home() throws IOException{
        List<Article> listArticles = aricleDAO.list();
        ModelAndView model = new ModelAndView("home");
        model.addObject("articleListe", listArticles);
        return model;
    }

}

例外信息

异常javax.servlet.ServletException:servlet appServlet的servlet.init（）引发异常org.apache.catalina.authenticator.AuthenticatorBase.invoke（AuthenticatorBase.java:502）org.apache.catalina.valves.ErrorReportValve.invoke（ErrorReportValve.java:79。。。

根本原因org.springframework.beans.factory.不满意依赖异常：创建名为“家庭控制器”的bean时出错：通过字段“aricleDAO”表示的不满意依赖；嵌套异常是org.springframework.beans.factory.BeanCreation异常：创建名为“ArticleDAO”的bean时出错：无法内省bean类[com.projet.testjdbc.ArticleDAOImpl用于查找元数据的方法：找不到它所依赖的类；嵌套异常java.lang.NoClassDefFoundError： org/springframe/jdbc/core/RowMapperorg.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcator$autowiredFieldElement.inject（AutowiredAnnotationBeanPostProcessor.java:588）org.springframework.beans.factory.annotation.注入Metadata.inject（注入Metadata.java:88）org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperty tyValue（AutowiredAnnotationBeanPostProcessor.java:366）org.springframework.beans.factory.support.AbstractautowireCapableBeanFactory.populateBean（AbstractautowireCapableBeanFactory.java:1264）org.springframework.beans.factory.support.AbstractautowireCapableBeanFactory.doCreateBean（AbstractAutowireCapableBeanFactory.java:553）org.springframework.beans.factory.support.AbstractautowireCapableBeanFactory. createBean（AbstractautowireCapableBeanFactory. java： 483）...

根本原因org.springframework.beans.factory.BeanCreationException:创建名为“ArticleDAO”的bean时出错：未能为查找方法元数据内省bean类[com.projet.testjdbc.ArticleDAOImpl]：找不到它所依赖的类；嵌套的异常是java.lang.NoClassDefFoundError:org/springframework/jdbc/core/RowMapper org.springframework.beans.factory.annotation.AutoWiredNotationBeanPostProcessor.determineCandidateConstructors（AutoWiredNotationBeanPostProcessor.java:269）org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.determineConstructorsFromBeanPostProcessors（AbstractAutowireCapableBeanFactory.java:1118）org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance（AbstractAutowireCapableBeanFactory.java:1091）org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean（AbstractAutowireCapableBeanFactory.java:513）org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:483）org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject（AbstractBeanFactory.java:306）。。。

根本原因java.lang.NoClassDefFoundError:org/springframework/jdbc/core/RowMapper java.lang.Class.getDeclaredMethods0（本机方法）java.lang.Class.privateGetDeclaredMethods（未知源）java.lang.Class.getDeclaredMethods（未知源）org.springframework.util.ReflectionUtils.getDeclaredMethods（ReflectionUtils.java:613）org.springframework.util.ReflectionUtils.doWithMethods（ReflectionUtils.java:524）org.springframework.util.ReflectionUtils.doWithMethods（ReflectionUtils.java:510）org.springframework.beans.factory.annotation.AutoWiredNotationBeanPostProcessor.DetermineCandateConstructors（AutoWiredNotationBeanPostProcessor.java:247）。。。

根本原因java.lang.ClassNotFound异常：org.springframework.jdbc.core.行映射器

org.apache.catalina.loader.WebappClassLoaderBase.loadClass（WebappClassLoaderBase.java:1333）org.apache.catalina.loader.WebappClassLoaderBase.loadClass（WebappClassLoaderBase.java:1167）java.lang.Class.getDeclaredMethods0（本机方法）java.lang.Class.privateGetDeclaredMethods（未知源）java.lang.Class.getDeclaredMethods（未知源）org.springframework.util.ReflectionUtils.getDeclaredMethods（ReflectionUtils.java:613）org.springframework.util.ReflectionUtils.doWithMethods（ReflectionUtils.java:524）。。。

Answer 1

root cause java.lang.ClassNotFoundException: org.springframework.jdbc.core.RowMapper

看起来你错过了一个依赖项。将此添加到maven（如果使用）

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>2.0.6</version>
</dependency>

如果没有，则将.jar添加到类路径