@Generatedvalue and MySQL

[Kamil Kuchta]

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

@Entity
public class Result {
@Id
//@GeneratedValue(strategy = GenerationType.AUTO)
//@GeneratedValue(strategy=GenerationType.IDENTITY)
//@SequenceGenerator(name="seq1", sequenceName="HIB_SEQ")
//@GeneratedValue(strategy=GenerationType.SEQUENCE, senerator="seq1") // no sequentions in MySQL - OK
//@Column(name = "id", nullable = false)
Long id;
... other field, getters, setters
}

Thanks for help!

[Gregg Bolinger]

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

[Kamil Kuchta]

Exactly. PrimaryKey, Integer, NotNull, Auto Inc, Unsigned, Zerofill

[Paul Clapham]

Normally if you have a column where unique keys are auto-generated, you leave that column out of your INSERT statements.