【Mybatis】No enum constant org.apache.ibatis.type.JdbcType.LONG

喜欢ヅ旅行 2023-10-10 13:09 33阅读 0赞

问题描述：今天编写定时任务管理模块，提交定时任务实体信息时，提示如下错误

> nested exception is org.apache.ibatis.builder.BuilderException: Error resolving JdbcType. Cause: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.LONG  
>

大致含义是：MyBatis 框架不支持Long 数据类型

产生问题的\*Mapper.xml 文件

错误：

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.zzg.mapper.ScheduleJobMapper">
      <resultMap id="BaseResultMap" type="com.zzg.entity.ScheduleJob">
        <id column="id" jdbcType="Long" property="id" />
        <result column="job_name" jdbcType="VARCHAR" property="jobName" />
        <result column="cron_expression" jdbcType="VARCHAR" property="cronExpression" />
        <result column="bean_name" jdbcType="VARCHAR" property="beanName" />
        <result column="method_name" jdbcType="VARCHAR" property="methodName" />
        <result column="status" jdbcType="INTEGER" property="status" />
        <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
        <result column="update_time" jdbcType="TIMESTAMP" property="updateTime" />
        <result column="del_flag" jdbcType="INTEGER" property="delFlag" />
      </resultMap>
    </mapper>

正确:

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.zzg.mapper.ScheduleJobMapper">
      <resultMap id="BaseResultMap" type="com.zzg.entity.ScheduleJob">
        <id column="id" jdbcType="BIGINT" property="id" />
        <result column="job_name" jdbcType="VARCHAR" property="jobName" />
        <result column="cron_expression" jdbcType="VARCHAR" property="cronExpression" />
        <result column="bean_name" jdbcType="VARCHAR" property="beanName" />
        <result column="method_name" jdbcType="VARCHAR" property="methodName" />
        <result column="status" jdbcType="INTEGER" property="status" />
        <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
        <result column="update_time" jdbcType="TIMESTAMP" property="updateTime" />
        <result column="del_flag" jdbcType="INTEGER" property="delFlag" />
      </resultMap>
    </mapper>

差异截图:

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70][]

总结:数据库类型与Java类型对应表

<table style="width:500px;"> 
 <tbody> 
  <tr> 
   <td>DB Type</td> 
   <td>JAVA Type</td> 
  </tr> 
  <tr> 
   <td>CHAR&nbsp;&nbsp; &nbsp;</td> 
   <td>String</td> 
  </tr> 
  <tr> 
   <td>VARCHAR</td> 
   <td>String</td> 
  </tr> 
  <tr> 
   <td>LONGVARCHAR</td> 
   <td>String</td> 
  </tr> 
  <tr> 
   <td>NUMERIC</td> 
   <td>java.math.BigDecimal</td> 
  </tr> 
  <tr> 
   <td>DECIMAL</td> 
   <td>&nbsp;java.math.BigDecimal</td> 
  </tr> 
  <tr> 
   <td>BIT</td> 
   <td> <p>&nbsp;boolean</p> </td> 
  </tr> 
  <tr> 
   <td>BOOLEAN</td> 
   <td>boolean</td> 
  </tr> 
  <tr> 
   <td>TINYINT</td> 
   <td>byte</td> 
  </tr> 
  <tr> 
   <td>SMALLINT</td> 
   <td>short</td> 
  </tr> 
  <tr> 
   <td>INTEGER</td> 
   <td>int</td> 
  </tr> 
  <tr> 
   <td>BIGINT</td> 
   <td>long</td> 
  </tr> 
  <tr> 
   <td>REAL</td> 
   <td>float</td> 
  </tr> 
  <tr> 
   <td>FLOAT</td> 
   <td>double</td> 
  </tr> 
  <tr> 
   <td>DOUBLE</td> 
   <td>double</td> 
  </tr> 
  <tr> 
   <td>BINARY</td> 
   <td>byte[]</td> 
  </tr> 
  <tr> 
   <td>VARBINARY</td> 
   <td>byte[]</td> 
  </tr> 
  <tr> 
   <td>LONGVARBINARY</td> 
   <td>byte[]</td> 
  </tr> 
  <tr> 
   <td>DATE</td> 
   <td>java.sql.Date</td> 
  </tr> 
  <tr> 
   <td>TIME</td> 
   <td>java.sql.Time</td> 
  </tr> 
  <tr> 
   <td>TIMESTAMP</td> 
   <td>java.sql.Timestamp</td> 
  </tr> 
  <tr> 
   <td>CLOB</td> 
   <td>Clob</td> 
  </tr> 
  <tr> 
   <td>BLOB</td> 
   <td>BLOB</td> 
  </tr> 
 </tbody> 
</table>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20210727094822151.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n,size_16,color_FFFFFF,t_70