Hello,
as I did not find a solution, I tried to make my self the suppression.
Code:
public void deleteOne(String id) {
List r = getHibernateTemplate().find(
"from Coutjournalierexperian where COUTJOURNALIEREXPERIAN_ID = "+"\'"+id+"\'");
getHibernateTemplate().delete( (Coutjournalierexperian) r.get(0));
// on supprime aussi tous les enregistrements qui contiennent cette clé
// Dans la table Intervenant
List req = getHibernateTemplate().find(
"from Intervenant where COUTJOURNALIEREXPERIAN_ID = "+"\'"+id+"\'");
getHibernateTemplate().delete( (Coutjournalierexperian) req.get(0));
}
I had then the same exception . Sohibernate did it too. I believe that the problem comes from my classes java
this Intervenant.java
Code:
package com.pia.agp.mapping;
import java.io.Serializable;
import java.util.Date;
import org.apache.commons.lang.builder.ToStringBuilder;
/** @author Hibernate CodeGenerator */
public class Intervenant implements Serializable {
/** identifier field */
private Integer intervenantId;
/** nullable persistent field */
private String intervenantNom;
/** nullable persistent field */
private String intervenantPrenom;
/** nullable persistent field */
private String intervenantLogin;
/** nullable persistent field */
private String intervenantMdp;
private String intervenantMdp2;
/** nullable persistent field */
private String intervenantEmail;
/** nullable persistent field */
private String intervenantTel;
/** nullable persistent field */
private String intervenantFonction;
/** persistent field */
private Date intervenantDatedebutcontrat;
/** persistent field */
private Date intervenantDatefincontrat;
/** persistent field */
private String coutjournalierexperianId;
/** persistent field */
private long droitId;
private Droit droit;
private Coutjournalierexperian coutjournalierexperian;
/** full constructor */
public Intervenant(Integer intervenantId, String intervenantNom, String intervenantPrenom, String intervenantLogin, String intervenantMdp,String intervenantMdp2, String intervenantEmail, String intervenantTel, String intervenantFonction, Date intervenantDatedebutcontrat, Date intervenantDatefincontrat, String coutjournalierexperianId, long droitId,Droit droit,Coutjournalierexperian coutjournalierexperian) {
this.intervenantId = intervenantId;
this.intervenantNom = intervenantNom;
this.intervenantPrenom = intervenantPrenom;
this.intervenantLogin = intervenantLogin;
this.intervenantMdp = intervenantMdp;
this.intervenantMdp2 = intervenantMdp2;
this.intervenantEmail = intervenantEmail;
this.intervenantTel = intervenantTel;
this.intervenantFonction = intervenantFonction;
this.intervenantDatedebutcontrat = intervenantDatedebutcontrat;
this.intervenantDatefincontrat = intervenantDatefincontrat;
this.coutjournalierexperianId = coutjournalierexperianId;
this.droitId = droitId;
this.droit = droit;
this.coutjournalierexperian = coutjournalierexperian;
}
/** default constructor */
public Intervenant() {
}
/** minimal constructor */
public Intervenant(Integer intervenantId, Date intervenantDatedebutcontrat, Date intervenantDatefincontrat, String coutjournalierexperianId, long droitId,Droit droit,Coutjournalierexperian coutjournalierexperian) {
this.intervenantId = intervenantId;
this.intervenantDatedebutcontrat = intervenantDatedebutcontrat;
this.intervenantDatefincontrat = intervenantDatefincontrat;
this.coutjournalierexperianId = coutjournalierexperianId;
this.droitId = droitId;
this.droit = droit;
this.coutjournalierexperian = coutjournalierexperian;
}
public Intervenant(Integer intervenantId) {
this.intervenantId = intervenantId;
}
public Integer getIntervenantId() {
return this.intervenantId;
}
public void setIntervenantId(Integer intervenantId) {
this.intervenantId = intervenantId;
}
public String getIntervenantNom() {
return this.intervenantNom;
}
public void setIntervenantNom(String intervenantNom) {
this.intervenantNom = intervenantNom;
}
public String getIntervenantPrenom() {
return this.intervenantPrenom;
}
public void setIntervenantPrenom(String intervenantPrenom) {
this.intervenantPrenom = intervenantPrenom;
}
public String getIntervenantLogin() {
return this.intervenantLogin;
}
public void setIntervenantLogin(String intervenantLogin) {
this.intervenantLogin = intervenantLogin;
}
public String getIntervenantMdp() {
return this.intervenantMdp;
}
public void setIntervenantMdp(String intervenantMdp) {
this.intervenantMdp = intervenantMdp;
}
public String getIntervenantMdp2() {
return this.intervenantMdp2;
}
public void setIntervenantMdp2(String intervenantMdp2) {
this.intervenantMdp2 = intervenantMdp2;
}
public String getIntervenantEmail() {
return this.intervenantEmail;
}
public void setIntervenantEmail(String intervenantEmail) {
this.intervenantEmail = intervenantEmail;
}
public String getIntervenantTel() {
return this.intervenantTel;
}
public void setIntervenantTel(String intervenantTel) {
this.intervenantTel = intervenantTel;
}
public String getIntervenantFonction() {
return this.intervenantFonction;
}
public void setIntervenantFonction(String intervenantFonction) {
this.intervenantFonction = intervenantFonction;
}
public Date getIntervenantDatedebutcontrat() {
return this.intervenantDatedebutcontrat;
}
public void setIntervenantDatedebutcontrat(Date intervenantDatedebutcontrat) {
this.intervenantDatedebutcontrat = intervenantDatedebutcontrat;
}
public Date getIntervenantDatefincontrat() {
return this.intervenantDatefincontrat;
}
public void setIntervenantDatefincontrat(Date intervenantDatefincontrat) {
this.intervenantDatefincontrat = intervenantDatefincontrat;
}
public String getCoutjournalierexperianId() {
return this.coutjournalierexperianId;
}
public void setCoutjournalierexperianId(String coutjournalierexperianId) {
this.coutjournalierexperianId = coutjournalierexperianId;
}
public long getDroitId() {
return this.droitId;
}
public void setDroitId(long droitId) {
this.droitId = droitId;
}
public Droit getDroit() {
return this.droit;
}
public void setDroit(Droit droit) {
this.droit=droit;
}
public Coutjournalierexperian getCoutjournalierexperian() {
return this.coutjournalierexperian;
}
public void setCoutjournalierexperian(Coutjournalierexperian coutjournalierexperian) {
this.coutjournalierexperian = coutjournalierexperian;
}
public String toString() {
return new ToStringBuilder(this)
.append("intervenantId", getIntervenantId())
.toString();
}
}
Before adding the relation many-to-one, I had my two foreign keys like String (COUTJOURNALIER_ID) and long (DROIT_ID).
but someone told me that i should put like type the object of the keys because Hibernate can make all the connection alone, So I added Droit DROIT_ID and COUT…
maybe the problem come from there .
thank you very much
relation between tables
Reply With Quote