Hi Guys,

I am new to hibernate, using version 3.2/DB - oracle 10g

I have a quick question - I need to insert a new record in a table. The table has a primary key - with the generator for this key set to a sequence.

The table has another column which needs to be generated from a sequence, only if that object field is 0. Right now I have that logic sitting in my DAO. I was wondering if theres a better or hibernate way of doing this....like putting this in a hbm.xml file ???


if (dataObject.getSomeId() == null || dataObject.getSomeId().longValue() <= 0) {
SQLQuery query = session.createSQLQuery("select DATA_SEQ.nextval from DUAL");
Number number = (Number) query.uniqueResult();
dataObject.setSomeId(new Long(number.longValue()));
}//end if

// insert new record
Object object = session.save(dataObject);

You could use a DB trigger.

Or if you want to do everything in the code, use

org.hibernate.Interceptor.onSave()