Hi, my basic problem is that I am trying to use hibernate to insert a record but I keep getting an exception because it is trying to insert '' into date fields that aren't filled and this is the wrong syntax.

More info:

I am using Postgres 8.4.
I am reading the SQL using p6spy
My exception message is "Exception: org.hibernate.exception.DataException: could not insert: [com.company.Mytable]"

Any assistance is appreciated. I thank you in advance!

I found the answer!

In the class tag of the hbm.xml file, add dynamic-insert="true"

This property makes it only insert non-null columns.