IMO this is a problem in H2. Hibernate sends the CREATE TABLE to H2 using Types#LONGVARCHAR -> longvarchar. E.g.:

create table Translation (
        id integer not null,
        text longvarchar,
        primary key (id)
    )

The table is created just fine. No errors, and table is present in the schema on return. As you have seen as well.

Then we validate that table using the JDBC metadata. Now, H2 reports that column as a varchar. That just seems wrong to me.