Hello,
I am using hibernate 2.1 and i got a problem. The scenerio is that i have a not null field in databse with default value.I am using Middle-Gen hibernate plugin to generate mapping files and then use hbm2java to generate my POJO (java bean). Alos i am using dynamic insert. Now to the real problem: i dont want to give value for taht field and wants that database inserts it automatically. But before passing the query to database hibernate give me error that i must specify a value for not-null column. Please help me asap as i am working on very important demo

Reggrads,
Shoaib Akhtar

just specify this field not-null = false as this constraint is managed by db.
Don't forget that is the db is updating the field (i suppose via a trigger), your hibernate session will contain stale data for the field...

Also specify insert="false", if you like.

Hello,
Thank for the answer Gavin. But i think that there should be some other way too as specifying not null false do not look elegant and insert = false will fail in the situation where one occasionaly wants to enter data in that field. There must be other way to do that.

>>Don't forget that is the db is updating the field (i suppose via a >>trigger), your hibernate session will contain stale data for the field...

I cannot unserstand what does this mean, is that hibernate will not contain data for this field after saving the record and i have to load this record again?????

Regards,
Shoaib Akhtar

Hello,
One thing i want to ask hibernate developers.... it is possible to get generated values in jdbc3 then there should be some tags defined in hibernate mapping file to tell hibernate that after saving the record get value for those fields which are generated by database. I think it is possible by using getGeneratedKeys. Please take it as feature request as many legacy database systems exists that have a filed as not null defined and has default values for it and user may need them in next transaction immediately after saving the record and without retrieving it again.

Regards,
Shoaib Akhtar

getGeneratedKey only retrieves primary keys, not arbitary default values.

Hello,
Thanks for your quick response and my apology for not knowing it already. But i must say that there should be some way to acheive this (refer to prevoius conversation please), not know exactly how? one possible solution is that we may specify through some new hibernate tags that it loads the data ( for not null default fields) for those fields using select statement after it has insert data into database.I mean to say that insert into..... and afterwards select not_null_default_values_fields from ..... and put in the perisistant object.

Regards,
Shoaib Akhtar

session.flush();
session.refresh(object);