Custom Datatype multiple Ddl

Support
1

I am working on a custom Datatype an i want to have different db data type per dbms.
So i use

@Ddl(dbms = "postgres", value = "jsonb")
@Ddl("CLOB")
public class MyDatatype implements Datatype<My> {
...
}

But studio generates SQL with varchar(255) in all dbms.
If i remove @Ddl("CLOB") and use postgres it works as expected.

What can i do?

2

Hi

Unfortunately I can’t reproduce the issue.
I’ve just checked the case above, and it works for me as expected.
“jsonb” for PostgreSQL and “CLOB” for other DBMS types.

What Jmix Studio version do you use?
Is it possible to provide small sample project where the issue can be reproduced?

Did you try to define @Ddl annotation for each DBMS type your application supports? Not using “default” one without dbms attribute.

3

Hi Alexander

I am using studio 2.3.2-242

What i have noticed is that i have the issue when the custom datatype is in an addon (that is the case).
When i create a custom datatype in the project, works as expected.

I work on a new addon GitHub - pbaris/jmix-multilingual-field: This add-on provides a custom datatype, a related field and a dataGrid column renderer, for storing, editing and displaying multilingual string values. · GitHub, if you want to check

4

Hi

Thank you for the project provided. I’ve reproduced the issue with this addon added to the sample project.

YouTrack issue created, so you can follow the progress.