# H2

Through the H2 (opens new window) connector, Ontop is able to construct VKGs on H2 databases, in memory, and on files.

# Limitations & Exceptions

  • SPARQL hash functions are not supported for H2.
  • Nested data types and the flatten lens are not supported for H2

# Database Connection

The following shows the content of a sample .properties file that can be used to connect Ontop to H2:

jdbc.url = jdbc:h2:mem:database-name
jdbc.user = user
jdbc.password = password
jdbc.driver = org.h2.Driver

# Nested Type Support

Nested data types and the flatten lens are not supported for H2.