How to ask Hibernate to save a value depending on the database?

Question

Java

https://stackoverflow.com/questions/27804069/hiber...

How to make hibernate work with enum as needed depending on the database, the method above works with postgres, but tests on H2 fail, I want a universal implementation.

st.setObject(index, value.toString(),Types.OTHER); here in this line, if the database is H2, then a prefix is ​​added to the value and everything breaks because of this, if TYPE string everything works, but it breaks with postgres.

Maybe somewhere you need a typedef or @Type annotation how to redefine it differently, in general, if some methods are not crutch?

Answer 1

the above method works with postgres, but the tests for H2 fail, I want a universal implementation

do tests on embedded postgres

Answer 2

Changing code for tests is a bad idea.
It’s not at all clear what you are checking there if your test database is different from the one that will be on the production.
Look at testcontainers