I can't seem to find an easy way to have an arbitrary column be auto incremented. It's not the primary key, not the identity, just a normal column and I want it to auto increment. How can this be done?

Jshellman,

Do you want this arbitrary column to be autoincremented for each new record or once every record is saved?

For the former case you can just leave this to the database engine. For the latter you can use a hibernate version tag.
http://www.hibernate.org/hib_docs/v3/re ... on-version

Add some more details if I misunderstood your question :)

Marius

hi!

i have the same plroblem. i have an entity with a embedded primary key. this entity should have also a "counter". just a normal field defined with autoincrement. The auto increment should be 100000000. The Table created by hibernate should looks like:

CREATE TABLE PAYMENTTRANSACTION ( .... (other column definitions)...,
invoicenumber INT(9) NOT NULL AUTO_INCREMENT KEY) AUTO_INCREMENT = 100000000;

any new persisted entity should have the field invoicenumber with the autoincremented value. Something like this:

UUID | .... | INVOICENR |
ac7317a0-788c-11db-9fe1-0800200c9a66| .... | 100000001 |
ac7317a0-788c-11db-9fe1-0800200c9a67| .... | 100000002 |
ac7317a0-788c-11db-9fe1-0800200c9a68| .... | 100000003 |
ac7317a0-788c-11db-9fe1-0800200c9a69| .... | 100000004 |

could somebody help me?

i tried things like @Version, @Generated, @GeneratedValue, etc. but it does not work :(

Well this may help you or not ;-)
http://forum.hibernate.org/viewtopic.ph ... highlight=

I'm still searching for a solution that will consider the IP address so my visits are unique.