I get an "error, string or binary data would be truncated" with Hibernate/JPA

Question

So I got an error, string or binary data would be truncated error from sql-server. I am using hibernate to persist data to MS sql-server.

Usually when you get an error like this it means that the column you're trying to save to is not big enough to hold the data you are trying to insert.

I carefully started to compare to see if one of my BigDecimal variables in the domain doesn't have the correct precision, but after spending a lot of time, I realized this was not the case.

Turns out, I was missing @ManyToOne(optional = false) in the child domain. My parent domain object has a one to many relationship with the child. Adding the annotation solved the issue for me. And I am Hoping this will help somebody seeing similar error.

The question is: Why is database giving a data truncation error when ManyToOne annotation is missing in the domain?

JB Nizet · Accepted Answer · 2014-08-21 16:29:23Z

3

Because since you haven't annotated your field, Hibernate applies the default mapping: treating the field as a serializable object that, once serialized, is stored in a binary column.

The length of the byte array resulting from the serialization was too large for the column, hence the error.

answered Aug 21, 2014 at 16:29

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

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

Comments

Ankur Singhal · Accepted Answer · 2014-08-21 17:27:53Z

3

If no annotation is provided, Hibernate will apply the default mapping and will create a column with datatype tinyblob.

This will be storing the serialize data of that entity.

TINYBLOB: maximum length of 255 bytes.

Once the Entity is serialized, and data length exceeds 255 bytes, it will throw the error

data truncation error

answered Aug 21, 2014 at 17:27

Ankur Singhal

26.1k17 gold badges92 silver badges129 bronze badges

2 Comments

pacman Over a year ago

Thank you ankur, but you wrote the same thing that JB wrote, so I'm choosing his answer over yours.

Ankur Singhal Over a year ago

@pacman yes no issues, i just wanted to define the exact colummn datatype and its size, just to be more precise.

Collectives™ on Stack Overflow

I get an "error, string or binary data would be truncated" with Hibernate/JPA

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related