In-memory database alternative to HSQL which supports Partition By Query

Question

Working on Spring boot application test-cases. Was mocking Oracle database using hsql in-memory database but found it doesn't support partition by query and fails with below error:

Caused by: org.hsqldb.HsqlException: unexpected token: PARTITION required: )

Had checked Partition by modification but I don't want to modify my queries but use that database which support my queries.

Which alternative database will work here?

Did you know about h2? But ```H2 doesn't have any automatic data partitioning support.``` — Mykhailo Voloshyn, Aug 01 '18 at 13:23

score -1 · Answer 1 · answered Aug 01 '18 at 17:06

-1

The HyperXtrmeSQL database is based on HSQLDB and supports OVER(PARTIION ...) syntax. See http://hyperxtreme.co.uk/features.html (disclaimer: I am the developer)

answered Aug 01 '18 at 17:06

fredt

24,044
3
40
61

Thanks Fredt. But as I see its not free but paid software/library. I did't find link for downloading the jar or it's maven/gradle coordinates. Can you help me with this. – nanosoft Aug 03 '18 at 08:04

In-memory database alternative to HSQL which supports Partition By Query

1 Answers1