springboot启动错误笔记

PaymentMapper.xml：

 <resultMap id="BaseResultMap" type="com.lbl.springcloud.entities.Payment">
        <id column="id" property="id" javaType="BIGINT" />
        <id column="serial" property="serial"  javaType="VARCHAR" />
    </resultMap>

报错：

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'paymentController': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'paymentServiceImpl': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'paymentDao' defined in file [E:\study\cloud2020\cloud-provider-payment8001\target\classes\com\lbl\springcloud\dao\PaymentDao.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\study\cloud2020\cloud-provider-payment8001\target\classes\mapper\PaymentMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'BIGINT'.  Cause: java.lang.ClassNotFoundException: Cannot find class: BIGINT

报错中由于dao层sql对象注入失败，原因从结尾：Cannot find class: BIGINT和

Caused by: java.lang.ClassNotFoundException: Cannot find class: VARCHAR

这是javaType的问题，于是把这两个type去掉。

```javascript
 <resultMap id="BaseResultMap" type="com.lbl.springcloud.entities.Payment">
        <id column="id" property="id"  />
        <id column="serial" property="serial"  />
    </resultMap>

程序就成功了，至于为什么去掉就成功了，暂时查不到原因，我估计是我的mysql版本有点低导致的问题，版本是5.7.29。这个问题以后解决。