Cannot convert value '0000-00-00 00:00:00' from column 37 to TIMESTAMP.

小雨转晴 2011-05-09 10:41:36
Connector/j : mysql-connector-java-5.1.7-bin.jar

java=>mysql URL:

jdbc:mysql://localhost:3306/test_db?useunicode=true&characterencoding=utf8&zerodatetimebehavior=converttonull

但是仍旧报
Cannot convert value '0000-00-00 00:00:00' from column 37 to TIMESTAMP.
错误,换了最新版本的jar还是不行,寻高手指点。谢谢
...全文
1000 15 打赏 收藏 转发到动态 举报
写回复
用AI写文章
15 条回复
切换为时间正序
请发表友善的回复…
发表回复
小雨转晴 2011-05-10
  • 打赏
  • 举报
回复
[Quote=引用 13 楼 wwwwa 的回复:]

sql_mode =' STRICT_TRANS_TABLES,STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER'
[/Quote]

我加过了,确实不起作用。
小雨转晴 2011-05-09
  • 打赏
  • 举报
回复
[Quote=引用 10 楼 wwwwb 的回复:]

你在MY。INI中设置一下sql_mode试试
[/Quote]
我在本地设置了一下(mysql.conf),但是貌似不起作用,不知道设置的对不对
# If you make changes to these settings and your system uses apparmor, you may
# also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#
sql_mode = STRICT_TRANS_TABLES,STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER
小雨转晴 2011-05-09
  • 打赏
  • 举报
回复
[Quote=引用 10 楼 wwwwb 的回复:]

你在MY。INI中设置一下sql_mode试试
[/Quote]

这个我没有权限啊,设置了是不是对所有用户都起作用了?
wwwwb 2011-05-09
  • 打赏
  • 举报
回复
你在MY。INI中设置一下sql_mode试试
小雨转晴 2011-05-09
  • 打赏
  • 举报
回复
[Quote=引用 8 楼 wwwwb 的回复:]

简单地说,去掉了NO_ZERO_DATE
[/Quote]

NO_ZERO_DATE

在严格模式,不要将 '0000-00-00'做为合法日期。你仍然可以用IGNORE选项插入零日期。在非严格模式,可以接受该日期,但会生成警告。

但是为什么我打成jar包,放到项目里又不管用了呢?好奇怪
wwwwb 2011-05-09
  • 打赏
  • 举报
回复
简单地说,去掉了NO_ZERO_DATE
小雨转晴 2011-05-09
  • 打赏
  • 举报
回复
额。。。打成jar包又不好用了 抓狂!!!~~!
小雨转晴 2011-05-09
  • 打赏
  • 举报
回复
sql_mode=’STRICT_TRANS_TABLES,STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER’;

谢谢wwwwb 加了这个好像可以了,能帮忙解释下关键是哪个mode起的作用吗?

作用是控制zerodatetimebehavior=converttonull这个起作用吗?谢谢
小雨转晴 2011-05-09
  • 打赏
  • 举报
回复
[Quote=引用 4 楼 wwwwb 的回复:]

show variables like ‘sql_mode’;贴结果
试试
sql_mode=’STRICT_TRANS_TABLES,STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER’;
[/Quote]
show variables like 'sql_mode';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| sql_mode | |
+---------------+-------+
1 row in set (0.38 sec)

是不是我没有权限?
wwwwb 2011-05-09
  • 打赏
  • 举报
回复
show variables like ‘sql_mode’;贴结果
试试
sql_mode=’STRICT_TRANS_TABLES,STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER’;
rucypli 2011-05-09
  • 打赏
  • 举报
回复
http://blog.163.com/forward-18er/blog/static/16475618120105910518471/


你可以修改你的jdbc连接

jdbc:mysql://localhost/schoolmis?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull

小雨转晴 2011-05-09
  • 打赏
  • 举报
回复
[Quote=引用 1 楼 wwwwb 的回复:]

mysql什么版本?代码是什么
[/Quote]

5.1.38-enterprise-gpl-log

代码就是利用ibatis查询,给javabean赋值。
wwwwb 2011-05-09
  • 打赏
  • 举报
回复
mysql什么版本?代码是什么
WWWWA 2011-05-09
  • 打赏
  • 举报
回复
or
在你的程序中
set sql_mode =' STRICT_TRANS_TABLES,STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER'
WWWWA 2011-05-09
  • 打赏
  • 举报
回复
sql_mode =' STRICT_TRANS_TABLES,STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER'
Delphi 7.1 Update Release Notes=======================================================This file contains important supplemental and late-breakinginformation that may not appear in the main productdocumentation, and supersedes information contained in otherdocuments, including previously installed release notes.Borland recommends that you read this file in its entirety.NOTE: If you are updating a localized version of Delphi 7, visit the Borland Registered User web site to obtain a localized readme file that may contain important late- breaking information not included in this readme file.IMPORTANT: Delphi must be closed before installing this update. =====================================================CONTENTS * INSTALLING THIS UPDATE * UPDATING LOCALIZED VERSIONS OF DELPHI 7 * KNOWN ISSUES * ISSUES ADDRESSED BY THIS UPDATE - IDE - CORE DATABASE - DATASNAP - DBGO (ADO COMPONENTS) - dbExpress - dbExpress COMPONENTS AND DB VCL - dbExpress CORE DRIVER AND METADATA - dbExpress VENDOR ISSUES - dbExpress CERTIFICATION - WEB SNAP - ACTIVEX - COMPILER - RTL - VCL - THIRD PARTY - BOLD FOR DELPHI * VERIFYING THAT THE UPDATE WAS SUCCESSFUL * FILES INSTALLED BY THIS UPDATE =======================================================INSTALLING THIS UPDATE* This update can not be applied to Delphi 7 Architect Trial version. * This update can not be removed after it is installed.* You will need the original Delphi 7 installation CD available to install this update.* To install this update from the CD, insert the CD, and launch the d7_ent_upd1.exe file appropriate for your locale.* To install this update from the Web, double-click the self-executing installation file and follow the prompts. * The Delphi 7 documentation PDF files are available on the update CD.========================================================UPDATING LOCALIZED VERSIONS OF DELPHI 7* This update can be applied only to the English version of Delphi 7. There are separate updates for the German, French and Japanese ver

56,675

社区成员

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