H2 Database error Unknown data type INTERVAL

Question

I'm working on integration tests for a JPA project. The tests run on an embedded h2 database. However, I'm getting an error from h2 during hibernate schema generation when I use

@Column(columnDefinition = "INTERVAL HOUR TO MINUTE")

The error is org.h2.jdbc.JdbcSQLException: Unknown data type: "INTERVAL";

The h2 documentation indicates that INTERVAL is supported:

http://www.h2database.com/html/datatypes.html#interval_type

I am using h2 version 1.4.197

Stepping away from JPA and working directly in the h2 console, I have tried the following script which also generates the Unknown data type error:

CREATE TABLE test_interval (id INTEGER, test_hours INTERVAL HOUR TO MINUTE);

I have tried other variations of the INTERVAL type, all of which generate the same error

I can not find any discussion of this issue anywhere.

Evgenij Ryazanov · Accepted Answer · 2019-11-02 04:57:36Z

4

You need to use a more recent version of H2. H2 supports the standard INTERVAL data type since 1.4.198, but 1.4.198 is a beta-quality version, use a more recent one, such as 1.4.199 or 1.4.200.

The online documentation is actual only for the latest release, currently it is 1.4.200. If you use some older version, you have to use the documentation from its distribution.

answered Nov 2, 2019 at 4:57

Evgenij Ryazanov

8,3932 gold badges15 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

jlar310 Over a year ago

Wow, really? I guess it was my mistake to presume that such a widely used library used semantic version numbering. Without that, then perhaps the docs should be a little more informative on when new features were put in place.

Evgenij Ryazanov Over a year ago

H2 never had semantic versions, the releases are simply named sequentially.

Collectives™ on Stack Overflow

H2 Database error Unknown data type INTERVAL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related