( Hibernate Oracle cannot insert NULL ) How to insert auto generated ID?

Question

I am working on project where I am using hibernate to perform CRUD operations. I have user model and I am trying to insert the information but keeping getting this error

Hibernate: insert into APPUSER (dob, email, firstName, lastName, password) values (?, ?, ?, ?, ?)
Jun 21, 2016 2:17:07 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 1400, SQLState: 23000
Jun 21, 2016 2:17:07 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: ORA-01400: cannot insert NULL into ("MYAPP8785"."APPUSER"."ID")

The user model looks like

@Entity
@Table(name="APPUSER")
public class AppUser {


    @Id 
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;

    @Email
    @Size(max = 50)
    private String email;

    @Column
    private String dob;

    @Column
    private String firstName;

    @Column
    private String lastName;

    @Column(name = "password", nullable = false)
    private String password;
}

Hibernate properties like

properties.put("hibernate.dialect","org.hibernate.dialect.MySQLDialect");
//properties.put("hibernate.current_session_context_class","thread");
properties.put("hibernate.hbm2ddl.auto","update");
properties.put("hibernate.show_sql","true");

I am under the impression that hibernate would auto generate id for me and insert them using sequence

If you want to use a sequence for id generation, you have to configure that in your annotation (GenerationType.SEQUENCE). Oracle doesn't support identity columns, so your current id generation configuration has no effect. — dunni, Jun 21 '16 at 06:34
Also, using MySQLDialect with Oracle makes little sense. Use the appropriate dialect. — JB Nizet, Jun 21 '16 at 06:35

score 6 · Accepted Answer · edited Jan 05 '18 at 13:18

6

Some errors :

Use the right dialect : org.hibernate.dialect.Oracle10gDialect (no specific dialect for 11g).
do not use primitive type for hibernate generated ID (use Integer, not int)

IDENTITY for ID generation is supported by oracle only since version 12c

You should use another strategy, like using sequence for example.

The mapping would look like :

@Id
@SequenceGenerator(name = "generator", sequenceName = "ID_SEQUENCE", allocationSize = 1)
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "generator")
@Column(name = "ID")
private Integer id;

edited Jan 05 '18 at 13:18

Vlad Mihalcea

142,745
71
566
911

answered Jun 21 '16 at 06:43

Thierry

5,270
33
39

Oracle version installed on a server I'm using is 11g. So as mentioned in the answer i used the Sequence generation strategy. I tried using TABLE and AUTO strategies as well. However, when i try to insert a record onto the table, it tells me that ID cannot be null. Shouldn't the ID be auto generated? Is there anything I'm missing? – Dilini Peiris Apr 05 '22 at 10:26

score 1 · Answer 2 · answered May 30 '17 at 18:59

I see that you found a usable answer, but since I had this same problem and came across this post while searching for a solution, I will include what worked for me. I am using Oracle 12c - and this will ONLY work with 12c - the solution was to change the dialect to Oracle12cDialect. Otherwise, simply using

@GeneratedValue(strategy = GenerationType.IDENTITY)

worked.

score 0 · Answer 3 · edited May 23 '17 at 12:09

0

You need to create the table APPUSER such that its primary key ID has auto increment feature. Please follow the link How to create id with AUTO_INCREMENT on Oracle? on how to do it. Only then you will see that hibernate will insert the value in the primary key field for you.

edited May 23 '17 at 12:09

Community

1
1

answered Jun 21 '16 at 06:36

Sanjeev Saha

2,632
1
12
19

( Hibernate Oracle cannot insert NULL ) How to insert auto generated ID?

3 Answers3