Hello all!

I'm new in Hibernate annotations. I have a problem mapping an Entity.

Description:

I have an Entity with an EmbeddedId:

@EmbeddedId
@AttributeOverrides( {
@AttributeOverride(name="uuid", column = @Column(name=PAYMENT_TRANSACTION_ID) ),
})
private EntityPK pk = new EntityPK();

This entity also has a field, that should be auto incremented by the database.

@Column(name=PAYMENT_TRANSACTION_INVOICENR, length=9, insertable=false, updatable=false, unique=true)
@Generated(value=GenerationTime.INSERT)
private int invoicenr;


The Table daclaration should be something like that:

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

could somebody help me? I was trying it with:
1.-
@Generated(value=GenerationTime.INSERT)
2.-
@Column(length=9, unique=true, ...)
@GeneratedValue(strategy=GenerationType.AUTO)

but it didnt work.

greetings,

i have used:
@Column(name=PAYMENT_TRANSACTION_INVOICENR, columnDefinition="INT(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT UNIQUE", length=9)
private long invoicenr;

this works but it looks like:

000000001
000000002
000000003
000000004
etc.


i would like to get the AUTO_INCREMENT sequence with:
100000000, so that the values of the columns would be:

100000001
100000002
100000003
100000004
etc.

i can make that when i configure the table with AUTO_INCREMENT=100000000, that means for example:

create table t3 (c INT(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT UNIQUE, txt VARCHAR(4) DEFAULT 'FAKE') AUTO_INCREMENT=1000000000;

There is a way to do that with hibernate with an annotation?

Please, help me!