Data truncation: Truncated incorrect DOUBLE value
Posted by: Macamba .
Date: April 23, 2017 08:23AM

Bit of a head scratcher. In my Java application I get the following error message:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value

Searching the Internet I find *) that instead of using AND you should use a comma.

Looking at my logging I see:
class nl.mycompany.tk.RecordsPanel - addNewRow, updating tkTimestamp timestamp ID: '0', perident: 'jdoe', project: 'Promotie jaar 1', activity: '01 Zoeken', timestamp: '2017-04-23 15:43:12.972 in timestamp record
class nl.mycompany.tk.dao.TimestampImplementation - update, SQL query is 'UPDATE tktimestamp SET project=?, activity=?,  timest=? WHERE perident = ?'
class nl.mycompany.tk.dao.TimestampImplementation - update, tTs=timestamp ID: '0', perident: 'jdoe', project: 'Promotie jaar 1', activity: '01 Zoeken', timestamp: '2017-04-23 15:43:12.972
class nl.mycompany.tk.dao.DAOException - DAOException com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'jdoe'

And as far as I see, the used SQL query is correct.
SQL query is 'UPDATE tktimestamp SET project=?, activity=?,  timest=? WHERE perident = ?'

What can I do to solve my problem?

*) Link: https://www.bennadel.com/blog/1503-data-truncation-truncated-incorrect-double-value-when-updating-timestamp.htm]answers

Options: ReplyQuote


Subject
Written By
Posted
Data truncation: Truncated incorrect DOUBLE value
April 23, 2017 08:23AM


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.