Search code examples
javadatabase-designobjectprimitive

Data Access Object Primitive Type vs Object type?

Would like opinions on the best way to go.

As you can see int cannot be null. Where as the object of Integer can.

Problem: Database values with a column that is number can be null or can contain a number. When the database passes the value of null, then we receive and exception stating that "primitive values cannot be null"

But when we use Integer class, we are creating that object (which of course is bigger/bulkier than a primitive type int)

So that brings up to me a couple of choices.

  1. Use Integer type.
  2. Set Database column to "default"
  3. Set int to default if there is something different in the database, then accept that

Any other suggestions?

Solution

  • Use Hibernate (or similar ORM) and let the framework deal with the database directly. Then you can program it how you like, and not have to deal with converting.

    Reinventing the wheel seldom works as well as just using someone else's wheel in the first place, especially when thousands of others already use the same wheel.