Add GeneratedValue strategy to generate ID automaticially

[hantsy]

Like the JPA and Micronaut Data Jdbc/R2dbc, add JPA @GeneratedValue(strategy) similar feature to generate ID automatically before inserting.

[DiegoKrupitza]

I think that @GeneratedValue depends on issue #1171

[schauder]

@DiegoKrupitza I'm not sure how these would depend on each other.
Of course, there might be generators that depend on some database infrastructure, but many won't and either way one can still require the user to ensure that infrastructure is there.

[cooperlyt]

is there no any update?

[ikuchmin]

is there no any update?

[mipo256]

Can you please, clarify, what exactly is required here? @ikuchmin @cooperlyt @hantsy

We already have the @Sequence support since Spring Data JDBC 3.5. This is also support in Spring Data R2DBC by the way. It allows the automatic fetching of the id from the sequence in the database, like:

@Table
public class MyTable {

    @Sequence("my_seq")
    Long id;
   
    String name;
}

In case of inserting the MyTable entity, the SELECT NEXT VALUE FROM or smth similar will be triggered. Does this satisfy the requirement? Or the requirement is more like the Strategy.UUID in JPA?