The current APIs getText(), getLong(), etc return non-null values and if the column has a null value (isNull() returns true) then calling the get function is a bit undefined. It is undefined because of differences in platform (JVM vs native), it might throw a NPE (native) or it might return some default value (JVM).
It is best if the behavior aligns on all platforms, throwing a NPE if the value in the column is null.
To improve the user experience a set of get*OrNull() APIs can be introduced to reduce the verbosity of if (stmt.isNull(0)) null else stmt.getText(0)
Description
The current APIs
getText(),getLong(), etc return non-null values and if the column has a null value (isNull()returnstrue) then calling the get function is a bit undefined. It is undefined because of differences in platform (JVM vs native), it might throw a NPE (native) or it might return some default value (JVM).It is best if the behavior aligns on all platforms, throwing a NPE if the value in the column is null.
To improve the user experience a set of
get*OrNull()APIs can be introduced to reduce the verbosity ofif (stmt.isNull(0)) null else stmt.getText(0)