Its possible insert row with embedded ID on table

2019-07-05 11:49发布

问题:

I'm able to insert any row with HQL.

Example:

insert into MyMappedTable(field,field,field) select c.x, c.y, c.z from Object c where ....

But, my requirement is insert with embedded Id

@JoinColumn(insertable = false, name = "CATEGORYID", referencedColumnName = "ID", updatable = false)
@ManyToOne(fetch = FetchType.EAGER, optional = false)
private Category category;

@EmbeddedId
protected CategoryProductPK categoryProductPK;

@Basic(optional = true)
@Column(name = "POSITION")
private Integer position;

@JoinColumn(insertable = false, name = "PRODUCTID", referencedColumnName = "ID", updatable = false)
@ManyToOne(fetch = FetchType.EAGER, optional = false)
private Product product;

Is possible with HQL?