Alguem poderia me dizer por que o hibernate executa deletes em many-to-many´s durante uma consulta. Obs: Existem mais dois Sets mapeados do mesmo modo e nada acontece com eles... Estou usando hibernate 2.17 []´s …

O hibernate executa delete em um select? Você poderia explicar isso melhor?

Hibernate apagando dados em query

Primeiramente obrigado pela atenção

segue abaixo o trecho do codigo java

Criteria filter = session.createCriteria(Report.class).add(
Expression.eq("active", new Boolean(true))).add(					Expression.isNull("closedDate"));
List data = filter.list();

seque o que o hibernate faz:

Hibernate: select this.reportID as reportID2_, this.active as active2_, this.clinTrace as clinTrace2_, this.closedDate as closedDate2_, this.daysToClose as daysToCl5_2_, this.daysToIndy as daysToIndy2_, this.daysToRegAgence as daysToRe7_2_, this.followUp as followUp2_, this.forwardIndy as forwardI9_2_, this.idNumber as idNumber2_, this.initialReview as initial11_2_, this.investigationNumber as investi12_2_, this.lotNumber as lotNumber2_, this.receivedIndy as receive14_2_, this.receivedLocalPhV as receive15_2_, this.reportDate as reportDate2_, this.reporterType as reporte17_2_, this.reportType as reportType2_, this.sentLocalPhV as sentLoc19_2_, this.sentRegAgence as sentReg20_2_, this.spontaneousSource as spontan21_2_, this.studyAlias as studyAlias2_, this.validCase as validCase2_, this.userID as userID2_, this.country as country2_, this.regionOwner as regionO26_2_, user1_.userID as userID0_, user1_.roleID as roleID0_, user1_.active as active0_, user1_.country as country0_, user1_.name as name0_, user1_.password as password0_, user1_.region as region0_, user1_.systemID as systemID0_, role2_.roleID as roleID1_, role2_.active as active1_, role2_.description as descript3_1_ from Report this, UserPharma user1_, Role role2_ where this.active=? and this.closedDate is null and this.userID=user1_.userID(+) and user1_.roleID=role2_.roleID(+)
Hibernate: select seriousnes0_.seriousnessCriteriaID as seriousn2___, seriousnes0_.reportID as reportID__, seriousnes1_.seriousnessCriteriaID as seriousn1_0_, seriousnes1_.active as active0_, seriousnes1_.description as descript3_0_ from Report_Criterias seriousnes0_, SeriousnessCriteria seriousnes1_ where seriousnes0_.reportID=? and seriousnes0_.seriousnessCriteriaID=seriousnes1_.seriousnessCriteriaID
Hibernate: select reactions0_.reactionID as reactionID__, reactions0_.reportID as reportID__, reaction1_.reactionID as reactionID0_, reaction1_.active as active0_, reaction1_.description as descript3_0_ from Report_Reactions reactions0_, Reaction reaction1_ where reactions0_.reportID=? and reactions0_.reactionID=reaction1_.reactionID
Hibernate: select products0_.productID as productID__, products0_.reportID as reportID__, product1_.productID as productID0_, product1_.active as active0_, product1_.description as descript3_0_ from Report_Products products0_, Product product1_ where products0_.reportID=? and products0_.productID=product1_.productID
Hibernate: select contacts0_.contactID as contactID__, contacts0_.reportID as reportID__, contact1_.contactID as contactID0_, contact1_.active as active0_, contact1_.contactDate as contactD3_0_, contact1_.description as descript4_0_ from Report_Contacts contacts0_, Contact contact1_ where contacts0_.reportID=? and contacts0_.contactID=contact1_.contactID
Hibernate: delete from Report_Products where reportID=?

Obs: Estou usando SaveOrUpdateCopy para gravar o cara no banco

for (Object contact : report.getContacts()) {
      session.saveOrUpdateCopy(contact);
}
for (Object reaction : report.getReactions()) {
      session.saveOrUpdateCopy(reaction);
}

for (Object product : report.getProducts()) {
    session.saveOrUpdateCopy(product);
}

for (Object criteria : report.getSeriousnessCriterias()) {
    session.saveOrUpdateCopy(criteria);
}

session.flush();
			
session.saveOrUpdateCopy(report);

session.flush();
tx.commit();

2 Respostas

Topicos relacionados