com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'column_name'

java mysql truncation
thilo picture thilo · Nov 26, 2012 · Viewed 81.6k times · Source

I am using Java JDBC with MySQL and I get this error:

com.mysql.jdbc.MysqlDataTruncation: Data truncation: 
Data too long for column 'column_name'

How do I remedy this error?

Answer

Vijay Gajera picture Vijay Gajera · Jun 4, 2017

I faced same issue in my spring boot data jpa application when i going to insert image file in data base as byte its given me same error.

After many R & D i found solution like below.

I added below line in my application.properties file and resolve that

spring.datasource.url=jdbc:mysql://localhost:3306/conweb?sessionVariables=sql_mode='NO_ENGINE_SUBSTITUTION'&jdbcCompliantTruncation=false

Hope it will helpful to someone.

Related questions

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: ',3'

I'm trying to write a shop plugin for my Minecraft server, but I keep getting an error whenever anyone does the /purchase command. Here's the error: 2012-07-03 04:27:28 [SEVERE] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: ',3…

Read More
Solving a "communications link failure" with JDBC and MySQL

I'm trying to connect to the local MySQL server but I keep getting an error. Here is the code. public class Connect { public static void main(String[] args) { Connection conn = null; try { String userName = "myUsername"; String password = "myPassword"; String url = "…

Read More
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

I'm working on getting my database to talk to my Java programs. Can someone give me a quick and dirty sample program using the JDBC? I'm getting a rather stupendous error: Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.…

Read More