示例代码如下:
父表:
@Entity
@Table(name = "promotion")
@Inheritance(strategy = InheritanceType.JOINED)
@DiscriminatorColumn(name = "promotion_type", discriminatorType = DiscriminatorType.STRING)
@XmlRootElement
public class Promotion implements Serializable {…
…
…
@Basic(optional = false)
@Column(name = "promotion_type", nullable = false, length = 17)
protected String promotionType;
…
…
}
子表:
@Entity
@Table(name = "promotion_event")
@PrimaryKeyJoinColumn(name = "promotion_id")
@DiscriminatorValue("event")
@XmlRootElement
public class PromotionEvent extends Promotion {
…
…
}
hibernate升级5.x遇到表继承无法插入的情况,报错如下:
insert into promotion (amount, client_id, description, end_datetime, event_end_datetime, event_start_datetime, hide_amount_at_ticket, name, percentage, promotion_type, requires_pda_alert, short_name, show_amount_original_at_ticket, start_datetime, state, status) values (?, ?, ?, ?, ?, ?, ?, ?, ?, 'event', ?, ?, ?, ?, ?, ?)
ERROR pool-2-thread-2 SqlExceptionHelper.logExceptions - Parameter index out of range (16 > number of parameters, which is 15).
看报错的意思就是动态参数比实际传入的参数少了一个。
翻阅hibernate官方论坛,这个问题应该是由4.3.X引发的,我的理解是官方限制父表类型仅由hibernate自己控制,以前的版本是可以手动修改的,如果修改的类型与配置的不一样,就会导致脏数据。
以下 解决办法:
@Basic(optional=false)
@Column(name = "promotion_type",nullable = false,insertable = false,updatable=false,length = 50)
private String promotion_type;
加了后,就不能通过HQL对类型进行修改了,避免错误的更新数据,当然SQL直接更新不谈。
参考文献: