JPA and PostqreSQL: long string persistence

Question

Can anybody tell me how to persist long text using JPA (I use PostgreSQL)?

Here's the way I defined a very long string in my class:

@Lob
private String  body;

However, this produces a field of type charactervarying(255) in the database.

Furthermore, I've tried to use @Column annotation:

@Column(columnDefinition="TEXT")
private String  body;

But everything in vain.

I would be gratefull for a helpfull comment on this problem.

I was doing the first thing, and I got an OID, LO in postgresql, true nightmare — jacktrades, Mar 07 '13 at 12:10

score 20 · Answer 1 · answered Dec 09 '09 at 01:34

20

@Column(columnDefinition="TEXT")

is indeed the way to do it. Perhaps you have to regenerate your DDL?

answered Dec 09 '09 at 01:34

Jonathan Feinberg

44,698
7
80
103

Unfortunately, it seems that @Column annotation is completely ignored. – emanemos Dec 09 '09 at 10:40
Dear Jonathan, I tired the above suggested fix but I am getting error. Your help will be apreciable. Please help. http://stackoverflow.com/questions/25094410/hibernate-abstractmethoderror-setcharacterstreamiljava-io-readerjv?noredirect=1#comment39048566_25094410 – Ashish Agarwal Aug 02 '14 at 12:52

score 17 · Answer 2 · answered Jun 14 '12 at 08:21

17

I had the same case today. Just

@Lob
private String  body;

should create a db column of typ "text" (PostgreSQL - variable unlimited length) but the table should be regenerated.

answered Jun 14 '12 at 08:21

ezgi

376
2
3

This one should be the correct approach, the other solutions are giving me: ERROR: syntax error at or near "`" – Giovanni Toraldo Apr 05 '13 at 13:54
for a database independent solution, this must be the correct choice – Lucas Jun 28 '19 at 15:35

score 12 · Answer 3 · answered Jan 22 '12 at 03:18

12

This is a very old post, but since it has lots of views, and I had a similar question even today, I guess it's worth a simple answer.

My solution was similar, but I found that I needed the LONGTEXT column instead:

@Column(columnDefinition="LONGTEXT")
private String body;

And yes, you do have to regenerate it. I'm using Play! and I had to restart my app.

answered Jan 22 '12 at 03:18

Indigenuity

9,332
6
39
68

3

What was your intention to use LONGTEXT instead of TEXT? The reason is missing. – 0xPixelfrost Mar 04 '12 at 00:30

score 1 · Answer 4 · answered Sep 07 '18 at 02:19

1

JPA, Postgresql You can use:

@Column(length = 2000)
    private String template;

it generates:

template character varying(2000)

answered Sep 07 '18 at 02:19

Cassio Lemos

61
5

score 0 · Answer 5 · answered Apr 27 '14 at 22:33

0

You can also use the validation annotations:

@Size(max=xxx)

That would also serve as a validation constraint of course.

answered Apr 27 '14 at 22:33

prefabSOFT

1,143
1
12
23

score 0 · Answer 6 · answered Jan 20 '21 at 07:54

0

I dont know why, but I added @Column(length = 1024)

on top of the getter and it works.

answered Jan 20 '21 at 07:54

MHK

63
1
8

JPA and PostqreSQL: long string persistence

6 Answers6

Linked