Inserting null to an Integer column using JDBC

by

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.

More Related Contents:

  1. How to get the insert ID in JDBC?
  2. Insert & fetch java.time.LocalDate objects to/from an SQL database such as H2
  3. java.util.Date vs java.sql.Date
  4. Using setDate in PreparedStatement
  5. Efficient way to do batch INSERTS with JDBC
  6. How do I get the size of a java.sql.ResultSet?
  7. How can I get the SQL of a PreparedStatement?
  8. What is the best approach using JDBC for parameterizing an IN clause? [duplicate]
  9. Variable column names using prepared statements
  10. MySQL and JDBC with rewriteBatchedStatements=true
  11. right syntax to use near ‘?’
  12. Running a .sql script using MySQL with JDBC
  13. JDBC Pagination
  14. Getting output from dbms_output.get_lines using JDBC
  15. org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
  16. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  17. Java – Can’t use ResultSet after connection close
  18. Timezones in SQL DATE vs java.sql.Date
  19. Queries returning multiple result sets
  20. SQL prepared statement how to select via multiple possible menu selections?
  21. Class.forName(JDBC_DRIVER) no longer needed?
  22. dll missing in JDBC
  23. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  24. Java – Storing SQL statements in an external file [closed]
  25. How to use prepared statement for select query in Java?
  26. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  27. MS SQL Exception: Incorrect syntax near ‘@P0’
  28. Java JDBC connection status
  29. MyBatis executing multiple sql statements in one go, is that possible?
  30. Database independence through JDBC in java

Leave a Comment