[dba-issues] [Issue 108022] Failing to open Mysql tab les with NULL Datetime values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108022 User mechtilde changed the following: What|Old value |New value CC|'atjensen'|'atjensen,mechtilde' Status|UNCONFIRMED |RESOLVED Keywords| |oooqa Resolution| |INVALID Subcomponent|MySQL Connector/OOo |none --- Additional comments from mechti...@openoffice.org Thu Mar 18 14:02:38 + 2010 --- yes this is a problem of the JDBC you can try one of the other connectors (ODBC ot the native one) - invalid - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 108022] Failing to open Mysql tab les with NULL Datetime values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108022 User mechtilde changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from mechti...@openoffice.org Thu Mar 18 14:03:20 + 2010 --- - closed - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 108022] Failing to open Mysql tab les with NULL Datetime values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108022 Issue #|108022 Summary|Failing to open Mysql tables with NULL Datetime values | Component|Database access Version|OOO310m19 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|MySQL Connector/OOo Assigned to|dbaneedsconfirm Reported by|leongoogs --- Additional comments from leongo...@openoffice.org Fri Jan 1 13:23:55 + 2010 --- Mysql database version 4.1 , on an external machine . Connect via JDBC Sun Java Version 1.6.0.16 . Mysql-Connector-java 3.2.0 alpha . Datetime format of Field DD/MM/YY HH:MM some values in the table have no date time entered . You can look at the table in design view and Base recognizes that data in that field is not required . Error reported is that The data content could not be loaded , Cannot convert value '-00-00 00:00:00'from column 7 to TIMESTAMP . Other tables in the same database without null values in a datetime field open OK . The same database table can be connected to from Microsoft Access in Windows via ODBC and shows NULL values in the table OK. Mysqlcc under windows also works to the same table as does a mysql client under linux. Seems the datetime conversion code is working all the time even if the field is marked as not always being required. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 108022] Failing to open Mysql tab les with NULL Datetime values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108022 --- Additional comments from leongo...@openoffice.org Fri Jan 1 13:25:52 + 2010 --- Created an attachment (id=66932) Error message - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 108022] Failing to open Mysql tab les with NULL Datetime values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108022 --- Additional comments from leongo...@openoffice.org Fri Jan 1 13:29:57 + 2010 --- Created an attachment (id=66933) Field 7 for table in design view showing Format information - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 108022] Failing to open Mysql tab les with NULL Datetime values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108022 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' Summary|Failing to open Mysql tabl|Failing to open Mysql tabl |es with NULL Datetime valu|es with NULL Datetime valu |es|es --- Additional comments from atjen...@openoffice.org Fri Jan 1 18:08:10 + 2010 --- @leongoogs Please look at the configuration setting zeroDateTimeBehavior for the JDBC connector http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html (Shouldn't matter that this is the 5.0 manual, this 'date issue' has been around for a long time with MySQL) Please let us know if this corrects your problem, thanks. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org