Hi Guys,

I am new to hibernate.
I have a query which goes like this

<![CDATA[select _usermaster.mobileNo,_usermaster.emailid, _usermaster.gender,_usermaster.location,_usermaster.profession,mobile_access.accessDesc,age_range.range from UserMaster _usermaster left outer join _usermaster.accessMasterByMobileAccessId mobile_access left outer join _usermaster.agegroupMaster age_range where _usermaster.userId = :userId ]]>

now _usermaster.emailid can be null in database.

All i want is if its null then i want it to return varchar type ''

How can we do it ?

Above query gives me the error

Any help will be highly appreciated.

Why do you want to have '' instead of null for the email address? With null you could easily tell that the email is not set explicitly to ''.

Nevertheless, I'm not sure of how you would convert that on load, but maybe you could use a Hibernate interceptor to convert a null email to '' if you encounter a UserMaster(?) entity.