preparedStatement.getBigDecimal where the value is null
===

I have a prepared statement that works great when there is a value in all the columns but when there is a null I get this error.

    Bad value for type BigDecimal : N

Note the error is thrown when I try to use:

> priceListResult.getBigDecimal(6);

My Google foo is letting me down, I am having trouble finding any info on this. I'd have thought this would be a fairly common problem. 

Any help, or even background info to help me search this, much appreciated.

