Hibernate auto increment id sql server 2005
10,646
It seems i figured it out thanks to related question: Hibernate Auto Increment ID
@GeneratedValue(strategy = javax.persistence.GenerationType.IDENTITY)
Is now doing the trick for me to auto-increment the EVENT_ID.
So my new code for event_id is:
@Id
@GeneratedValue(strategy = javax.persistence.GenerationType.IDENTITY)
@Column(name="EVENT_ID", unique = true, nullable = false)
private int event_id;
Author by
Jeroen van Veghel
BY DAY: developing/maintaining/supporting our own framework BY NIGHT: training myself in other languages
Updated on June 04, 2022Comments
-
Jeroen van Veghel almost 2 years
I'm trying to learn hibernate with annotations. Now I've set up a successful database connection with SQL SERVER 2005. I've made a class event, but the following exception comes up:
Hibernate: insert into EVENTS (EVENT_DATE, title) values (?, ?) 1235 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 515, SQLState:23000 1235 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot insert the value NULL into column 'id', table 'hibernate_db.dbo.EVENTS'; column does not allow nulls. INSERT fails.
the event class:
@Entity @Table( name = "EVENTS" ) public class Event { @Id @GeneratedValue(strategy=GenerationType.IDENTITY) @Column(name = "EVENT_ID", unique = true, nullable = false) private int event_id;
If you need more information please say so. Can someone help me out? I absolutely have no idea what is wrong with my auto incrementing event_id...