I am using hibernate annotation to map model objects to db columns, is there any configuration settings to exclude null columns from the insert/update hql queries ?

Here is the scenario :
I have the table of user information. Along with user information i am storing user's photo as well ( BLOB). It is not mandatory that always i need to load the photo ( binary data) during update operation. So during update the particular property for the image in the model object will be null. This overrides the database information with null


any possible solution ?

Hi,

Please set the following attributes at class level:

dynamic-insert="true"
dynamic-update="true"

This will ensure that only updated columns are included in the insert, update queries.

In your case, if the image is not loaded, that column will not be part of the hibernate query.

Hope it helps,
-Kadle

Hi Vardhan,

Did this help you?

Please acknowledge.

Thanks in advance,
-Kadle