Java Hibernate id auto increment

Question

Hy

I'v a little problem with hibernate on netbeans. I've a table with an Auto increment id :

CREATE TABLE "DVD"
(
    "DVD_ID" INT not null primary key
            GENERATED ALWAYS AS IDENTITY
            (START WITH 1, INCREMENT BY 1),
    "TITLE" VARCHAR(150),
    "COM" LONG VARCHAR,
 "COVER" VARCHAR(150) 

);

But this auto increment is not properly detected with Reverse Engineering. I get a map file with this :

<id name="dvdId" type="int">
    <column name="DVD_ID" />
    <generator class="assigned" />
</id>

i've looked on google and on this site ... foud some stuf but i'm still stuck..

i've tried to add insert="false" update="false" on the map file but i get back :

Caused by: org.xml.sax.SAXParseException: Attribute "insert" must be declared for element type "id".

Anny help will be pleased

Vincent

dsr · Accepted Answer · 2011-01-02 11:04:05Z

4

Change the generator class to "identity" if you want an auto-generated value from the database.

answered Jan 2, 2011 at 11:04

dsr

1,3162 gold badges14 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TLama · Accepted Answer · 2013-12-21 09:28:33Z

0

I'm not sure if I got you well but if you aren't using user input for "id" and you want it to autogenerate and autoincrement, then just change class="assigned" to class="increment".

edited Dec 21, 2013 at 9:28

TLama

76.9k17 gold badges226 silver badges418 bronze badges

answered Dec 21, 2013 at 9:10

Simiyu

1

Collectives™ on Stack Overflow

Java Hibernate id auto increment

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related