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
– duffymo, Commented Jul 5, 2010 at 13:33

Maurice Perry · Accepted Answer · 2010-07-05 13:46:58Z

72

Try this:

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

answered Jul 5, 2010 at 13:46

Maurice Perry

32.8k9 gold badges72 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ashish Agarwal Over a year ago

Dear Maurice, I tried the above but I am getting error. your help will be very appreciable. stackoverflow.com/questions/25094410/…

heroin Over a year ago

Why not to use @Lob (although it should generate LONGTEXT) type?

naXa stands with Ukraine Over a year ago

@Type(type="text") generates longtext column for me. How to generate text column from Hibernate mapping?

Miks · Accepted Answer · 2011-07-01 12:07:47Z

20

I think this solves the problem

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

edited Jul 1, 2011 at 12:07

answered Jul 1, 2011 at 11:59

Miks

2012 silver badges3 bronze badges

Comments

Alex · Accepted Answer · 2010-07-05 14:17:42Z

8

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

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

answered Jul 5, 2010 at 14:17

Alex

4,0839 gold badges40 silver badges54 bronze badges

2 Comments

Pascal Thivent Over a year ago

Indeed. If you look at the MySqlDialect, you'll see that it uses the length to derive the type.

mhmpl Over a year ago

I think thats the better solution if you use JPA.

Rakesh Burbure · Accepted Answer · 2018-02-23 06:56:49Z

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, 2018 at 6:56

Rakesh Burbure

1,04512 silver badges27 bronze badges

answered Feb 23, 2018 at 6:06

Garfield Heron

313 bronze badges

Collectives™ on Stack Overflow

Type mapping MySQL type text to Java Hibernate

4 Answers 4

3 Comments

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related