So, I think I've gone mad, I've tried every combination I can think of to get Hibernate to use a Native UUID object and a Postgres uuid type, whilst having my tests use H2, every attempt has resulted exceptions.
my latest is my own custom type, for which I can't figure out how to correctly detect the Dialect.
here's the package-info.java
I've also tried
which works great for postgres, but I can't get it to downgrade for H2.
I am at the point of guessing this can't be done currently, though it seems unreasonable because both Postgres and H2 support type "uuid".