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
– constantlearner, Commented Jan 25, 2013 at 10:56

Smit · Accepted Answer · 2016-06-24 17:13:07Z

96

Try using.

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

Interface PreparedStatement.setNull API

Mapping of java.sql.Types to SQL types

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

edited Jun 24, 2016 at 17:13

answered Jan 25, 2013 at 2:57

Smit

4,7151 gold badge27 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

constantlearner Over a year ago

How can i get it after setting to null ;Will getInt Return null?

Smit Over a year ago

@constantlearner I never had a occasion to use this, but surely you can try.

Qw3ry Over a year ago

@Code-Apprentice only if you know in advance you want to insert null.

Qw3ry · Accepted Answer · 2017-11-15 17:14:59Z

30

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, 2017 at 17:14

Qw3ry

1,44919 silver badges36 bronze badges

5 Comments

Jayen Over a year ago

new in java8? statement.setObject(4, yourObject, java.sql.JDBCType.INTEGER);

Marthinus Engelbrecht Over a year ago

You actually don't need to provide the JDBCType | sql.Types jdbc figures it out by itself. Or at least the MSSQL driver does.

Jaja Over a year ago

In DB2, this won't work: java.sql.SQLFeatureNotSupportedException: setObject not implemented

Qw3ry Over a year ago

@Jaja are you referring to my answer, or to the comment from Marthinus Engelbrecht?

Jaja Over a year ago

@Qw3ry, NOT referring to your answer, I mean, there should be java.sql.Types instead of java.sql.JDBCType

Collectives™ on Stack Overflow

Inserting null to an Integer column using JDBC

2 Answers 2

3 Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related