[CONJ-569] validate JPA sequence generation type with 10.3 Created: 2018-01-07  Updated: 2021-05-17  Resolved: 2021-05-17

Status: Closed
Project: MariaDB Connector/J
Component/s: Other
Affects Version/s: None
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Diego Dupin Assignee: Diego Dupin
Resolution: Done Votes: 1
Labels: None


 Description   

Using MariaDB, GeneratedValue must use GenerationType.IDENTITY (AUTO if Dialect is configured to MySQL/MariaDB will work too)

With 10.3, Sequence are now possible.
Task is to verify that GenerationType.SEQUENCE can be used with JPA.

 Comments   
Comment by Sebastian Knop [ 2018-11-20 ]

Using MariaDB 10.3 + Connector/J 2.3.0 with JPA does not produce a SEQUENCE as expected. Used annotations:
@Id
@GeneratedValue(generator = "PolicySeq", strategy = GenerationType.SEQUENCE)
@SequenceGenerator(name = "PolicySeq", sequenceName = "POLICY_SEQ", allocationSize = 50)
private Long id;

Comment by Sebastian Knop [ 2019-05-21 ]

@Diego Dupin this is still not functional as of Connector/J 2.4.1.

Comment by Diego Dupin [ 2021-05-17 ]

tested without issue

Generated at Thu Feb 08 03:16:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.