[Eclipsesql-bugs] [ eclipsesql-Bugs-3024228 ] Can`t work with MySQL DATETIME columns

[SourceForge.net <no...@so...>]

Bugs item #3024228, was opened at 2010-07-02 11:16
Message generated for change (Comment added) made by hhilbert
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3024228&group_id=132863

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
>Status: Closed
>Resolution: Wont Fix
Priority: 6
Private: No
Submitted By: Roman V. Nikolaev (nikolaevroman)
Assigned to: Heiko Hilbert (hhilbert)
Summary: Can`t work with MySQL DATETIME columns

Initial Comment:
I try to simple select from table. Query break if in table has colum type of DATETIME.

----------------------------------------------------------------------

>Comment By: Heiko Hilbert (hhilbert)
Date: 2010-07-27 13:16

Message:
I can't catch this in SQL Explorer. Even if I try to read this value as
string ( getString() ) the same exception is thrown from the JDBC driver.
No chance.


----------------------------------------------------------------------

Comment By: Roman V. Nikolaev (nikolaevroman)
Date: 2010-07-12 09:45

Message:
=( It`s work, but it`s not right. When I use joins I have NULL values by
join logic. And I cant recognize real NULL from NULL by '0000-00...'
Maybe hotfix in SQL Explorer can correctly processing this situations?

----------------------------------------------------------------------

Comment By: PatL (patl9)
Date: 2010-07-07 20:02

Message:
It's a known mysql jdbc issue if memory serves. I always use a url like:
jdbc:mysql://192.168.0.0:3306/mythconverg?zeroDateTimeBehavior=convertToNull

----------------------------------------------------------------------

Comment By: Roman V. Nikolaev (nikolaevroman)
Date: 2010-07-07 10:42

Message:
Reproduce:

create table t1(x datetime);
insert into t1(x) values ('0000-00-00 00:00:00');
select * from t1; (Text: Cannot convert value '0000-00-00 00:00:00' from
column 1 to TIMESTAMP)


----------------------------------------------------------------------

Comment By: Heiko Hilbert (hhilbert)
Date: 2010-07-07 09:32

Message:
I tried this without any problems on my mysql database:

create table t1(x datetime);
insert into t1(x) values (now());
select * from t1; 
drop table t1;

Do you have any exceptions in the eclipse error log?


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3024228&group_id=132863