Org.postgresql.util.PSQLException: ERROR: value for character type is too long (255)

Question

I get it error

when executingmy projectand I don’t know why.

The goal is to text save Jsonin databasewith hibernate.

Users .java and UsersBooks.java also,

Books.java:

@Entity
@Table(name="tblbooks")
public class Books {


@Id
@Column(name = "bookshareId")
private int bookshareId;

@Column(name="author")
private String author;

@Column(name = "availableToDownload")
private int availableToDownload;

@Column(name = "briefSynopsis")
private String briefSynopsis;

@Column(name="category")
private String category;

@Column(name = "completeSynopsis")
private String completeSynopsis;

@Column(name = "contentId")
private int contentId;

@Column(name = "copyright")
private Date copyright;

@Column(name="downloadFormat")
private String downloadFormat;

@Column(name="dtbookSize")
private int dtbookSize;

@Column(name = "freelyAvailable")
private int freelyAvailable;

@Column(name = "brf")
private int brf;

@Column(name = "daisy")
private int daisy;

@Column(name = "images")
private int images;

@Column(name = "isbn13")
private String isbn13;

@Column(name="language")
private String language;

@Column(name = "publishDate")
private Date publishDate;

@Column(name = "publisher")
private String publisher;

@Column(name = "quality")
private String quality;

@Column(name = "title")
private String title;

@OneToMany(mappedBy="book")
private List<UsersBooks> usersBooks;



//Getters & Setters

Answer 1

You are trying to save a string value longer than 255 characters. Just increase the length of the column.

@Column(name = "xxx", length = 1024)

you also need to change the length of the column in the database.

When you use

@Column(name = "xxx")

Hibernate uses the default column length.

You can use @Lobfor really big text data.

, xxx_users tblusers.

User Users.

CascadeType.ALL @OneToMany .

@ManyToOne .

@ManyToOne(fetch = FetchType.Lazy)
pravate User user;

Answer 2

, , (255).

:

• TEXT VARCHAR(255).

Answer 3

255 :

@Column(length = 2048)
private String column;

:

@Lob
private String column;

:

@Column(columnDefinition="text")
private String column;