JSON datatype with Spring boot with hibernate in test environment

Asked Nov 12 '19 at 11:00

Active Nov 12 '19 at 12:34

Viewed 850 times

I am developing a project using Spring boot & Hibernate . I am using MySQL database in this application. In this application, some columns are of JSON type. I have also written Junit test case with MySQL database for this application.

Now I wants to use any in-memory database for Junit test case. I have tried H2, HSQL & Debry for this. I am failing to configure this database because these in-memory databases do not support the JSON data type. If I use MySQL database for Junit test case then it is works fine, but as soon as I change the database to an in-memory database then it fails to work.

Is there any solution for this JSON datatype ?

Note: It is necessary to use JSON column type in application so I can't change this JSON column type.

edited Nov 12 '19 at 12:34

Lukas Baliak

2,849
2
23
26

asked Nov 12 '19 at 11:00

Dhaval Goti

JSON is basically just a string/varchar. I guess there is a way to use this as solution – XtremeBaumer Nov 12 '19 at 11:13
Thanks for your suggestion XtremeBaumer But I as of now JSON is necessary to use it. – Dhaval Goti Nov 12 '19 at 11:15
Possible duplicate of [How can solve JSON column in H2](https://stackoverflow.com/questions/39620317/how-can-solve-json-column-in-h2) – XtremeBaumer Nov 12 '19 at 11:18
They are suggesting to use CLOB data type instead of JSON. But as I said earlier that JSON type is necessary to use for column. – Dhaval Goti Nov 12 '19 at 11:24
Read the more upvoted answer: https://stackoverflow.com/a/50837767/7109162 – XtremeBaumer Nov 12 '19 at 11:54

JSON datatype with Spring boot with hibernate in test environment

0 Answers0