number fields in Hibernate ?

Posted on 2004-08-20
Last Modified: 2013-11-24
Hi guys! I'm developing a web applications using hibernate1.8 and struts1.0. Well I can't use the new versions of these tools because the company I work used the jdk1.3. :-( . The problem is that, in hibernate, when a table field declared as number and its nullable and when i query this in hibernate I'm getting a nullpointerexception (null can't be assinged to an int type).

classs Equipment {
    int highTemp = 0;


and the Table Equipment hightemp is a number and it's a nullable.

Any work around on this?Or maybe it's a bug in this version of hibernate, maybe just change the type of my table field

thanks in advance!


Question by:rdy1437
LVL 35

Expert Comment

ID: 11850666
>  when a table field declared as number and its nullable

It shouldn't be, it should be 0 not null. Can you post the hibernate mapping (just the specific tag that specifies this field) and the db schema for this field?
LVL 86

Accepted Solution

CEHJ earned 300 total points
ID: 11850667
It should probably map to Integer, not int. Try that
LVL 86

Expert Comment

ID: 11850672

classs Equipment {
   Integer highTemp = null;

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

LVL 20

Expert Comment

ID: 11852235
I agree with CEHJ on this. If you need a nullable Integer, you need the class Integer and not the primitive type int.


Author Comment

ID: 11857703
Hi girionis! here's the database schema

code   varchar(20) not null
description varchar(20) not null
hightemp number

so when you enter values(using sql plus) the field hightemp will just be blank.My program query this table only for displaying, the maintenance of this is done by others.And my hibernate mapping is like this (i ommited some of the tags)

<property name="code"/>
<property name="desc" column="description"/>
<property name="hightemp"/>


LVL 35

Expert Comment

ID: 11867911
Are you using MS Access? A "number" maps to an object type in Java, so CEHJ was right, change the hightemp to an Integer. Otherwise change the type of the column in the db. And as a side note, it's always good to do proper mapping in the config files:

<property name="hightemp">
    <column name="hightemp" sql-type="number"/>
LVL 86

Expert Comment

ID: 11868544

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now