记录一次错误
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: ${jdbc.driverClassName} ### The error may exist in file [E:\testdemo.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\ssm\WEB-INF\classes\mapper\UserMapper.xml] ### The error may involve com.ssm.system.mapper.UserMapper.selUserByAccount ### The error occurred while executing a query ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: ${jdbc.driverClassName}
原因
在applicationContext.xml中配置了 default-autowire=“byName”,而后面配置SQLSessionFactory用的是name=“sqlSessionFactoryBeanName” value=“sqlSessionFactory” 因为default-autowire="byName"改变了它的生命周期,导致加载不到数据库配置文件db.properties因此出错。所以删掉default-autowire="byName"就好了。
解决
applicationContext.xml修改前:
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/aop http:/