JDBC executeQuery("DELETE...
Publicado por ENARA (62 intervenciones) el 18/02/2007 17:13:45
Buenas, le estoy dando vueltas a una cosilla que me ha pasado, os agradecería si me podrías ayudar a saber qué he hecho mal,gracias
java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.Statement.checkForDml(Statement.java:401)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1078)
at pfc.packDatos.DAOAviso.eliminarAviso(DAOAviso.java:196)
at pfc.packNegocio.ListaAvisos.eliminarAviso(ListaAvisos.java:159)
at pfc.packInterface.ControladorVentanaLeerAviso.eliminarAviso(ControladorVentanaLeerAviso.java:50)
at pfc.packInterface.VentanaLeerAviso.cerrar(VentanaLeerAviso.java:95)
at pfc.packInterface.Controlador.recibirConfirmacionEliminar(Controlador.java:35)
at pfc.packInterface.ControladorVentanaConfirmacionEliminar.actionPerformed(ControladorVentanaConfirmacionEliminar.java:70)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1774)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
*******
casca en
at pfc.packDatos.DAOAviso.eliminarAviso(DAOAviso.java:196)
donde
stmt.executeQuery("delete from aviso where idInsercion="+ id+";");
me pregunto si se debe a que idInsercion es la clave principal de la tabla aviso
muxas gracias
java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.Statement.checkForDml(Statement.java:401)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1078)
at pfc.packDatos.DAOAviso.eliminarAviso(DAOAviso.java:196)
at pfc.packNegocio.ListaAvisos.eliminarAviso(ListaAvisos.java:159)
at pfc.packInterface.ControladorVentanaLeerAviso.eliminarAviso(ControladorVentanaLeerAviso.java:50)
at pfc.packInterface.VentanaLeerAviso.cerrar(VentanaLeerAviso.java:95)
at pfc.packInterface.Controlador.recibirConfirmacionEliminar(Controlador.java:35)
at pfc.packInterface.ControladorVentanaConfirmacionEliminar.actionPerformed(ControladorVentanaConfirmacionEliminar.java:70)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1774)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
*******
casca en
at pfc.packDatos.DAOAviso.eliminarAviso(DAOAviso.java:196)
donde
stmt.executeQuery("delete from aviso where idInsercion="+ id+";");
me pregunto si se debe a que idInsercion es la clave principal de la tabla aviso
muxas gracias
Valora esta pregunta


0