Data Truncation of CURRENT_TIMESTAMP
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
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.