Null database column becoming zero on resultSet

Question

I cant show you my database structure... but i can try to do an example:

Table Car_Manufacturer 
(
  car_id NUMBER;
  manuFacturer_id NUMBER;
)

Values:

|TABLE CAR_MANUFACTURER   |
| CAR_ID |MANUFACTURER_ID |
|    1   |     1284       |
|    2   |    (null)      |

Select that my resultSet receives:

select * from CAR_MANUFACTURER where car_id = 2

I can get the CAR_ID:

int id = rs.get("car_id");

the output from id value:

2

But, when i try to get MANUFACTURER_ID the null value becomes an integer:

Integer manId = rs.get("manufacturer_id");

Output manId

0

Any idea? I need to get NULL value... not an integer value.

Answer 1

Check the accepted answer here: How do I in JDBC read a possibly null double value from resultSet?.

It gives you a way of knowing whether the value read was null and defaulted to some value when rs.getXXX was called.