Data truncation on longblob field
Posted by: Leonardo Berti
Date: June 07, 2018 01:40AM

I get the error SQLError: 1406 Data truncation: Data to long for column 'fileBuffer' ... when i try to insert more than 255 bytes in a longblob column.
The column fileBuffer has longblob data type.
I am using the mysql connector for java ver. 5.1.46 and my mysql server is
Ver 14.14 Distrib 5.7.21, for osx10.13.
The table that has the problem has been created by hibernate
The creation statement is:

`id` int(11) NOT NULL,
`descrSize` varchar(255) DEFAULT NULL,
`errorRecords` int(11) NOT NULL,
`fileName` varchar(255) DEFAULT NULL,
`importedRecords` int(11) NOT NULL,
`loadedTs` tinyblob,
`totRecords` int(11) NOT NULL,
`ente_id` int(11) NOT NULL,
`utente_id` int(11) NOT NULL,
`fileBuffer` longblob,
KEY `FKsf2ufvp5e3p5vv3ax7krmlwd4` (`ente_id`),
KEY `FKf2p7052rcbaw2k309ma2xp2t8` (`utente_id`),
CONSTRAINT `FKf2p7052rcbaw2k309ma2xp2t8` FOREIGN KEY (`utente_id`) REFERENCES `Utente` (`id`),
CONSTRAINT `FKsf2ufvp5e3p5vv3ax7krmlwd4` FOREIGN KEY (`ente_id`) REFERENCES `Ente` (`id`)

This is the java code that inserts the blob:

FileData fd = new FileData(); //this is a Hibernate entity
fbuffer = new byte[256];
Blob blob = Hibernate.getLobCreator(jpaApi.em().unwrap(org.hibernate.Session.class)).createBlob(fbuffer);




when the transaction commit i get the error.
if filebuffer is less then 256 bytes it works without errors

thanks in advance

Options: ReplyQuote

Written By
Data truncation on longblob field
June 07, 2018 01:40AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.