mybatis中文参考文档路径:
https://mybatis.org/mybatis-3/zh/getting-started.html
***Mapper.xml文件找不到问题
maven项目,执行访问mysql数据库报如下错误:
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error building SqlSession.
### The error may exist in wang/mybatis/dao/UserMapper.xml
### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.io.IOException: Could not find resource wang/mybatis/dao/UserMapper.xml
原因:是maven的pom.xml文件中没有构建java/ 目录下面.xml文件。
解决办法:是在pom.xml中添加构建配置,包含src/main/java目录下面的配置文件
<build>
<resources>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource>
</resources>
</build>
这个错误是在添加完之后出现的,这个问题的根本原因是因为ideaJ的file encoding和xml的encoding不一致导致的。统一成utf-8之后,成功。
Caused by: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance. Cause: com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: 1 字节的 UTF-8 序列的字节 1 无效。
可以看到,target下面也构建了配置文件。
servertimezone问题
ideaJ在连接数据库因为serverTimeZone失败,设置Adanced的serverTimeZone为UTC 可以解决