Data Truncation of CURRENT_TIMESTAMP
Posted by: Kevin Lloyd
Date: March 10, 2005 10:02AM

I'm having a 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). When they do, I get the (new) data truncation warning/exception.

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
Data Truncation of CURRENT_TIMESTAMP
March 10, 2005 10:02AM


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.