1.请求地址：http://localhost:8080/arrival...信息：{"code":"msg.common.fail","message":"Errorattemptedtogetcolumn'LAST_UPDATE_DATE'fromresultset.Cause:java.sql.SQLException:列类型无效：类oracle.jdbc.driver.T4CDateAccessor未实现getInt\n；未分类SQLException；SQL状态[99999]；错误代码[17004]；列类型无效：类未实现getIntoracle.jdbc.driver.T4CDateAccessor;嵌套异常是java.sql.SQLException:Invalidcolumntype:getIntnotimplementedforclassoracle.jdbc.driver.T4CDateAccessor","success":false}返回类定义（注：此时，把IntegerrouteOrder改成String是正常的，但是不合理，报错是LAST_UPDATE_DATE的类型转换错误：@Data@Builder@EqualsAndHashCode(callSuper=true)@TableName("XXX")@KeySequence(value="XXX_S")@ApiModel(value="XXX",description="XXX")publicclassCtnLineextendsOracleBaseEntity{@TableId(value="ID",type=IdType.INPUT)privateLongid;@ApiModelProperty(value=“头表ID”t;)@TableField("HEAD_ID")privateLongheadId;@ApiModelProperty(value="站点类型代码")@TableField("ROUTE_LINE_ID")privateLongrouteLineId;@ApiModelProperty(value="预计到达时间")@TableField("EST_ARRIVAL_DATE")privateDateestArrivalDate;@ApiModelProperty(value="实际到达时间")@TableField("ACT_ARRIVAL_DATE")privateDateactArrivalDate;@TableField("CREATOR_NAME")privateStringcreatorName;@TableField("CREATOR_NO")privateStringcreatorNo;@TableField("UPDATER_NAME")privateStringupdaterName;@TableField("UPDATER_NO")privateStringupdaterNo;@ApiModelProperty(value="sitetypedescription")@TableField(exist=false)privateStringsiteTypeDesc;@ApiModelProperty(value="SiteNameDescription")@TableField(exist=false)privateStringsiteNameDesc;@ApiModelProperty(value="SupplyChainDays")@TableField(exist=false)privateLongsupplyDays;@ApiModelProperty(value="sortingofthetotalroute")@TableField(exist=false)privateIntegerrouteOrder;}2、经跟踪排查，问题出在返回类实体上未定义默认构造函数，查看数据库表的字段，正好第13个字段是错误的Last_UPDATED_DATE字段匹配实体中的第13个字段routerOrder：由于我们的框架使用了lombok插件，所以我们只需要在实体头添加如下两个注解即可：@NoArgsConstructor@AllArgsConstructor修改代码：@Data@NoArgsConstructor@AllArgsConstructor@Builder@EqualsAndHashCode(callSuper=true)@TableName("XXX")@KeySequence(value="XXX_S")@ApiModel(value="XXX",description="XXX")publicclassCtnLineextendsOracleBaseEntity{@TableId(value="ID",type=IdType.INPUT)privateLongid;@ApiModelProperty(value="headtableID")@TableField("HEAD_ID")privateLongheadId;@ApiModelProperty(value="siteTypeCode")@TableField("ROUTE_LINE_ID")privateLongrouteLineId;@ApiModelProperty(value="EstimatedArrivalTime")@TableField("EST_ARRIVAL_DATE")privateDateestArrivalDate;@ApiModelProperty(value="实际到达时间")@TableField("ACT_ARRIVAL_DATE")私人日期actArrivalDate;@TableField("CREATOR_NAME")privateStringcreatorName;@TableField("CREATOR_NO")privateStringcreatorNo;@TableField("UPDATER_NAME")privateStringupdaterName;@TableField("UPDATER_NO")privateStringupdaterNo;@ApiModelProperty(value="站点类型描述")@TableField(exist=false)privateStringsiteTypeDesc;@ApiModelProperty(value="站点名称描述")@TableField(exist=false)privateStringsiteNameDesc;@ApiModelProperty(value="供应链天数")@TableField(exist=false)privateLongsupplyDays;@ApiModelProperty(value="Orderoftotalroutes")@TableField(exist=false)privateIntegerrouteOrder;}
