Ajuda erro 500 [RESOLVIDO]

Programação Java
#1

Opa galera, to com o seguinte erro

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: 
            DELETE  from TB_VACINA where cod_vacina=? and cod_paciente=?
            
            
        : Can not issue data manipulation statements with executeQuery().
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:522)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)

root cause

javax.servlet.ServletException: javax.servlet.jsp.JspException: 
            DELETE  from TB_VACINA where cod_vacina=? and cod_paciente=?
            
            
        : Can not issue data manipulation statements with executeQuery().
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
	org.apache.jsp.excluiVacina_jsp._jspService(excluiVacina_jsp.java:94)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)

aqui estão os blocos de codigo
a excluiVacina.jsp


<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>

<sql:setDataSource var="dtSource" dataSource="jdbc/kubboDB" />
<c:if test="${! empty erroVacinas}">
    <jsp:forward page="vacinas.jsp?cod_paciente=${param.cod_paciente}"/>
</c:if>

   
        <sql:query dataSource="${dtSource}" var="vacina">
            delete from TB_VACINA where cod_vacina =? and cod_paciente =?
            <sql:param value="${param.cod_vacina}"/>
            <sql:param value="${param.cod_paciente}"/>
        </sql:query>
<c:redirect url="vacinas.jsp?cod_paciente=${param.cod_paciente}"/>

e a vacinas.jsp

   </tr> -->
                             <form method="post" id="listarVacina" name= "listarVacina" action="excluiVacina.jsp?cod_paciente=${param.cod_paciente}&cod_vacina=${param.cod_vacina}">
                                   <tr class="tebelaVacinas" id="tabelaVacina_${i}">
                                          <td align="right" width="22%" class="branca" style="font-weight: bold">${vacina.vacina}</td>
                                          <td align="right" width="14%" class="branca" style="font-weight: bold">${vacina.dose}</td>
                                          <td align="right" width="25%" class="branca" style="font-weight: bold">${vacina.data}</td>
                                          <td align="right" width="34%" class="branca" style="font-weight: bold">${vacina.lote}</td>
                                          <td align="right" width="34%" class="branca" style="font-weight: bold">
                                        <input type="submit" style="background-image:url('imagens/lixeiraAzulGrande.gif'); cursor: pointer;" onclick="excluirVacina('${i}')" size="2">
                                              <!--<img style="cursor: pointer;" onclick="excluirVacina('${i}');" alt="excluir" src="imagens/lixeiraAzulGrande.gif" > -->

                                          </td>


                                  </tr>
                             </form>

e o excluirVacina javascript

function excluirVacina(id){
   if(id!=""){
   //  var form = $("tabelaVacina_"+id);
        var form = document.getElementById("listarVacina");
        var form2 = document.getElementsByName("listarVacina");
       alert("Vacina: " + id + " " + form2);
       var vacina = document.getElementById('tabelaVacina_'+id)
      // document.getElementById('tabelaVacina_'+id).style.display = "none";
     //  $(vacina).remove();
       form.submit();
   }
}

SOCORRO o/

;D

#2

Olá,

Olha, sua tabela TB_VACINA tem relação com alguma outra tabela? Provavelmente deve ser que, ao executar DELETE from TB_VACINA, exista alguma outra tabela com chave estrangeira e dai vc deve escluir primeiro os elementos dessa tabela, para somente depois escluir os da tabela em questão.

Att.

#3

fala velinho, consegui resolser o problema, tive que mexer no javascript e no jsp,
no caso do jsp vei eu tive que mudar o sql:query pra sql:update [isso é nojento]

<%-- 
    Document   : excluirVacina
    Created on : 10/06/2010, 11:47
    Author     : Max Mustang www.faroljava.wordpress.com
--%>

<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>

<sql:setDataSource var="dtSource" dataSource="jdbc/kubboDB" />
<c:if test="${! empty erroVacinas}">
    <jsp:forward page="vacinas.jsp?cod_paciente=${param.cod_paciente}"/>
</c:if>

   
        <sql:update dataSource="${dtSource}" var="vacina">
            delete from TB_VACINA where cod_vacina =? and cod_paciente =?
            <sql:param value="${param.cod_vacina}"/>
            <sql:param value="${param.cod_paciente}"/>
        </sql:update>
<c:redirect url="vacinas.jsp?cod_paciente=${param.cod_paciente}"/>
#4