Invalid property 'driver' of bean class [org.apache.commons.dbcp.BasicDataSource]

布满荆棘的人生 2021-08-28 17:32 252阅读 0赞

Spring整合MyBatis！

main方法测试，出现异常：

![format_png][]

一堆错，很懵逼！

别慌，慢慢分析，也许错误很简单；

先分析一下applicationContext.xml文件

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
    
    	<bean id="config" class="org.springframework.beans.factory.config.PreferencesPlaceholderConfigurer">
    		<property name="locations">
    			<array>
    				<value>classpath:db.properties</value>
    			</array>
    		</property>
    	</bean>
    
    	 <bean id="studentService" class="com.guor.service.impl.StudentServiceImpl">
    		<property name="studentMapper" ref="studentMapper"></property>
    	</bean>
    	
    	
    	
    	
    	
    	
    	
    	<bean id="mappers" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>  
    		
    		<property name="basePackage" value="com.guor.mapper"></property>  
    	</bean>
    
    	
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    		<property name="driver" value="${driver}"></property>
    		<property name="url" value="${url}"></property>
    		<property name="username" value="${username}"></property>
    		<property name="password" value="${password}"></property>
    	</bean> 
    	
    	 
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		<property name="dataSource" ref="dataSource"></property>
    		<property name="mapperLocations" value="com/guor/mapper/*.xml"></property>
    	</bean> 
    </beans>

分析思路：

1、全部注掉；

2、放开对外层的那一部分；

dataSource

dataSource是org.apache.commons.dbcp.BasicDataSource中的

![format_png 1][]

不难发现BasicDataSource中的驱动项不是普通的driver，而是driverClassName；

运行：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b3J1aV9qYXZh_size_16_color_FFFFFF_t_70][]

输出发现是用set方法注入的，并且数据库中数据增加成功，success！

[format_png]: /images/20210813/cd82e81fd01c4db390530dcfa9776c8e.png
[format_png 1]: /images/20210813/e8f8111cf30741ecb1fbc658abe6ef79.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b3J1aV9qYXZh_size_16_color_FFFFFF_t_70]: /images/20210813/7607173b43f945ed9ea38644aef320e7.png