ERROR: column "xxxxxxx" is of type character varying[] but expression is of type bytea

Question

I am getting Error in Spring and using db postgres

org.postgresql.util.PSQLException: ERROR: column "XXXXXXXXXX" is of type 
                                       character varying[] but expression is of type bytea
  Hint: You will need to rewrite or cast the expression.

My POJO have data_member like:

@Column(name = "xxxxxxx")
private String[] xxxxxxx;

Possible duplicate of [mapping a postgres array with hibernate](http://stackoverflow.com/questions/1647583/mapping-a-postgres-array-with-hibernate) — Jens Schauder, Sep 07 '16 at 05:59

score 1 · Answer 1 · edited Jan 24 '17 at 14:58

1

You can implement hibernate UserType interface, and then add @Type annotation to your attribute.

Example:

@Column(name = "xxxxxxx")
@Type(type = "xx.xxx.xxx.YourImplementationOfUserType")
private String[] xxxxxxx;

edited Jan 24 '17 at 14:58

pringi

3,987
5
35
45

answered Jan 24 '17 at 13:21

florbonansea

61
1
1

ERROR: column "xxxxxxx" is of type character varying[] but expression is of type bytea

1 Answers1