Mybatis 报错java.sql.SQLException: No suitable driver found for http://www.example.com

不念不忘少年蓝@ 2021-09-21 15:22 257阅读 0赞

## 运行项目报错 ##

Error querying database. Cause: java.sql.SQLException: No suitable driver found for http://www.example.com

org.apache.ibatis.exceptions.PersistenceException: 
    ### Error querying database. Cause: java.sql.SQLException: No suitable driver found for http://www.example.com
    ### The error may exist in com/pro/dao/UserMapper.xml
    ### The error may involve com.pro.dao.UserMapper.getUserList
    ### The error occurred while executing a query
    ### Cause: java.sql.SQLException: No suitable driver found for http://www.example.com

## 我的 properties 配置文件是这样的 ##

driver=com.mysql.jdbc.Driver
    url=jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=UTF-8
    username=root
    password=123456

我查看了一下编译后的文件，发现我的 `mybatis-config.xml` 文件中的 `${url}` 被编译成了 `http://www.example.com`

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk1MzIyNw_size_16_color_FFFFFF_t_70]

`url` 这个变量被覆盖了，直接把 `url` 改成 `jdbcUrl`，运行项目问题解决

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
        <properties resource="db.properties"/>
    
        <environments default="development">
            <environment id="development">
                <transactionManager type="JDBC"/>
                <dataSource type="POOLED">
                    <property name="driver" value="${driver}"/>
                    <property name="url" value="${jdbcUrl}"/>
                    <property name="username" value="${username}"/>
                    <property name="password" value="${password}"/>
                </dataSource>
            </environment>
        </environments>
    </configuration>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk1MzIyNw_size_16_color_FFFFFF_t_70]: /images/20210920/35f7496be58c44c09b6ce1e67bcbdba2.png