四、mybatis报错总结

一、导入mybatis文件mybatis-config.xml报红

IDEA中在编辑mybatis-config文件时候，http://mybatis.org/dtd/mybatis-3-config.dtd 报红

解决：

OK：👇🏾

二、Unable to import maven project: See logs for details

换个低版本的 maven ，比如 apache-maven-3.5.4 或者apache-maven-3.6.0-bin ，这里一般是 idea2019.1 与高版本的 maven （apache-maven-3.8.2 ）不太兼容导致的。

三、绑定异常

（1） org.apache.ibatis.binding.BindingException: Type interface com.zql.dao.UserMapper is not known to the MapperRegistry.

解决 👇🏾：

当你的项目在eclipse中能正常运行，但是导入到IDEA中就会报如下错误：

（2）Connected to the target VM, address: ‘127.0.0.1:5263’, transport: ‘socket’
Disconnected from the target VM, address: ‘127.0.0.1:5263’, transport: ‘socket’
org.apache.ibatis.exceptions.PersistenceException:
Error building SqlSession.
The error may exist in com/glory/mapper/userMapper.xml
Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.io.IOException: Could not find resource com/glory/mapper/userMapper.xml

解决： 在pom.xml导入资源过滤配置

<!-- 如果mapper.xml是放在src/main/resources目录下，需配置以下-->
<build>
    <resources>
        <resource>
            <directory>src/main/java</directory>
            <includes>
                <include>**/*.properties</include>
                <include>**/*.xml</include>
            </includes>
            <filtering>false</filtering>
        </resource>
        <resource>
            <directory>src/main/resources</directory>
            <includes>
                <include>**/*.properties</include>
                <include>**/*.xml</include>
            </includes>
            <filtering>false</filtering>
        </resource>
    </resources>
</build>

四、java.lang.ExceptionInInitializerError

maven由于他的约定大于配置，导致无法导出或生效问题

4.1 第一种报错

4.2 第二种报错（java.io.IOException: Could not find resource mybatis-config.xml ）

解决 👇🏾：

<!--在build中配置resources,来防止我们资源导出失败的问题-->
 <build>       
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                    <include>**/*.properties</include>
                </includes>
            </resource>

            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.xml</include>
                    <include>**/*.properties</include>
                </includes>
            </resource>
        </resources>
</build>

五、set标签问题

org.apache.ibatis.exceptions.PersistenceException:

Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'gprice = 9999.0

解决：set 标签中缺少逗号