SequenceGenerator ignored in changelog generation

Support
,
#1

Hi i’m trying to generate a custom sequence via annotation in this way:
@SystemLevel
@SequenceGenerator(name = “foo_seq”, sequenceName = “foo_seq”, allocationSize = 1)
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = “foo_seq”)
@Column(name = “SEQ_ID”, nullable = false)
protected Long seqId;

but getting ignored in changelog generation

Thank’s for helping!

#2

UPDATE

The changelog is generated only if there’s in addition the @Id annotation

@SystemLevel
@SequenceGenerator(name = "foo_seq", sequenceName = "foo_seq", allocationSize = 1)
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "foo_seq")
@Column(name = "SEQ_ID", nullable = false)
@Id
protected Long seqId;

and the changelog is:

<createSequence incrementBy="1"
                sequenceName="foo_seq"
                startValue="1"/>"

But it could be necessary to manage a sequence on a field that is not PK

#3

Hi

We currently don’t support using the SequenceGenerator annotation on base fields within entities. To address this, I’ve created an issue on our Jmix Studio bug tracker.

You can track progress here: Issue - Support SequenceGenerator annotation on base fields in Entity.

This enhancement will enable changelog generation and improve the design of entity fields using sequences in the future.
Your feedback is appreciated!

Regards,
Dmitry