aspose file tools*
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
Author

@Generatedvalue and MySQL

Kamil Kuchta
Greenhorn

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: 15299
    
    6

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


GenRocket - Experts at Building Test Data
Kamil Kuchta
Greenhorn

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

Joined: Oct 14, 2005
Posts: 18570
    
    8

Normally if you have a column where unique keys are auto-generated, you leave that column out of your INSERT statements.
 
Don't get me started about those stupid light bulbs.
 
subject: @Generatedvalue and MySQL