HIbernate not fetching value where the field is null in database record

Question

I am using the below hibernate code to fetch the data from database.

SessionFactory factory = null;
    Session session = null;
    try {
        factory = getSessionFactory();
        session = factory.openSession();

        final Criteria criteria = session
                .createCriteria(CrfEmailDataBean.class);
        criteria.add(Restrictions.eq(CAMPN_NBR, campNbr));
        returnList = criteria.list();
    } catch (Exception e) {
        logger.error(e.getMessage());
        throw new DAOException(e);
    } finally {
        DBUtil.close(factory, session);
    }
    if (logger.isInfoEnabled()) {
        logger.info(LOG_METHOD_EXIT);
    }
    return returnList;
}

Inside CrfEmailDataBean class, I have declared a private String crfEmailTypeCd; field which is null in database. Because of null, it is not setting the record in return list. If I go and enter a value inside the field in database, it fetches.

I tried running the query directly on sql database, the query formed is correct and fetches all the data.

Why it is not fetching that record? and how can I resolve this?

Not sure why people are upvoting this. Without the entity mapping nobody will be able to answer this question. — Jan-Willem Gmelig Meyling
– Jan-Willem Gmelig Meyling, Commented Aug 16, 2016 at 20:31
Hi all , I had recieved an answer which I am not able to see now . Based on his suggestion , I checked my hbm file . I had included the said field as composite-id in my hbm file . Now it is working .Thanks — themaster
– themaster, Commented Aug 17, 2016 at 7:11
What about CAMPN_NBR, campNbr, getSessionFactory(), CrfEmailDataBean.class? Provide the code, please. Which version of Hibernate do you use? — Rudziankoŭ
– Rudziankoŭ, Commented Aug 18, 2016 at 14:59
You should post your answer instead of adding it to question. Then it will be easier to other to find it. — talex
– talex, Commented Aug 18, 2016 at 15:18

Marcelo Ferreira · Accepted Answer · 2016-08-20 00:02:44Z

when you use type properties primitive same, need set the default value, same zero (0) or (a) ( ..)

private int number;
private int value;
private char option;

if hibernate database ready null, when converters of the Hibernate generator a error

solution for this never user primitive type
Or define de default value for properties
Each other possibility your date not null, this value white
white is different of the null
make a test put conditions Restrictions.isNotNull.
make other test put conditions Restrictions.isNull.
other test make a method receive int, call send one Integer null

first item

private Integer number;
private Integer  value;
private Character option;

last item test

public class Test{

    public static void setInt(int value){
       System.out.println(value);
    }

    public static void main(String[] args)
    {
        Integer testValue=null;
        Test.setInt(testValue);
    } }

Collectives™ on Stack Overflow

HIbernate not fetching value where the field is null in database record

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related