Bug #12641 Cannot convert TimeStamp to String (DATETIME field)

• Submitted: 18 Aug 2005 12:04
• Modified: 18 Aug 2005 12:07
• Reporter: [ name withheld ]
• Status: Duplicate
• Category: Connector / J
• Severity: S1 (Critical)
• Version: 3.1.10
• OS: Linux (Linux)
• CPU Architecture: Any

[18 Aug 2005 12:04] [ name withheld ]

Description:
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 8 to TIMESTAMP.
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 8 to TIMESTAMP.
	at com.mysql.jdbc.ResultSet.getTimestampFromString(ResultSet.java:5639)
	at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5060)
	at com.mysql.jdbc.ResultSet.getString(ResultSet.java:4926)
	at net.gamedot.icms.CLIthread.run(CLIthread.java:146)

My table description (mysql v4.0.24-linux)

CREATE TABLE `core` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `domain` smallint(5) unsigned NOT NULL default '0',
  `name` tinytext NOT NULL,
  `pcid` int(10) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  `chain` smallint(5) unsigned NOT NULL default '0',
  `regtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `online` datetime NOT NULL default '0000-00-00 00:00:00',
  `status` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `domain` (`domain`),
  KEY `uid` (`uid`),
  KEY `pcid` (`pcid`),
  KEY `status` (`status`)
) TYPE=MyISAM AUTO_INCREMENT=37 ;

How to repeat:
rs.getTimeStamp(8) or rs.getString(8)

[18 Aug 2005 12:07] [ name withheld ]

Dublicate of Bug #3331

[18 Aug 2005 12:22] Mark Matthews

This change has been listed in the manual and the changelog for quite some time (a year or more?):

http://dev.mysql.com/doc/mysql/en/cj-upgrading.html