Correção do processo de exclusão de casos - nova correção.

diff --git a/src/java/org/ufcspa/simdecs/mb/editarcasos/SelecioneCasoBean.java b/src/java/org/ufcspa/simdecs/mb/editarcasos/SelecioneCasoBean.java
index a66a032..53e6a2d 100644 (file)
--- a/src/java/org/ufcspa/simdecs/mb/editarcasos/SelecioneCasoBean.java
+++ b/src/java/org/ufcspa/simdecs/mb/editarcasos/SelecioneCasoBean.java
@@ -115,11 +115,11 @@ public class SelecioneCasoBean extends DefaultManagedBean {
         
         beginTransaction();
 
-        em.createQuery("Delete From LogPerguntas Where sessaoUsuario.caso.id=:pIDCaso")
+        em.createQuery("Delete From LogPerguntas Where sessaoUsuario.id in (select id from SessaoUsuario where caso.id=:pIDCaso)")
           .setParameter("pIDCaso", id)
           .executeUpdate();
 
-        em.createQuery("Delete From IntervencaoPedagogica Where sessaoUsuario.caso.id=:pIDCaso")
+        em.createQuery("Delete From IntervencaoPedagogica Where sessaoUsuario.id in (select id from SessaoUsuario where caso.id=:pIDCaso)")
           .setParameter("pIDCaso", id)
           .executeUpdate();