Hi,

I'm using Spring & Hibernate with Oracle. In order to deal with the special NULL/empty handling of Oracle, I change the getter method to change NULL to empty string is null

e.g.
public getName(String name) {
if (name != null)
return null;
else
return "";
}

once I change this, I got the hibernate exception saying that I don't have the update permission on the Oracle tables. It's because the Oracle account has only read-only permission.

why got this behaivour? if i remove the check null logic, it's working fine.

thanks!

You are changing the value of the name while returning it from the getName() method.

Hibernate will compare the objects by value—not by object identity—to determine if the property’s persistent state
needs to be updated.

As default-access is property, getName() is invoked to check if object's state has changed and hence upate is fired.

Change the field-access to 'field' and no update is fired. like..

default-access="field"