May be something like this?
Code:
@Table(uniqueConstraints = {@UniqueConstraint(columnNames = {"laboratory_id", "name"})})
Here is full code.
Code:
@Entity
@Table(uniqueConstraints = {@UniqueConstraint(columnNames = {"laboratory_id", "name"})})
@SequenceGenerator(name = "SEQ_INSTRUMENT", sequenceName = "SEQ_INSTRUMENT")
public class Instrument extends AbstractModelBean {
@Override
public String toString() {
return BeanUtils2.toString(this, "id", "name");
}
////////////////////////////////////////////////////////////////////////////
//
// Id
//
////////////////////////////////////////////////////////////////////////////
private Long m_id;
@Id(generate = GeneratorType.SEQUENCE, generator = "SEQ_INSTRUMENT")
public Long getId() {
return m_id;
}
public void setId(Long id) {
m_id = id;
}
////////////////////////////////////////////////////////////////////////////
//
// name
//
////////////////////////////////////////////////////////////////////////////
private String m_name;
@Column(length = 120)
@NotNull
public String getName() {
return m_name;
}
public void setName(String name) {
m_name = name;
}
////////////////////////////////////////////////////////////////////////////
//
// laboratory
//
////////////////////////////////////////////////////////////////////////////
private Laboratory m_laboratory;
@ManyToOne(optional = false)
public Laboratory getLaboratory() {
return m_laboratory;
}
public void setLaboratory(Laboratory laboratory) {
m_laboratory = laboratory;
}
}