How to setFloat a value of a PreparedStatement (jdbc) on NULL

Question

I want to insert in my database lots of data with a Java program. I'm trying to manage the fact that the value of the String could be empty, in that way, I want to set the value to null.

This isn't working (pstm.setFloat...) :

PreparedStatement pstm;
try {
    pstm = connex.prepareStatement("INSERT INTO opfofa._produit_val_nut VALUES (?,?,?,?,?,?,?,?,?,?)");
    pstm.setInt(1,id);
    pstm.setString(2,tabChaine[8]);
    pstm.setFloat(3,tabChaine[9].isEmpty()? null:Float.valueOf(tabChaine[9]));
    ...
    pstm.executeUpdate();
}catch(PSQLException e) {
    System.out.println("already inserted : "+e);
}

Error : java.lang.NullPointerException and that is normal because we can't set a float to null but in PostgreSQL I can set a Numeric column to null.

How can I do this?

You need to use setNull() – clinomaniac Jan 02 '18 at 22:49 — clinomaniac, Jan 02 '18 at 22:49

score 2 · Answer 1 · answered Jan 02 '18 at 22:52

The code should look something like this:

PreparedStatement pstm;
try {
    pstm = connex.prepareStatement("INSERT INTO opfofa._produit_val_nut VALUES (?,?,?,?,?,?,?,?,?,?)");
    pstm.setInt(1,id);
    pstm.setString(2,tabChaine[8]);
    if (tabChaine[9].isEmpty()) {
        pstm.setNull(3, java.sql.Types.FLOAT);
    }
    else {
        pstm.setFloat(3,Float.valueOf(tabChaine[9]));
    }
    ...
    pstm.executeUpdate();
}catch(PSQLException e) {
    System.out.println("already inserted : "+e);
}

More info on setNull()

Thats working too thx a lot ! – Cetelem Jan 02 '18 at 23:06 — Cetelem, Jan 02 '18 at 23:06

Szymon Stepniak · Accepted Answer · 2018-01-02T23:07:06.860

2

setFloat throws NullPointerException because it expects primitive float and not a Float object. You can try using setObject method instead - it allows using null values if needed. Something like:

pstm.setObject(3, tabChaine[9].isEmpty() ? null : Float.valueOf(tabChaine[9]), java.sql.Types.FLOAT);

edited Jan 02 '18 at 23:07

answered Jan 02 '18 at 22:54

Szymon Stepniak

40,216
10
104
131

Thats working thx ! – Cetelem Jan 02 '18 at 23:06

score 0 · Answer 3 · answered Jan 02 '18 at 22:50

0

You have to use setNull() if you need to set a parameter null

answered Jan 02 '18 at 22:50

TheOni

810
9
26

How to setFloat a value of a PreparedStatement (jdbc) on NULL

3 Answers3