Re: what cause mysqlDataTruncation
Posted by: Kevin Lloyd
Date: March 10, 2005 07:33AM

I'm having a similar problem with 'data truncation' and timestamp fields.

The fields in question have a default value of CURRENT_TIMESTAMP. It appears the drivers are attempting to insert this value into the database when I use the ResultSet.insertRow() method (and the field isn't actually updated).

I've managed to replicate the issue by calling updateString("CURRENT_TIMESTAMP") on the field.

Am I missing some driver or database option here?

Kevin Lloyd

MySQL 4.1.10
MySQL-AB JDBC Driver mysql-connector-java-3.1.7

Options: ReplyQuote


Subject
Written By
Posted
February 18, 2005 01:19AM
Re: what cause mysqlDataTruncation
March 10, 2005 07:33AM


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.