rst.getTimestamp（＆QUOT; upload_date＆QUOT;）不会在亚马逊RDS MySQL的 [英] rst.getTimestamp("upload_date") doesn't work in Amazon RDS MySQL

问题描述

我对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

这篇关于rst.getTimestamp（＆QUOT; upload_date＆QUOT;）不会在亚马逊RDS MySQL的的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！