Wednesday, May 23, 2012

duplicated rows which have duplicated primary key in a view

i have i view and i mappe it like this



@Id
@Column(name = "IDBQ", precision = 5, scale = 0)
public Integer getIdbq() {
return this.idbq;
}

public void setIdbq(Integer idbq) {
this.idbq = idbq;
}


@Column(name = "ID", precision = 22, scale = 0)
public Integer getId() {
return this.id;
}

public void setId(Integer id) {
this.id = id;
}

@Column(name = "NOM_CLIENT", length = 100)
public String getNomClient() {
return this.nomClient;
}

public void setNomClient(String nomClient) {
this.nomClient = nomClient;
}

@Column(name = "PRENOM_CLIENT", length = 30)
public String getPrenomClient() {
return this.prenomClient;
}


and beacause it's a view the primary key IDBQ in many rows is duplicated.
the probleme when i make a request hql from hibernate it return : duplicated rows which have duplicated Id -> IDBQ





No comments:

Post a Comment