Hibernate not respecting MySQL auto_increment primary key field

Question

Hello,

I am trying to learn how Hibernate works, and I am running into an almost unacceptable learning curve. I can't see how to get Hibernate to respect the auto_increment policy for my objects. Instead, it is overwriting entries in the database with existing IDs, beginning with 1.

I have a simple Foo object, backed by a MySQL table defined like this:

CREATE TABLE `Foo` (
  `fooId` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`fooId`),
)

I have confirmed that inserting multiple Foo objects by hand with SQL (insert into Foo values();) does the right thing.

My Java class has the ID specified using annotations like this:

@Id
@GeneratedValue(strategy=GenerationType.AUTO)
@Column(name="fooId")
private Integer id;

I then execute some test code that simply instantiates Foo objects and saves them to the database (using session.save(obj)). It seems that it uses its own primary key sequence, beginning with one, and does not look at the table's key policy. It overwrites whatever was there.

I have tried variations on the @GeneratedValue bit (using all possible strategies, leaving off the parenthetic clause). Somebody even suggested leaving off the GeneratedValue entirely. Nothing seems to work.

Am I leaving something out? What am I missing? Is Hibernate really this hard?

(If anybody has an alternative Java database persistence option, please suggest one. I am making prototypes, not long-lasting mondo-engineered projects.)

Answer 1

I believe you want GenerationType.IDENTITY. MySql does not use a table or sequence for generating the Id value.

Answer 2

I think GenerationType.AUTO is right as is <id ...><generator class="native" /></id>

Picks an appropriate strategy for the particular database.

http://www.hibernate.org/hib_docs/ejb3-api/javax/persistence/GenerationType.html

http://www.hibernate.org/hib_docs/reference/en/html/mapping.html

Answer 3

I use the following with auto_increment, works perfectly:

@Id
@GeneratedValue(strategy = IDENTITY)
@Column(name = "db_id", unique = true, nullable = false)
public Long getDbId() {
    return this.dbId;
}

public void setDbId(Long dbId) {
    this.dbId = dbId;
}

Answer 4

I wrote this in a comment under the accepted answer, but those aren't shown by default so I'll re-post it as an answer.

I was using a hibernate.cfg.xml file off some dude's web site, and it had this:

<property name="hibernate.hbm2ddl.auto">create</property>

This made the system to re-create my table each time I ran my app. Commenting it out solved the problem.

The other two answers about the various ways to create IDs are correct. My original problem's symptom seemed to do with ID generation, but the actual cause was misconfiguration.

Answer 5

You might wish to have a look at: http://hibernatepojoge.sourceforge.net/

It claims to create a fully working application (spring, hibernate, junit tests, etc) just by pointing it to a DB.