Discussion :

[POKOU]

Bonjour,

En java 1.6.0_24, j'ai l'erreur suivante :

java.lang.NullPointerException
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at src.creatotot.CreatototTransfPrestation.<init>(CreatototTransfPrestat
ion.java:117)
at src.crearncps.CreatototActionPanel$1.actionPerformed(CreatototActionP
anel.java:208)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour
ce)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

dans mon code l'erreur ligne 117 est en rouge

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
...
            statement =con.createStatement();
 
            for (int l = 0; l <= data2.getRowCount()-1; l++){
                statement.executeUpdate("INSERT INTO `totottemp`.`prestation` " +
                    "(`id` ,`coderisque` ,`groupeprestation` ,`sousgroupeprestation` ,`qualitebeneficiaire` " +
                    ",`etatdroitprestation`,`dateetat`,`motifetat`,`dateouverturedroits` " +
                    ",`datemaj`,`doublerattachement`,`adressagesi`) " +
                    "VALUES ('" + data2.getValueAt(l,0) + 
                    "', '" + data2.getValueAt(l,2) +
                    "', '" + data2.getValueAt(l,3) +
                    "', '" + data2.getValueAt(l,4) +
                    "', '" + data2.getValueAt(l,5) +
                    "', '" + data2.getValueAt(l,6) +
                    "', '" + data2.getValueAt(l,7) +
                    "', CASE '" + data2.getValueAt(l,8) + "' WHEN 'null' THEN " + null + " ELSE '" + data2.getValueAt(l,8) + "' END" +
                    ", '" + data2.getValueAt(l,9) +
                    "', '" + data2.getValueAt(l,10) +
                    "', '" + data2.getValueAt(l,11) +
                    "', '" + data2.getValueAt(l,1) + 
                "')");
            }
 
            con.commit();
            con.setAutoCommit(false);
        }
        catch (Exception e){
            System.out.println(e);
        }
        finally {
            try {
                resultat2.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                statement.close();
        } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                statement2.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

Quelqu'un saurait-il m'indiquer d'où peut venir le problème ?

Merci d'avance pour votre aide.