JPA @GenerateValue not generating values in MySQL

Question

I'm setting up a table/entity to auto-generate int values in the first column of a table which will most likely just be the primary key for now in Eclipse with MySQL. It looks like I have it set up correctly with:

@Entity
@Table(name="Table")
public class Table implements Serializable {
private static final long serialVersionUID = 1L;

@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@Column(unique=true, nullable=false)
private int id;

It's connecting to the database fine and actually persisting values to the non ID part. The problem is that it's not generating anything for the id. The mysql has a default value of '0' that it's placing in the id column. I'm not getting any errors it just fills the column with '0'.

Eelke · Accepted Answer · 2012-12-07 17:20:35Z

1

When you use a generation type of IDENTITY you tell JPA the database will do the id generation. So you will have to setup the column to use AUTO_INCREMENT.

answered Dec 7, 2012 at 17:20

Eelke

22.3k5 gold badges57 silver badges77 bronze badges

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

1 Comment

Randnum Over a year ago

That was it. I thought that JPA would some how "handle" this since I indicated my intent through annotation. But the mySQL AUT_INCREMENT works fine.

Collectives™ on Stack Overflow

JPA @GenerateValue not generating values in MySQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related