I considered the use of a resolveDialect a while ago, but rejected it at the time because some databases have alternative spatial implementations available. Postgis is an extension of Postgresql, and in a given postgresql database you can install almost any version of postgis (which version is in use can be queried in SQL, but is of course not exposed in JDBC Metadata). Oracle11g has two spatial implementations. But maybe we can use resolveDialect to presuppose a sane default, and maybe use a configuration to have the user select a version of Postgis or Oracle. Love to see that happening.

I'll try to find the time tomorrow to go on IRC to chat with you about this. I'll have a look at the Envers code in the mean time.