【bug日记2020-10-10】 Error querying database --mybatis类bug

最新推荐文章于 2023-10-09 10:31:56 发布
最新推荐文章于 2023-10-09 10:31:56 发布
阅读量558 收藏
点赞数
分类专栏： bug日记 文章标签： mybatis java bug jdbc
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_46464940/article/details/109004109
版权

【bug日记2020-10-10】 Error querying database. Cause: java.sql.SQLException: No suitable driver found for https://www.mybatis.org/mybatis-test/

在idea中引入mybatis源码，然后使用 .properties 文件对 mybatis-config.xml 文件配置 jdbc， 运行测试代码，发现此bug，异常如下代码，说找不到适合的驱动程序

Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.sql.SQLException: No suitable driver found for https://www.mybatis.org/mybatis-test/
### The error may exist in mapper/GoodsMapper.xml
### The error may involve org.example.mapper.GoodsMapper.selectById
### The error occurred while executing a query
### Cause: java.sql.SQLException: No suitable driver found for https://www.mybatis.org/mybatis-test/
	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.selectOne(DefaultSqlSession.java:76)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
	at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85)
	at com.sun.proxy.$Proxy18.selectById(Unknown Source)
	at org.example.Test.main(Test.java:30)
Caused by: java.sql.SQLException: No suitable driver found for https://www.mybatis.org/mybatis-test/
	at java.sql.DriverManager.getConnection(DriverManager.java:689)
	at java.sql.DriverManager.getConnection(DriverManager.java:208)
	at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:224)
	at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:219)
	at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:95)
	at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:432)
	at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:89)
	at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:139)
	at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:61)
	at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
	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:89)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
	... 7 more

经过多番对比查找，发现错误为 .properties 文件中出现不该存在的key名， .properties 文件中不可以用所在项目的类或者方法的名字对key命名，如下图：
在这里插入图片描述
driver url password 这三个key文字显示为蓝色，按住CTRL点击会出现如下所示内容
在这里插入图片描述
说明该项目中有类或者方法与此key重名，更改名字后
在这里插入图片描述
全部边为灰色，运行正常

