What I have is a design issue.
Consider this Schema:
TBL_RESRC
Columns: ID (PK), PARENT (FK), CATERGORY_ENUM, NAME_DESC, VERSION_NUM

My requirement is to auto increment VERSION_NUM columm
Logic: version starts with 0 and increments there on, and is unique
Additional constraint: has to work in clustered environment
DB: Oracle 10g
ORM: Hibernate

My methods:
Use sequence in oracle, then add "trigger" to insert next val into the VERSION_NUM column

2 Questions:

* Is there a better way than this?
* Can I please have the hibernate mapping for using a sequence. Will the version in the doman object have to be int, long or something else


Thanks,
H-nate Learner

You can let hibernate do all this for you.

By default, hibernate uses optimistic locking using a version field.

So as long as you have a column that can be mapped using <version> in the mapping file you are good to go.

Here's the details.
http://www.hibernate.org/hib_docs/v3/re ... on-version

Thanks himawan