Hibernate Unknown integral data type for ids

Question

I'm starting with Hibernate and I have an error that I just can't figure out.

I have the following Classes:

@Entity
@Inheritance(strategy = InheritanceType.TABLE_PER_CLASS)
public abstract class AbstractColumn {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private String id;
    private String name;

//Other stuff
}

Then I have

@Entity
public class DoubleColumn extends AbstractColumn  implements Column {

    @ElementCollection
    private Map<Double,String> isNA;
    private double min=0;
    private double max=0;
    @ElementCollection
    private List<Double> data;
    // a lot of stuff
}

And finally:

@Entity
public class DataFrame {
    @OneToMany(cascade = CascadeType.ALL)
    @PrimaryKeyJoinColumn
    private List<AbstractColumn> data;
    private String name;
    @Id
    @GeneratedValue
    private String id;
    @ElementCollection
    private Map<String,Integer> colIndex;
//more stuff
}

The error I'm getting is:

Exception in thread "main" org.hibernate.id.IdentifierGenerationException: Unknown integral data type for ids : java.lang.String
    at org.hibernate.id.IdentifierGeneratorHelper.getIntegralDataTypeHolder(IdentifierGeneratorHelper.java:224)
    at org.hibernate.id.enhanced.SequenceStructure$1.getNextValue(SequenceStructure.java:98)
    at org.hibernate.id.enhanced.NoopOptimizer.generate(NoopOptimizer.java:40)
    at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:432)
    at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:105)
    at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:192)
    at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:38)
    at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:177)
    at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:32)
    at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73)
    at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:675)
    at org.hibernate.internal.SessionImpl.save(SessionImpl.java:667)
    at org.hibernate.internal.SessionImpl.save(SessionImpl.java:662)
    at Main.main(Main.java:285)

The only hint that the error throws is that the error is in the main class here:

DoubleColumn c1 = new DoubleColumn("Datos varios");
        c1.addData(12);
        c1.addData(11);
        c1.addData(131);
        c1.addData(121);
        c1.addData(151);
        c1.addData(116);


        DataFrame datosHibernate = new DataFrame("Dataframe Hibernate");
        datosHibernate.addColumn(c1);


        Configuration hibernateConfig = new Configuration();
        SessionFactory sessionFactory = hibernateConfig.configure().buildSessionFactory();
        Session session = sessionFactory.openSession();
        session.beginTransaction();
        session.save(datosHibernate);
        session.getTransaction().commit();
        session.disconnect();
        session.close();
        System.exit(0);

The ids are Strings, and I have them annotated as @GeneratedValue (I think I do not need to initialize them myself). The relation @OneToMany have the cascade annotation so it should be mapped correctly.

I've tried the code WITHOUT the session.save line and doesn't throw errors, so is not a problem in the code per se, it has to be something with Hibernate.

My configuration file is:

<hibernate-configuration>
    <session-factory>
        <property name="connection.url">jdbc:h2:E:/bd;DB_CLOSE_DELAY=-1;MVCC=TRUE</property>
        <property name="connection.driver_class">org.h2.Driver</property>
        <property name="connection.username">user</property>
        <property name="connection.password"></property>
        <property name="dialect">org.hibernate.dialect.H2Dialect</property>
        <property name="show_sql">true</property>
        <property name="hbm2ddl.auto">create</property>

        <mapping class="com.dataframe.estructuras.DataFrame"></mapping>
        <mapping class="com.dataframe.estructuras.column.AbstractColumn"/>
        <mapping class="com.dataframe.estructuras.column.types.DoubleColumn"/>
    </session-factory>
</hibernate-configuration>

It creates the database file and I see all the SQL code generated, tables and all. Is when it tries to store the info when the thing breaks.

Yassin Hajaj · Accepted Answer · 2023-07-30 16:40:45Z

56

If you want String to be database key you need to use UUID to automatically generate key. Something like this:

