Inserting null to an Integer column using JDBC

Question

I have an sql column PROTOCOL, it is nullable and has a constraint on the table

PROTOCOL IN (1, 2, 3)

Also since it is nullable, I want to set and get null values into table

But I cannot do setInt and getInt as null. How to set a null to column as null using JDBC

setInt(4,null);

How can i get it after setting to null ;Will getInt Return null? — constantlearner, Jan 25 '13 at 10:56

Smit · Accepted Answer · 2016-06-24T17:13:07.593

95

Try using.

   pst.setNull(4, java.sql.Types.INTEGER);  //pst is prepared statement instance.

P.S. : Edited to reflect Java 8 updates.

edited Jun 24 '16 at 17:13

answered Jan 25 '13 at 02:57

Smit

How can i get it after setting to null ;Will getInt Return null? – constantlearner Jan 25 '13 at 10:55
@constantlearner I never had a occasion to use this, but surely you can try. – Smit Jan 25 '13 at 16:25
1

@Code-Apprentice only if you know in advance you want to insert `null`. – Qw3ry Nov 15 '17 at 17:11

score 28 · Answer 2 · answered Nov 15 '17 at 17:14

28

In addition to Smit's answer:

If you want to insert an Integer-object into a database that may be null, you can use

statement.setObject(4, yourObject, java.sql.Types.INTEGER);

instead of

if (yourObject == null) {
    statement.setNull(4, java.sql.Types.INTEGER);
else {
    statement.setInt(4, yourObject);
}

answered Nov 15 '17 at 17:14

Qw3ry

new in java8? `statement.setObject(4, yourObject, java.sql.JDBCType.INTEGER);` – Jayen Nov 24 '18 at 10:54
You actually don't need to provide the JDBCType | sql.Types jdbc figures it out by itself. Or at least the MSSQL driver does. – Marthinus Engelbrecht Mar 29 '20 at 15:32
In DB2, this won't work: java.sql.SQLFeatureNotSupportedException: setObject not implemented – Jaja Jan 27 '21 at 14:01
@Jaja are you referring to my answer, or to the comment from Marthinus Engelbrecht? – Qw3ry Jan 27 '21 at 17:37
@Qw3ry, NOT referring to your answer, I mean, there should be java.sql.Types instead of java.sql.JDBCType – Jaja Jan 27 '21 at 18:07

2 Answers2