解决mybatis异常org.apache.ibatis.exceptions.PersistenceException

 org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.sql.SQLException: No suitable driver found for jdbc.mysql://localhost:3306/mybatis01?serverTimezone=UTC
### The error may exist in userMapper.xml
### The error may involve mapper.UserMapper.getUserlist
### The error occurred while executing a query
### Cause: java.sql.SQLException: No suitable driver found for jdbc.mysql://localhost:3306/mybatis01?serverTimezone=UTC

写mybatis时遇见的
之前mybatis-config.xml代码

<?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>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="com.mysql.cj.jdbc.Driver"/><!--driver-->
        <property name="url" value="jdbc.mysql://localhost:3306/mybatis01?serverTimezone=UTC"/><!--数据库连接-->
        <property name="username" value="root"/><!--名字-->
        <property name="password" value="521314"/><!--密码-->
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="userMapper.xml"/>
  </mappers>
</configuration>

解决方法:

  <property name="url" value="jdbc.mysql://localhost:3306/mybatis01?serverTimezone=UTC"/><!--数据库连接-->

改为:

  <property name="url" value="jdbc:mysql://localhost:3306/mybatis01?serverTimezone=UTC"/><!--数据库连接-->

重点是jdbc:mysql而不是jdbc.mysql

Logo

有“AI”的1024 = 2048,欢迎大家加入2048 AI社区

更多推荐