Hibernate inserts null for date field in table whose default value is set to sysdate in table

Question

I'm creating web application. I'm using Spring and hibernate. When doing the below,

userprofile.setFirstName(firstname); userprofile.setLastName(lastname); userprofile.setDob(bday); userprofile.setPhoneNumber(telephone); userprofile.setEmailId(email); userprofile.setPassword(password); // userprofile.setCreatedDate(sysdate); session.save(userprofile); t.commit();

Hibernate is generating the below insert query

Hibernate: insert into USER_PROFILE (CREATED_DATE, DATE_OF_BIRTH, EMAIL_ID, FIRST_NAME, LAST_NAME, PASSWORD, PHONE_NUMBER, PROFILE_ID) values (?, ?, ?, ?, ?, ?, ?, ?)

which is inserting null value in my created_date field. I've made that created_date field's default value as sysdate. Please help me to sort out this.

Post your userprofile class

Javi Mollá
– Javi Mollá

2018-09-25 12:49:30 +00:00
Commented Sep 25, 2018 at 12:49 — Javi Mollá
– Javi Mollá, Commented Sep 25, 2018 at 12:49

Jefila · Accepted Answer · 2018-09-26 04:52:39Z

I got it resolved..In pojo class, the following insertable=false should be added. This will avoid insertion of null and default value set in table will be inserted instead.

@Column(name = "CREATED_DATE", insertable=false) private Date createdDate;

Collectives™ on Stack Overflow

Hibernate inserts null for date field in table whose default value is set to sysdate in table

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related