I am trying to execute insert statement through hibernate hibernate.save(entity) to table.It gives error:
SQL Error: 8152, SQLState: 22001
String or binary data would be truncated.
When I try to execute query on sql editor it works fine but through hibernate.save(entity)its gives me above error.Can AnyOne please help me out whats the issue is?
Usually that issue is related to columns' type and length, check the length is big enough or the data type is compatible. That could be a binary string overflow when being populated to int (int32), etc.
Tables of that server instance, find which table that you are trying to insert. You cannot work with table entity without checking the underlying tablesEntity, I suggest add breakpoint to where the insert fails, try to insert that record manually to table by using Insert statement to see what exactly happened.
I already had this problem when using the wrong sql dialect. By example, i was using a mysql dialect with the sql server driver.
Bye
Finally Issue Resolved , Actually in my entity their is property :
@Column ( name = "myArray" )
private byte[] myArray;
so the table creation in SQL with type and size varBinary(255) which is short container.To fix it through hibernate Entity i added :
@Lob
@Column ( name = "myArray" )
private byte[] myArray;
thanks to :What is the significance of @javax.persistence.Lob annotation in JPA?
