【Mybatis配置DataSource的properties外部载入失败 _mybatis 】

Mybatis配置DataSource的properties外部载入失败

我也踩过这个坑( 1 )

已统计您的踩坑,无需重复点击

回答(0)

mybatis

详细描述

错误截图

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       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/context  http://www.springframework.org/schema/context/spring-context.xsd">

<context:component-scan base-package="finalDemo.test,finalDemo.DAO"/>

<!--    <!– 引用外部properties配置Spring自带连接 –>
   <!–引入PropertyPlaceholderConfigurer外部jdbc配置properties文件 –>
        <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="locations" value="classpath*:jdbcDataSource.properties"/>
      </bean>

<!–加载DriverManagerDataSource外部jdbc配置文件–>
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="${driverClass}"/>
        <property name="url" value="${jdbcUrl}"/>
        <property name="password" value="${password}"/>
        <property name="username" value="${user}"/>
    </bean>-->

<context:property-placeholder location="classpath:jdbc.properties" />
    
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">
        
        <property name = "url" value = "${Druid.url}" />
        <property name = "username" value = "${jdbc.username}" />
        <property name = "password" value = "${jdbc.password}" />
        <property name = "driverClassName" value = "${jdbc.driverClassName}" />
        <property name = "filters" value = "${jdbc.filters}" />
        
        <property name = "maxActive" value = "${jdbc.maxActive}" />
        
        <property name = "initialSize" value = "${jdbc.initialSize}" />
        
        <property name = "maxWait" value = "${jdbc.maxWait}" />
        
        <property name = "minIdle" value = "${jdbc.minIdle}" />
        
        <property name = "timeBetweenEvictionRunsMillis" value ="${jdbc.timeBetweenEvictionRunsMillis}" />
        
        <property name = "minEvictableIdleTimeMillis" value ="${jdbc.minEvictableIdleTimeMillis}" />
        
        <property name = "validationQuery" value = "${jdbc.validationQuery}" />
        
        <property name = "testWhileIdle" value = "${jdbc.testWhileIdle}" />
        
        <property name = "testOnBorrow" value = "${jdbc.testOnBorrow}" />
        
        <property name = "testOnReturn" value = "${jdbc.testOnReturn}" />
        
        <property name = "removeAbandoned" value = "${jdbc.removeAbandoned}" />
        
        <property name = "removeAbandonedTimeout" value ="${jdbc.removeAbandonedTimeout}" />
        
        <property name = "logAbandoned" value = "${jdbc.logAbandoned}" />

</bean>

<bean id="jdbcConn" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>

编辑于2024-11-19