MySQL SMALLINT column returns 0 in java.lang.Short when the value is null

I've com across this and I haven't been able to find the proper documentation.

Basically I have in a MySQL table a column that is used to hold a year value the type of the column is SMALLINT the column can be null, and whenever I retrieve the value (NULL) using the method resultset.getShort("year"); I get a 开发者_如何学C0 instead of the expected null value.

The year value is a member of a bean that means that I use accessor methods, so when I use a CallableStatement object and I set the placeholders accordingly I get a NullPointerException I know this should be expected but there are cases when I need to explicitly set the value to null such as when the year is not supplied or the user enters letters or a string that is not a "year"

Is this the default behavior as the other wrapper classes for primitives do allow null values.

What is the right type mapping to a SMALLINT or should I change the column to INT?

I don't know this library (or Java, for that matter), but I think I found the code here and took a peek. It seems that getShort always returns a short, and never null, but you can use wasNull to check if the last retreived value was actually null.

Check the JDBC documentation. getShort() et al return 0 when the corresponding database column is null. You need to call wasNull() afterwards to check if it was really null.

This is one of the most broken APIs EVER.

You should check the value of resultSet.wasNull to see if you read a NULL or a 0.

Add -Dorg.apache.el.parser.COERCE_TO_ZERO=false to your apache launch configs.