MyBatis所有的JdbcType

  public static final enum org.apache.ibatis.type.JdbcType ARRAY;

  public static final enum org.apache.ibatis.type.JdbcType BIT;

  public static final enum org.apache.ibatis.type.JdbcType TINYINT;

  public static final enum org.apache.ibatis.type.JdbcType SMALLINT;

  public static final enum org.apache.ibatis.type.JdbcType INTEGER;

  public static final enum org.apache.ibatis.type.JdbcType BIGINT;

  public static final enum org.apache.ibatis.type.JdbcType FLOAT;

  public static final enum org.apache.ibatis.type.JdbcType REAL;

  public static final enum org.apache.ibatis.type.JdbcType DOUBLE;

  public static final enum org.apache.ibatis.type.JdbcType NUMERIC;

  public static final enum org.apache.ibatis.type.JdbcType DECIMAL;

  public static final enum org.apache.ibatis.type.JdbcType CHAR;

  public static final enum org.apache.ibatis.type.JdbcType VARCHAR;

  public static final enum org.apache.ibatis.type.JdbcType LONGVARCHAR;

  public static final enum org.apache.ibatis.type.JdbcType DATE;

  public static final enum org.apache.ibatis.type.JdbcType TIME;

  public static final enum org.apache.ibatis.type.JdbcType TIMESTAMP;

  public static final enum org.apache.ibatis.type.JdbcType BINARY;

  public static final enum org.apache.ibatis.type.JdbcType VARBINARY;

  public static final enum org.apache.ibatis.type.JdbcType LONGVARBINARY;

  public static final enum org.apache.ibatis.type.JdbcType NULL;

  public static final enum org.apache.ibatis.type.JdbcType OTHER;

  public static final enum org.apache.ibatis.type.JdbcType BLOB;

  public static final enum org.apache.ibatis.type.JdbcType CLOB;

  public static final enum org.apache.ibatis.type.JdbcType BOOLEAN;

  public static final enum org.apache.ibatis.type.JdbcType CURSOR;

  public static final enum org.apache.ibatis.type.JdbcType UNDEFINED;

  public static final enum org.apache.ibatis.type.JdbcType NVARCHAR;

  public static final enum org.apache.ibatis.type.JdbcType NCHAR;

  public static final enum org.apache.ibatis.type.JdbcType NCLOB;

  public static final enum org.apache.ibatis.type.JdbcType STRUCT;

使用示例：

INSERT INTO "CONTACT_PUSH_MSG_LOG" 
        ("PUSH_MSG_LOG_ID", "PUSH_MSG_ID", "LOG", "PUSH_TIME", "IS_CANCEL", "STATUS_CD", "STATUS_DATE", "CREATE_STAFF", "CREATE_DATE") 
        VALUES(
            CONTACT_PUSH_MSG_LOG_S.NEXTVAL, 
            #{pushMsgId, jdbcType=INTEGER},
            #{log, jdbcType=VARCHAR},
            sysdate,
            #{isCancel, jdbcType=INTEGER},
            #{statusCd, jdbcType=VARCHAR},
            sysdate,
            'jstorm',
            sysdate)

建议在MyBatis使用过程中所有的SQL都使用jdbcType来确定类型以减少不必要的异常。