File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Hibernate not updating a null column Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate not updating a null column" Watch "Hibernate not updating a null column" New topic

Hibernate not updating a null column

Lisa Ray

Joined: Mar 05, 2009
Posts: 22
Hi All,
I've a DB table which has several columns. Hibernate can't update a DB row when a nullable column is null and through code I try to set it to a legal non-null value. That said, if the nullable column has a legal vale, Hibernate successfully updates its value. I can see the Hibernate generated UPDATE SQL in the log. Furthermore, while updating a nullable column which is null, Spring's Hibernate template doesn't return from saveOrUpdate() method call. In the log there's no exception. Seems like the exception is gets lost. Did anyone face the same issue?

Here's how it looks in code.

Service Layer

DAO Layer

What's happening here?
When I try to debug the app, it's strange to note that the control disappears after the saveOrUpdate call. The control never returns from the save method. Also, in the log file I can't see any exception propagated.

I agree. Here's the link:
subject: Hibernate not updating a null column
It's not a secret anymore!