Springboot+mybatis+druid常见问题

女爷i 2022-04-04 05:38 412阅读 0赞

1. 配置文件问题，导致这个问题的原因是，我的springboot应用pom中没有增加SpringCloud的依赖，配置文件名使用的是bootstrap.yml（SpringCloud应用才能识别bootstrap配置文件），所以应用在读取数据库连接信息时直接没有找到。

***************************
    APPLICATION FAILED TO START
    ***************************
    
    Description:
    
    Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.
    
    Reason: Failed to determine a suitable driver class
    
    
    Action:
    
    Consider the following:
    	If you want an embedded database (H2, HSQL or Derby), please put it on the classpath.
    	If you have database settings to be loaded from a particular profile you may need to activate it (no profiles are currently active).

解决办法：bootstrap.yml改为application.yml，或者增加SpringCloud相关依赖。

2. Invalid bound statement (not found)

2.1

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.hollysysdigital.modellib.mapper.FileInfoMapper.insertFileAttachInfo

{
      "timestamp": "2018-12-15T03:21:10.712+0000",
      "status": 500,
      "error": "Internal Server Error",
      "message": "Invalid bound statement (not found): com.hollysysdigital.modellib.mapper.FileInfoMapper.insertFileAttachInfo",
      "path": "/file/saveBackFile"
    }

原因：还是配置文件的原因！

错误配置，把mybatis相关配置放到了spring的下面，相当于spring.mybatis.mapper-locations=xxxx

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdndWRhb2tl_size_16_color_FFFFFF_t_70][]

正确的配置应该是：mybatis.mapper-locations=xxxx

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdndWRhb2tl_size_16_color_FFFFFF_t_70 1][]

注意：yml配置文件看起来比较优雅，但使用的时候多个空格可能就导致配置项的key的值就成了上面的配置项的下级配置了，所以，yml作为配置文件，一定要好好检查。

2.2  mapper的namespace和实际的类路径不一致（复制粘贴导致的）

![20191031190526119.png][]

2.3  id与mapper接口中的方法名不一致

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdndWRhb2tl_size_16_color_FFFFFF_t_70 2][]

3. 虽然Idea会提示，exclude=\{DruidDataSourceAutoConfigure.class\} 这一句应该加到@SpringBootApplication上面，并且给你一个红色波浪线错误提示，但是你这样做了之后，应用就启动不起来了。

去掉 @EnableAutoConfiguration(exclude=\{DruidDataSourceAutoConfigure.class\})  之后启动异常如下：

Caused by: java.lang.ClassNotFoundException: org.springframework.boot.bind.RelaxedDataBinder

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdndWRhb2tl_size_16_color_FFFFFF_t_70 3][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdndWRhb2tl_size_16_color_FFFFFF_t_70]: /images/20220404/da1fe5dc60174a9cb5445273002c13f2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdndWRhb2tl_size_16_color_FFFFFF_t_70 1]: /images/20220404/6d916538daf84e9783c8aedc87e02707.png
[20191031190526119.png]: /images/20220404/af28aad852d54318b07fbcf0068ab5d7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdndWRhb2tl_size_16_color_FFFFFF_t_70 2]: /images/20220404/cc9f5279bda04bc78a266b4ce135abb9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdndWRhb2tl_size_16_color_FFFFFF_t_70 3]: /images/20220404/06989f6e67a9487a9a9bd374cf1f3050.png