Support binary(16) type for UUID in reverse engineering database to model

[tom.monnier]

I’m experimenting with reverse engineering one of our applications to jmix for back-office purposes.

We use UUID but stored in binary(16) format in mysql.

I found this topic on implementing an attribute converter, but that doesn’t help with reverse engineering the database to model.

UUIDAttributeConverter.convertToDatabaseColumn is not called at all

I wrote an attribute converter to use binary 16 instead of char 36 in mysql for primery keys. I added this file to project: package com.company.jmix02; import javax.persistence.AttributeConverter; import javax.persistence.Converter; import java.nio.ByteBuffer; import java.util.UUID; @Converter(autoApply = false) public class UUIDAttributeConverter implements AttributeConverter<UUID, byte[]> { @Override public byte[] convertToDatabaseColumn(UUID uuid) { if (uuid == null) retur…

[bank (Steffen Bank)]

I have an issue with custom data types too, but did not find or get a solution yet:
Custom datatypes in Jmix 2.0

[krivopustov (Konstantin Krivopustov)]

@tom.monnier

I found this topic on implementing an attribute converter, but that doesn’t help with reverse engineering the database to model.

Runtime support for binary(16) format in MySql is demonstrated in this project: GitHub - jmix-projects/mysql-bin16-uuid-demo
Created issue to implement it in Studio reverse engineering feature: https://youtrack.jmix.io/issue/JST-4272/Support-for-binary16-UUID-type-in-MySQL