how create json type for java Map interface in entity

Question

I have this field

   @Type(type = "json")
@Column(columnDefinition = "json")
private Map<String, String> businessHours;

and this is on top of my class

@TypeDefs({
        @TypeDef(name = "json", typeClass = JsonType.class)//this is error
})

and this is migartion

 alter table properties alter column business_houres type json USING business_hours::json;

but it can't understand JsonType it is red

deepakchethan · Accepted Answer · 2021-10-05 14:24:17Z

2

You should be using JsonBinaryType.class or JsonStringType.class for the type json and JsonType.class is not a type that comes out of the box.

@TypeDefs({
  @TypeDef(name = "json", typeClass = JsonBinaryType.class)
})
public class BaseEntity {
   @Type(type = "json")
   @Column(columnDefinition = "json")
   private BusinessHours businessHours;
}

You can create a wrapper class that stores the businessHours as follows:

public class BusinessHours implements Serializable {
    private Map<String, String> businessHours; 
}

edited Oct 5, 2021 at 14:24

answered Oct 5, 2021 at 14:05

deepakchethan

5,6301 gold badge26 silver badges34 bronze badges

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

9 Comments

Jack Nickelson Over a year ago

I agree but after set some map and then save it gives me this error. ERROR: column "business_hours" is of type json but expression is of type character varying Hint: You will need to rewrite or cast the expression.

deepakchethan Over a year ago

@JackNickelson I have updated my answer can you see if using the wrapper class with JsonBinaryType.class solves your question?

Jack Nickelson Over a year ago

I don't need binary it has ordering but now i set String one but after setting some map and saving it it gives this error ERROR: column "business_hours" is of type json but expression is of type character varying Hint: You will need to rewrite or cast the expression.

Jack Nickelson Over a year ago

stackoverflow.com/users/7836833/deepakchethan

deepakchethan Over a year ago

@JackNickelson can you try with creating BusinessHours.java with the map instead and see if that helps?

|

Collectives™ on Stack Overflow

how create json type for java Map interface in entity

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related