Hibernate version: 3.0

Hi,

Doing a query by criteria, if some fields in the table are null then the values of the objects are not loaded even though the correct amount of objects is loaded from the db.

Has anyone seen that?

If I fill the null fields in the db, then the objects get loaded completely...

Best Regards,
Jean Safar

Hi,

Hibernate will not insert null into the Database Tables. So ideally i will throw CGLIB warning when you try to retrieve values from the table if it is null. So make the null values in the DB to empty spaces.

I think you have used JDBC to before for inserting the values, So that is the problem. Set all the values to empty in the DB when they are null. Dont use SQL queries manually to the DB from the Code to insert or update then hibernate will complain.

SO USE ONLY HIBERNATE FOR ALL OPERATIONS

Hi,

Thanx a lot for the answer.

Yet, hibernate is the one that puts the null in the first place.

Also, it should be valid to have sparse rows. Is it possible to override this behavior and if the value is null in a cell to not throw an exception?

Hi,

Check this out,

http://www.hibernate.org/116.html