search

jdeolive / geodb

Spatial database bindings for Java.
MIT License
67 stars 25 forks source link

H2 version supported ? #23

Open lcanet opened 9 years ago

lcanet commented 9 years ago

When running geodb-0.8 with an embedded H2 version 1.4.185, dropping an indexed spatial table produces an error : org.h2.jdbc.JdbcSQLException: General error: "java.lang.AbstractMethodError: net.sourceforge.hatbox.jts.InsertTrigger.remove()V"; SQL statement: DROP TABLE "carto"."test" CASCADE [50000-185]

What is the minimum/maximum H2 version supported by geodb ? Any plan to upgrade ?

jdeolive commented 9 years ago

It looks like the Trigger api in H2 was modified in 1.2.129, so the highest possible version of H2 that will work with the code as is will be 1.2.128. This is pretty ancient by now so yeah, definitely an upgrade is in order :).

The issue itself is in the hatbox library, another dependency of geodb. It looks like it has been addressed with version 1.0b8 though. You could dropping in that version and things might just work. I'll create a ticket for the upgrade though since it's well overdue.