While working with Postgres JSONB type and Java, if we assign the value of type UUID as a string then we will get the following exception.
org.postgresql.util.PSQLException: ERROR: column "column" is of type jsonb but expression is of type character varying Hint: You will need to rewrite or cast the expression.
To assigning value incorrect way is given below, if you are using
First, in the query, you need to write input param par as given below for the PreparedStatement. You need to use to_json function of Postgres as given below and then assign partner as a JSON string value.
PreparedStatement stmt = this.connection.prepareStatement("INSERT INTO " + eventsTableName + " (aggregateId, revision, event, hasBeenPublished) values(?, ?, to_json(?::json) , ?)");
In the case of Hibernate you need to define entity as given below
@Type(type = "jsonb") @Column(name = "jsonData", columnDefinition = "jsonb") private String jsonData;