java问题-PersistenceException

__BC__

墨衍会员 · AI 创作全网分发码龄7年

关注

原创最新推荐文章于 2026-05-08 09:19:35 发布 867 阅读 AI 写同款· GEO 优化 ›

Exception in thread “main“ org.apache.ibatis.exceptions.PersistenceException: MyBatis框架使用出现的问题阅读详情

Exception in thread “main” org.apache.ibatis.exceptions.PersistenceException

在使用mybatis连接数据库的时候遇到如下错误:

Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNotFoundException: Cannot find class: com.mysql.cj.jdbc.Driver
### The error may exist in com/bjpowernode/dao/StudentDao.xml
### The error may involve com.bjpowernode.dao.StudentDao.selectStudents
### The error occurred while executing a query
### Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNotFoundException: Cannot find class: com.mysql.cj.jdbc.Driver
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:135)
	at com.bjpowernode.MyApp.main(MyApp.java:30)
Caused by: java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNotFoundException: Cannot find class: com.mysql.cj.jdbc.Driver
	at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.initializeDriver(UnpooledDataSource.java:221)
	at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:200)
	at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:196)
	at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:93)
	at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:403)
	at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:89)
	at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:138)
	at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:60)
	at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
	... 3 more

出现以上问题的原因是：
- url原先配置如下：
  - 127.0.0.1表示本地
  - books:表示books数据库，根据自己的修改

 <property name="url" value="jdbc:mysql://127.0.0.1:3306/books"/>

修改成如下，解决问题
- 修改1

 <property name="url" value="jdbc:mysql://127.0.0.1:3306/books?useSSL=false&amp; serverTimezone=UTC"/>

修改2
- 从idea中导入mysql-connector-java.jar

收录于

java_bug

标签

#java #哈希算法 #开发语言

报错：Exception in thread “main“ org.apache.ibatis.exceptions.PersistenceException: （解决办法） Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: java.sql.SQLException: The server time 遇到红色这种问题的原因有很多，那就要根据第二行来判断。说明数据库连接的问题报错了，改数据库时区就好了。用mybatis去sql语句的时候报错了。：mishop是自己的数据库名称。第二行黄色报的这个是。阅读详情

java问题-PersistenceException

Exception in thread “main” org.apache.ibatis.exceptions.PersistenceException

相关推荐