Mybatis+spring错误：java.sql.SQLException: ${jdbc.driverClassName}

最新推荐文章于 2022-10-21 19:53:05 发布

sinat_38719275

最新推荐文章于 2022-10-21 19:53:05 发布

阅读量1.8k

点赞数

文章标签： spring Mybatis jdbc连接报错

本文链接：https://blog.youkuaiyun.com/sinat_38719275/article/details/102528537

版权

本文记录了一次在整合Mybatis和Spring时遇到的错误：${jdbc.driverClassName}，该错误源于在`applicationContext.xml`中错误配置了`default-autowire`。解决方案是删除`default-autowire="byName"`，以避免影响SQLSessionFactory的生命周期，导致无法加载数据库配置。修复后问题得到解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

记录一次错误

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://www.springframework.org/schema/aop/spring-aop-4.3.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd" default-autowire="byName">
		
		<!--省略其他配置内容.......-->
		
		<!-- 配置SQLSessionFactory -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="druidDataSource" />
		<property name="mapperLocations" value="classpath*:mapper/*.xml"/>
			
		<!-- 给实体类下包下的类起别名 -->
		<property name="typeAliasesPackage" value="com.ssm.entity" />
	</bean>
	
	<!-- 配置自动扫描mapper层接口 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.ssm.mapper" />
		
		<!-- 一定要通过sqlSessionFactoryBeanName， 不要通过sqlSessionFactory ref加载这样会导致无法读取properties配置文件 -->
		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
	</bean>

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://www.springframework.org/schema/aop/spring-aop-4.3.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">
		
		<!--省略其他配置内容.......-->
		
		<!-- 配置SQLSessionFactory -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="druidDataSource" />
		<property name="mapperLocations" value="classpath*:mapper/*.xml"/>
			
		<!-- 给实体类下包下的类起别名 -->
		<property name="typeAliasesPackage" value="com.ssm.entity" />
	</bean>
	
	<!-- 配置自动扫描mapper层接口 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.ssm.mapper" />
		
		<!-- 一定要通过sqlSessionFactoryBeanName， 不要通过sqlSessionFactory ref加载这样会导致无法读取properties配置文件 -->
		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
	</bean>

OK问题解决了！希望对各位有所帮助。