data type (1111, 'jsonb') not recognized and will be ignored

[alex123asd123asd]

Hello. Does it possible to use JSONB in DB Rider Dataset?

My init SQL is:

CREATE TABLE IF NOT EXISTS my_table (
    id TEXT,
    tags JSONB
);

My dataset:

<dataset>
    <my_table id="001" tags="{}"/>
</dataset>

My test:

@Test
@DataSet("/datasets/data.xml")
void test() {
...
}

When runnig test I have the next issue:

12:46:16.816 [main] WARN org.dbunit.util.SQLHelper -- rp_alerts.raw_tags data type (1111, 'jsonb') not recognized and will be ignored. See FAQ for more information.

Caused by: org.dbunit.dataset.NoSuchColumnException: my_table.TAGS -  (Non-uppercase input column: tags) in ColumnNameToIndexes cache map. Note that the map's column names are NOT case sensitive.

[tomix26]

Hi, the embedded postgres is a standard version of PostgreSQL with all its core features, so JSONB type is supported. For DBRider related issues you need to contact someone more competent than me.