Type mapping MySQL type text to Java Hibernate

Question

What is the correct mapping type from MySQL data type text to Java using Hibernate?

@Column(name = "STACKTRACE", length = Integer.MAX_VALUE)
public String getStacktrace() {
    return this.stacktrace;
}

Integer.MAX_VALUE? Really? For every stack trace? I'd recommend something more reasonable that's CLOB-sized. — duffymo, Jul 05 '10 at 13:33

score 71 · Accepted Answer · answered Jul 05 '10 at 13:46

71

Try this:

@Column(name = "STACKTRACE")
@Type(type="text")

answered Jul 05 '10 at 13:46

Maurice Perry

Dear Maurice, I tried the above but I am getting error. your help will be very appreciable. http://stackoverflow.com/questions/25094410/hibernate-abstractmethoderror-setcharacterstreamiljava-io-readerjv?noredirect=1#comment39048566_25094410 – Ashish Agarwal Aug 02 '14 at 12:50
Why not to use ``@Lob`` (although it should generate ``LONGTEXT``) type? – heroin Nov 22 '15 at 16:20
`@Type(type="text")` generates `longtext` column for me. How to generate `text` column from Hibernate mapping? – naXa stands with Ukraine Dec 26 '18 at 18:37

Miks · Answer 2 · 2011-07-01T12:07:47.780

20

I think this solves the problem

@Column(length = 65535,columnDefinition="Text")

edited Jul 01 '11 at 12:07

answered Jul 01 '11 at 11:59

Miks

score 8 · Answer 3 · answered Jul 05 '10 at 14:17

8

The reverse engineering Hibernate Tools, makes from MySql Type text:

@Column(name = "COLUMNNAME", length = 65535)

answered Jul 05 '10 at 14:17

Alex

Indeed. If you look at the `MySqlDialect`, you'll see that it uses the length to derive the type. – Pascal Thivent Jul 05 '10 at 17:09
I think thats the better solution if you use JPA. – mhmpl Jun 29 '13 at 09:12

score 1 · Answer 4 · edited Feb 23 '18 at 06:56

1

To fix this issue, I had to annotate like below:

@Column(name="LONG_DESCRIPTION" , length = 65535, columnDefinition="TEXT")
@Type(type="text")'

edited Feb 23 '18 at 06:56

Rakesh Burbure

answered Feb 23 '18 at 06:06

Garfield Heron

4 Answers4