JDBC Applications: Handling NULL Values Returned into Result Sets (Doc ID 1079810.6)

Last updated on MARCH 18, 2024

Applies to:

Symptoms

 Problem Description:
====================
Your client application uses JDBC.  In this program you return a result set
where some of the column values returned are NULL.

When you try to make assignments to local JDBC variables, as the following example
illustrates, you encounter the NullPointerException error.
 
 
Problem Explanation:
====================
Here is one example where this could occur, but there may be other cases too.
                 

 
The problem is encountered on the 5th and 6th element of the result set.

Changes

Cause