Json Typedef for Spring DataJPATests and Postgres

Question

I am using Hibernate in SpringBoot to manage my DB layer. I have a json column in my Hibernate Entity:

    @Type(type = "json")
    @Column(columnDefinition = "json")
    private LibraryContent libraryContent;

I am using Postgres for production and H2 when running my tests using the @DataJPATest annotation.

To get the json column to work with postgres I had to add:

@TypeDef(name = "json", typeClass = JsonBinaryType.class)

However, when I run my tests with this I get:

Caused by: org.h2.jdbc.JdbcSQLDataException: Data conversion error converting "OTHER to JSON"

But when I change the @TypeDef typeClass to JsonStringType.class, the tests will all run, but I will get an error when running the application with Postgres saying that it cannot convert type json to varchar.

Is there another way to map the json column so that it works for H2 (testing) and Postgres (prod)?

Or is there a way to specify different @TypeDefs for different SpringBoot Profiles?

I did not, I just manually switch the @TypeDef between JsonBinaryType and JsonStringType depending on the environment I'm using. — nsharma98
– nsharma98, Commented Mar 16, 2021 at 19:29

Riberto Junior · Accepted Answer · 2021-11-19 14:20:10Z

2

I added two package-info.java one in the tests folder with JsonStringType for h2 and another with JsonBinaryType for postgree

answered Nov 19, 2021 at 14:20

Riberto Junior

3232 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Hellfish80 Over a year ago

Could you post a small example by chance?

Riberto Junior Over a year ago

On your model package-info.java: @TypeDef(name = "jsonb", typeClass = JsonBinaryType.class). On your test package-info.java: @TypeDef(name = "jsonb", typeClass = JsonStringType.class).

Collectives™ on Stack Overflow

Json Typedef for Spring DataJPATests and Postgres

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related