How to use a json column with MariaDB and H2

Viewed 20

I'm using MariaDb and i have JSON columns. but when i try running my integration tests on H2 database it's not working , the error shows : Table "SITE" not found; SQL statement

@Entity(name = "Site")
@Table(name = "site")
@TypeDefs({@TypeDef(name = "json", typeClass = JsonType.class)})

public class Site extends DBObjectWithId<Site> {

    @Column(name = "label", length = 255)
    public String label;

    @Type(type = "json")
    @Column(name = "country", columnDefinition = "json", length = 255)
    private CountryDto country;
}

i've seen some of the solutions about JSONB type but unlike postgre or mysql i'm afraid i can't use that in mariaDB.

0 Answers
Related