jQuery in Action, 3rd edition
The moose likes Object Relational Mapping and the fly likes @Generatedvalue and MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "@Generatedvalue and MySQL" Watch "@Generatedvalue and MySQL" New topic

@Generatedvalue and MySQL

Kamil Kuchta

Joined: Mar 09, 2009
Posts: 17
I can't generate id value in MySQL using @Generatedvalue.
SQLException: no value for 2 parameter in exprection INSERT INTO tab(value, id) values(?, ?)

I tried to use everything what is in commentary

Thanks for help!
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15302

Is the column in the database defined correctly as a auto increment column?

GenRocket - Experts at Building Test Data
Kamil Kuchta

Joined: Mar 09, 2009
Posts: 17
Exactly. PrimaryKey, Integer, NotNull, Auto Inc, Unsigned, Zerofill
Paul Clapham

Joined: Oct 14, 2005
Posts: 19973

Normally if you have a column where unique keys are auto-generated, you leave that column out of your INSERT statements.
I agree. Here's the link: http://aspose.com/file-tools
subject: @Generatedvalue and MySQL
jQuery in Action, 3rd edition