@Id @GeneratedValue(generator="system-uuid")
@GenericGenerator(name="system-uuid", strategy = "uuid")
private String myId;

UPDATE

The way of doing has evolved to the following usage

import org.hibernate.annotations.UuidGenerator;
// other code 
@Id
@UuidGenerator
public String id;

edited Jul 30, 2023 at 16:40

Yassin Hajaj

22.1k10 gold badges60 silver badges93 bronze badges

answered Oct 21, 2016 at 13:30

user2026753

7477 silver badges7 bronze badges

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

5 Comments

Caronte Hades Over a year ago

And that solved the problem, but I have a new error if I can push my luck and paste it here... just in case :D

Caronte Hades Over a year ago

This is the new error: Error during managed flush [Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1] Thx for the help

Caronte Hades Over a year ago

Nevermind, solved. I was setting one of the ids in a different part. Everything seems to work. Thx again

Andy Over a year ago

Note that @GeneratedValue(generator="system-uuid") persists the generated UUID in the table, thereby the actual string value will not be saved. You should not use this if you want to save the String value in the table.

kerner1000 Over a year ago

@GenericGenerator is a hibernate annotation. How to do the same only with javax.persistence annotations? I am thinking about being independent from the database driver implementation.

Salami Korede · Accepted Answer · 2022-08-02 10:11:11Z

5

I was getting this error while using Postgres. I was using String for my Ids. Like this:

@Id

@GeneratedValue(strategy = GenerationType.AUTO)

private String id;

So I remove the @GeneratedValue annotation, as it doesn't go well with spring.

@Id

private String id;

Then it works!

answered Aug 2, 2022 at 10:11

Salami Korede

4295 silver badges10 bronze badges

Comments

Abdullah Umer · Accepted Answer · 2023-12-10 16:04:41Z

2

I was facing the same issue and changing the strategy = GenerationType.UUID fixed the issue.

@Id
@GeneratedValue(strategy = GenerationType.UUID)
private String id;

answered Dec 10, 2023 at 16:04

Abdullah Umer

4,6645 gold badges42 silver badges67 bronze badges

Comments

Aamir khan · Accepted Answer · 2021-06-23 12:01:03Z

0

Dear you have used string for the id that why it is causing issue. make it to int or long and check the database field as well . In case some one else come looking for an answer .

@GenericGenerator(name = "generator", strategy = "increment")
    @Id
    @GeneratedValue(generator = "generator")
    @Column(unique=true, nullable=false, precision=10,name="paymentid")
    private  Long

This will solve your problem

answered Jun 23, 2021 at 12:01

Aamir khan

1

Comments

Mick.zw · Accepted Answer · 2022-02-15 20:22:32Z

For future readers, especially those new to spring like myself, I had the same problem, even though my id was type Long.

Initially, I created the instance variables before annotating them, and then created the annotation at the to of all instance variables as shown below.

public class Student {
    @Id
    @SequenceGenerator(
            name = "student_sequence",
            sequenceName = "student_sequence",
            allocationSize = 1
    )
    @GeneratedValue(
            generator = "student_sequence",
            strategy = GenerationType.SEQUENCE
    )
    private String name;
    private Long id;
    private String email;

I only realised this problem after reading Aamir Khan's answer to this post, that in effect I was annotating the name(which is of type String) instead of the id, hence the error.

As can be seen from the solution below, putting id right below the annotations and just above the name solved the problem.

public class Student {
    @Id
    @SequenceGenerator(
            name = "student_sequence",
            sequenceName = "student_sequence",
            allocationSize = 1
    )
    @GeneratedValue(
            generator = "student_sequence",
            strategy = GenerationType.SEQUENCE
    )
    private Long id;
    private String name;
    private String email;

Collectives™ on Stack Overflow

Hibernate Unknown integral data type for ids

5 Answers 5

UPDATE

5 Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

UPDATE

5 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related