I'm trying to persist a object with the following code:



myObject is a instance of Class MyObject & most of the fields are set from Spring form. Only the columns which have default values defined in MySQL are not set e.g. ID


There are other fields too like current_TS which has default in MYSQL.

But upon execution i get the following error:


How to persist an object without setting it's default values so that MySQL sets those default values. Please guide.
I'm stuck...please help.

I just implemented auto id using Hibernate using MySQL with no problems.

Is the column name in the database for myObject really "MyObjectId"; that doesn't seem like a typical column name, you may want to double check that.

The only times -- of which I am aware -- that mysql will automatically set a column is with an auto increment or timestamp column.

The issue is resolved now. Thanks a lot.

Hi,

Mapping of Id generation seems fine, you can also use as
@Id
@GeneratedValue
@Column(name="id")
public Integer getId() {
return id;
}

Where Id will be primaryKey declared as
id INT PRIMARY KEY AUTO_INCREMENT

You can try using new session for the same purpose if current session has been clear / closed by some thread.
SessionFactory().openSession()

If you are using Hibernate with Spring, we can always use HibernateTemplate
getHibernateTemplate().getSessionFactory().getCurrentSession()