java.sql.SQLException: Data truncated for column date at row 1

Database / Java Frameworks / Mobile / Salesforce / Web Development / Zoho
|
Post Views: 8,076
| By Webner

You may face this exception while trying to insert data in a mysql table using hibernate:

java.sql.SQLException: Data truncated for column date at row 1

While there can be different reasons of this problem, in our case it was occurring because by mistake we were trying to insert a date value in an integer field while trying to insert the record with JPA entity.

Webner Solutions is a Software Development company focused on developing CRM apps (Salesforce, Zoho), LMS Apps (Moodle/Totara), Websites and Mobile apps. If you need Web development or any other software development assistance please contact us at webdevelopment@webners.com

Related posts:

  1. PHP | Convert date from one format to another in php
  2. Couple of approaches to generate test-data in bulk
  3. Mysql | Forgot root password in Mysql
  4. Moodle and Java | Retrieving users’ data from Moodle using External Java Application

Leave a Reply

Your email address will not be published. Required fields are marked *