Is it possible to have autoincrement number without it being an ID?

by

I see the following options:

1) You can use @Generated annotation.

You should have a table declared in the following way:

create sequence TST_DATA_SEQ increment by 1 start with 1;

create table TST_DATA (
   ...
   dat_auto integer default nextval('TST_DATA_SEQ'),
   ...
);

and appropriate column in the entity:

   @Generated(value = GenerationTime.INSERT)
   @Column(name = "dat_auto", insertable = false, updatable = false)
   private Long auto;

Note that according to the documentation:

Properties marked as generated must additionally be non-insertable and non-updateable.

So, hibernate will make additional query to populate the auto field after flushing.

   Data data = new Data();
   // filling fields except data.auto
   session.persist(data);
   session.flush();

insert into TST_DATA (dat_name, dat_id) 
values (?, ?)

Hibernate: /* get generated state com.example.hibernate.Data */
  select data_.dat_auto as dat_auto_0_ 
  from TST_DATA data_ 
  where data_.dat_id=?

2) You can use @GeneratorType annotation.

You should have an implementation of hibernate ValueGenerator. The simple example you can see below.

import java.math.BigInteger;
import org.hibernate.Session;
import org.hibernate.tuple.ValueGenerator;

public class MyGenerator implements ValueGenerator<Long> 
{
   public Long generateValue(Session session, Object owner)
   {
      return (
         (BigInteger) session
            .createNativeQuery("select nextval('TST_DATA_SEQ')")
            .getSingleResult()
         ).longValue();
   }
}

And then you can use it like this:

   @GeneratorType(type = MyGenerator.class, when = GenerationTime.INSERT)
   @Column(name = "dat_auto")
   private Long auto;

In this case you should not provide the default value for the column declaration as was required in n1. and the appropriate entity field should not have @Column(... insertable = false, updatable = false). Each time when this entity will be persisted, hibernate generates query:

select nextval('TST_DATA_SEQ')

and populate this value to the auto field.

More Related Contents:

  1. How to work with PGpoint for Geolocation using PostgreSQL?
  2. JPA and PostgreSQL with GenerationType.IDENTITY
  3. Mapping PostgreSQL JSON column to a Hibernate entity property
  4. what is @JoinColumn and how it is used in Hibernate
  5. Cannot create a database table named ‘user’ in PostgreSQL
  6. JPA Uppercase table names
  7. @BatchSize a smart or stupid use?
  8. Configure JPA to let PostgreSQL generate the primary key value
  9. Large Objects may not be used in auto-commit mode
  10. Persisting UUID in PostgreSQL using JPA
  11. Redundant data in update statements
  12. having an exception when saving oracle type object in some entity
  13. Calculating and saving space in PostgreSQL
  14. How can I make a JPA OneToOne relation lazy
  15. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  16. how to emulate “insert ignore” and “on duplicate key update” (sql merge) with postgresql?
  17. How do I efficiently select the previous non-null value?
  18. How do I do large non-blocking updates in PostgreSQL?
  19. annotation to filter results of a @OneToMany association
  20. Dynamic SQL (EXECUTE) as condition for IF statement
  21. uWSGI, Flask, sqlalchemy, and postgres: SSL error: decryption failed or bad record mac
  22. serial in postgres is being increased even though I added on conflict do nothing
  23. Can’t connect to Postgresql on port 5432
  24. Spark Dataframes UPSERT to Postgres Table
  25. Is it possible to dynamically define column names in Hibernate / JPA?
  26. ERROR: permission denied for relation tablename on Postgres while trying a SELECT as a readonly user
  27. PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement
  28. Multicolumn index on 3 fields with heterogenous data types
  29. Select from a table variable
  30. How to map one class with multiple tables in Hibernate/javax.persistance?

Leave a Comment