eielvalidation. Handled exceptions correctly

Published on: 13/04/2011
Discussion

If the query of a validation is not correctly builded, for example is calling a table that doesn't exists a exception not correctly handled puts the db in a not consistent state and gvSIG must be close to continue. Example: VOL05C01V05: select n.fase, n.provincia, n.municipio, sum(n.padron) + m.padron AS sum_padron, p.total_pob from "eiel_map_municipal".mun_enc_dis m, "eiel_map_municipal".nucl_encuestado_1 n, validacion.padron p where n.fase = p.fase and n.provincia = p.provincia and n.municipio = p.municipio and m.fase = n.fase and m.provincia = n.provincia and m.municipio = n.municipio group by n.fase, n.provincia, n.municipio, m.padron, p.total_pob having not sum(n.padron) + m.padron = p.total_pob order by n.municipio java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222) at java.util.concurrent.FutureTask.get(FutureTask.java:83) at javax.swing.SwingWorker.get(SwingWorker.java:582) at es.udc.cartolab.gvsig.eielvalidation.gui.EIELValidationPanel$ValidateTask.done(EIELValidationPanel.java:476) at javax.swing.SwingWorker$5.run(SwingWorker.java:717) at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(SwingWorker.java:814) at sun.swing.AccumulativeRunnable.run(AccumulativeRunnable.java:95) at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(SwingWorker.java:824) at javax.swing.Timer.fireActionPerformed(Timer.java:291) at javax.swing.Timer$DoPostEvent.run(Timer.java:221) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:642) at java.awt.EventQueue.access$000(EventQueue.java:85) at java.awt.EventQueue$1.run(EventQueue.java:603) at java.awt.EventQueue$1.run(EventQueue.java:601) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:612) at com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178) at java.awt.Dialog$1.run(Dialog.java:1046) at java.awt.Dialog$3.run(Dialog.java:1098) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1096) at java.awt.Component.show(Component.java:1585) at java.awt.Component.setVisible(Component.java:1537) at java.awt.Window.setVisible(Window.java:842) at java.awt.Dialog.setVisible(Dialog.java:986) at com.iver.core.mdiManager.NewSkin.addJDialog(NewSkin.java:449) at com.iver.core.mdiManager.NewSkin.addWindow(NewSkin.java:236) at es.udc.cartolab.gvsig.eielvalidation.gui.gvWindow.open(gvWindow.java:100) at es.udc.cartolab.gvsig.eielvalidation.gui.EIELValidationPanel.executeValidations(EIELValidationPanel.java:812) at es.udc.cartolab.gvsig.eielvalidation.gui.EIELValidationPanel.actionPerformed(EIELValidationPanel.java:843)



SeverityNone
ResolutionNone

Category

Bugs

Comments

Thu, 14/04/2011 - 11:03

Partially solved on commit 9b1e5ae4861e143daf757f87f606e117d6f29c8b