记录自己的bug，bug写多了，没准就成高级搬砖工程师了！！！
建筑队学徒
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Exam Ref 70-761 Querying Data with Transact-SQL
04-12
Exam Ref 70-761 Querying Data with Transact-SQL by Itzik Ben-Gan English | 4 Apr. 2017 | ASIN: B06Y21QGGQ | 352 Pages | AZW3 | 23.79 MB Prepare for Microsoft Exam 70-761–and help demonstrate your ...
Error querying database. Cause: java.lang.IllegalArgumentException:Failed to decrypt. 错误解决方案
热门推荐
帅得山崩地裂的专栏
03-07 2万+
java.lang.IllegalArgumentException:Failed to decrypt 从错误可以看出，解密失败。 原因是你在数据库连接配置的地方，设置了加密。即: config.decrypt=true 将其改成： config.decrypt=false 问题就可以解决。 ...
Error querying database
Sweet77
12-29 696
url: jdbc:mysql://localhost:3306/DB?serverTimezone=UTC&useUnicode=true&characterEncoding=UTF-8 jdbc的url配置错误，查看数据库名是否正确
Error querying database.
最新发布
m0_71718533的博客
10-09 128
重新设计表时发现，该字段已经是scope，于是刷新了一下该表，变成了scope，应当是其他人将该表修改了，但是未修改实体，或是修改了未更新。正常来说应该是数据库的表字段和实体不一致产生的问题。但排查发现是一致的。该字段的sope应当是scope，所以打算将表改回来。将实体的字段改成scope成功解决。
基于排名列表的最优Top-k属性组合生成
03-16
在这项工作中，我们研究了一种新颖的top-k查询类型，称为top-k，m查询。 假设 有一组组，每个组包含一组属性，每个 都与一个已排序的元组倒排列表相关联，其中每个元组都包含一个元组ID和分数。...
Inside Microsoft SQL Server 2008 T-SQL Querying
03-02
Delve into the internal architecture of T-SQL—and unveil the power of set-based querying—with comprehensive reference and advice from a highly regarded T-SQL expert and members of Microsoft's SQL ...
Inside Microsoft SQL Server 2008 T-SQL Querying Code
09-07
Inside Microsoft SQL Server 2008 T-SQL Querying Code Inside Microsoft SQL Server 2008 T-SQL Querying Code
Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syn
qq_61009660的博客
05-17 8389
今天遇到两次这个报错，都是SQL语句有细微的差错导致 第一次： 原来的SQL <update id="updateBlog" parameterType="map" > update blog <set> <if test="title!=null"> title =#{title} </if> <if tes
报错：Error querying database. Cause: java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘
老达摩的博客
11-11 1万+
报错：Error querying database. Cause: java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES) 在学习Mybatis时遇到错误Access denied for user ‘root’@‘localhost’ (using password: YES)，一直找不到原因，如图： 出现此类原因大部分不是技术上的问题，是粗心造成的，翻译显示： 查询数据库时出错。原因
Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException报错
weixin_45030023的博客
10-03 1万+
写了Controller类返回json数据文件时候报错 This application has no explicit mapping for /error, so you are seeing this as a fallback. 回到idear发现报错： Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connec
Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown
四季轮换叶，一路招摇胜
04-18 1万+
Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'hx_user' in 'field list'
Mybatis报错: Error querying database. Cause: java.lang.NumberFormatException: For input string: “A“
weixin_43839871的博客
11-06 1万+
报错信息：Error querying database. Cause: java.lang.NumberFormatException: For input string: “A”解决办法: xml里面 if 判断里面的条件判断字符串相等用双引号，外层套单引号。这是因为在比较的时候默认单引号括起来的是数字 ‘A’ 不能转化为数字 ，所以报错。注意test括起来的逻辑判断 用单引号的话 全部都用单号 （如果不保持一致的话，下面的写法还是会报错）
mysql 执行报错：Error querying database. Cause: java.sql.SQLSyntaxErrorException:which is not functionall
weixin_36332085的博客
11-23 7905
mysql 执行报错：Error querying database. Cause: java.sql.SQLSyntaxErrorException:which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 1.这个错误发生在mysql 5.7 版本及以上版本会出现的问题： mysql 5.7版本默认的sql配置是:s
[Spring Boot]运行报错“Error querying database”
weixin_47104915的博客
03-19 1万+
[Spring Boot]运行报错“Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection;” 你好！ 这是你第一次使用 Markdown编辑器 所展示的欢迎页。如果你想学习如何使用Markdown编辑器, 可以仔细阅读这篇文章，了解一下Markdown的基本语法知识。 新的改变 我们对Markdown编辑器进行了一些
Error querying database. Cause: java.lang.UnsupportedOperationException
weixin_43624310的博客
03-12 9583
mybatis抛出以下异常： org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.lang.UnsupportedOperationException ### The error may exist in com/drs/mapper/Appoint
Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionExceptio
S2020chenxin的博客
05-09 9335
连接数据库不成功原因，解决???? org.apache.ibatis.exceptions.PersistenceException: Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving
mybatis-plus-join
03-28
MyBatis-Plus is an enhanced version of MyBatis, a popular Java-based persistence framework. MyBatis-Plus provides additional features and functionalities, including support for join queries. To perform join queries using MyBatis-Plus, you can use the `join` method provided by the `QueryWrapper` class. This method allows you to specify the join type, table name, and join condition. Here's an example of how to perform an inner join using MyBatis-Plus: ``` QueryWrapper<User> queryWrapper = new QueryWrapper<>(); queryWrapper.eq("user_id", 1) .join("order", "user.user_id = order.user_id") .select("user.*", "order.order_no"); List<User> userList = userMapper.selectList(queryWrapper); ``` In this example, we are querying for a user with `user_id` equal to 1 and joining the `order` table using the `user_id` column as the join condition. We are also selecting all columns from the `user` table and the `order_no` column from the `order` table. MyBatis-Plus supports other types of joins, including left join, right join, and full outer join. You can specify the join type using the `JoinType` enumeration provided by MyBatis-Plus. Overall, MyBatis-Plus makes it easy to perform join queries in Java applications using the MyBatis framework.

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值