使用mybatis过程中遇到的问题

mysql驱动类为com.mysql.cj.jdbc.Driver

1.Error querying database.  Cause: java.sql.SQLException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specifc time zone value if you want to utilize time zone support.

配置：

<dataSource type="POOLED">
    <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://localhost:3306/test"/>
    <property name="username" value="xxx"/>
    <property name="password" value="xxx"/>
</dataSource>

解决办法：此时需要在url的配置中新增时区的配置，修改之后的url配置如下

<property name="url" value="jdbc:mysql://localhost:3306/test?serverTimezone=UTC"/>

---

如上配置之后在更新或者插入数据时可能会出现中文乱码的情况，首先想到的可能会说增加编码配置就OK了，此时的配置信息就会变成如下配置

<property name="url" value="jdbc:mysql://localhost:3306/test?serverTimezone=UTC&useUnicode=true&characterEncoding=UTF-8"/>

运行之后第二个问题就会出现了

2.java.lang.ExceptionInInitializerError
Caused by: org.apache.ibatis.exceptions.PersistenceException: 
### Error building SqlSession.
### Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance.  Cause: org.xml.sax.SAXParseException; lineNumber: 17; columnNumber: 111; 对实体 "useUnicode" 的引用必须以 ';' 分隔符结尾。
    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
    at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:52)
    at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:36)
    at cn.huangnengxin.mybatis.service.TestService.<clinit>(TestService.java:26)
Caused by: org.apache.ibatis.builder.BuilderException: Error creating document instance.  Cause: org.xml.sax.SAXParseException; lineNumber: 17; columnNumber: 111; 对实体 "useUnicode" 的引用必须以 ';' 分隔符结尾。

解决办法：此时需要对url中的&进行转义，即变成&amp;

修改之后的url配置如下

<property name="url" value="jdbc:mysql://localhost:3306/test?serverTimezone=UTC&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>

---

之后可能我需要mybatis打印sql信息，那需要在配置文件中新增如下配置

<settings>
    <setting name="logImpl" value="STDOUT_LOGGING"/>
</settings>

要是settings配置的位置不正确可能就会出现第三个问题

3.java.lang.ExceptionInInitializerError
Caused by: org.apache.ibatis.exceptions.PersistenceException: 
### Error building SqlSession.
### Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance.  Cause: org.xml.sax.SAXParseException; lineNumber: 28; columnNumber: 17; 元素类型为 "configuration" 的内容必须匹配 "(properties?,settings?,typeAliases?,typeHandlers?,objectFactory?,objectWrapperFactory?,reflectorFactory?,plugins?,environments?,databaseIdProvider?,mappers?)"。

解决办法，这是由于settings加的位置不对导致的，configuration中子节点的配置顺序应该是(properties?,settings?,typeAliases?,typeHandlers?,objectFactory?,objectWrapperFactory?,reflectorFactory?,plugins?,environments?,databaseIdProvider?,mappers?)，所以如果configuration中有配置properties，则将settings放到properties之后，如果没有配置properties相关信息，则将settings放在configuration的开头

最终配置如下

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>
    <typeAliases>
        <typeAlias alias="User" type="cn.xxx.mybatis.entity.User"/>
    </typeAliases>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/test?serverTimezone=UTC&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
                <property name="username" value="xxx"/>
                <property name="password" value="xxx"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="user.xml"/>
    </mappers>
</configuration>