我对AWS RDS MySQL数据库表,有一个名为列 upload_date 的类型是 TIMESTAMP 和默认是 CURRENT_TIMESTAMP
I have a MySQL database table on AWS RDS which has a column named upload_date whose TYPE is TIMESTAMP and DEFAULT is current_timestamp.
我在我的本地MySQL数据库做同样的事情。
I've done the same thing in my local MySQL db.
当我在我的本地数据库连接调用rst.getTimestamp(upload_date),它的伟大工程。 然而,当我尝试在我的AWS RDS的MySQL同样的事情,我得到这个例外
When I invoke the rst.getTimestamp("upload_date") in my local db connection, it works great. However when I try the same thing on my AWS RDS MySQL, I get this exception
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1033)
at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:576)
at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6466)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6066)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6104)
at org.udhc.gen.HealthRecord.getAllUploadedHealthRecords(HealthRecord.java:337)
at org.udhc.gen.HealthRecord.main(HealthRecord.java:858)
我在哪里去了?
Where am I going wrong?
感谢。
问题是:
我已经改变了表中添加这一新列 - 所以previously进入行有
I had ALTERed the table to add this new column - so the previously entered rows had
00-00-00 00:00(或类似的东西)
00-00-00 00:00 ( or something similar )
这是造成上述厚望。
FIX:
UPDATE FORUM SET UPLOAD_DATE = CURRENT_TIMESTAMP