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.