Topic: No preview data available
No preview data available
Hi,
I just downloaded datacleaner and installed it with the MySQL connector. When I connect to our database and start the profiler, I can preview the data of some tables, but other ones don't show any data in the preview.
Those tables that don't show any preview data do in fact have data in them, as I checked by using MySQL Query Browser. Is this a bug or do I have to change some settings somewhere?
Thanks,
Diddy
I just downloaded datacleaner and installed it with the MySQL connector. When I connect to our database and start the profiler, I can preview the data of some tables, but other ones don't show any data in the preview.
Those tables that don't show any preview data do in fact have data in them, as I checked by using MySQL Query Browser. Is this a bug or do I have to change some settings somewhere?
Thanks,
Diddy
Hi Diddy,
Sounds weird. Can you run a profile on those tables that won't preview?
To help find out what the problem is, try running DataCleaner using either the .cmd (windows) or .sh (linux/mac) launchers. This will bring up a console where you can perhaps take a look for any error messages.
Sounds weird. Can you run a profile on those tables that won't preview?
To help find out what the problem is, try running DataCleaner using either the .cmd (windows) or .sh (linux/mac) launchers. This will bring up a console where you can perhaps take a look for any error messages.
Thanks for your reply. I get following error msg:
ERROR JdbcDataSetStrategy - java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP.
I guess this is down to JDBC. As I have no rights to change the table, is there a way that I can still use the datacleaner with this table?
ERROR JdbcDataSetStrategy - java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP.
I guess this is down to JDBC. As I have no rights to change the table, is there a way that I can still use the datacleaner with this table?
You can always choose not to profile that particular Timestamp-column (remove it from your data selection). But that might have importance to your profile task... Hmm.
Yes, true. But the main problem is, that I would like to use the preview as well. Normally, in Query Clients that depend on JDBC you can specify in the settings what should happen to 0 dates. Maybe this is something you could add as well?
Sounds like a viable solution. I'm a bit amazed that the MySQL driver throws a SQLException because of this though. There would be nothing wrong with just returning null, new Date(0) or something like that... I will create an issue for it right away. In the mean time, could you perhaps create an example dataset for us and attach it to the issue as an .sql script?
Here's the issue url:
http://eobjects.org/trac/ticket/380
http://eobjects.org/trac/ticket/380
Diddy, can you paste in a bit more of the error message. In particular I would be interested in a stack trace with line numbers for all dk.eobjects.* classes ...
Nevermind - I've recreated it myself :)
AND I've found a workaround. In you MySQL connection string, append this:
http://forums.mysql.com/read.php?39,43138,43195
?zeroDateTimeBehavior=convertToNullie. something like this:
jdbc:mysql://localhost/mydb?zeroDateTimeBehavior=convertToNullThe error is described here:
http://forums.mysql.com/read.php?39,43138,43195
Hi Kasper,
Sorry for not being able to respond earlier! Thanks a lot for your great support! I'll test this on Monday when I am back to work.
Thanks,
Diddy
Sorry for not being able to respond earlier! Thanks a lot for your great support! I'll test this on Monday when I am back to work.
Thanks,
Diddy
Hi Casper,
I tested this now and it is working excellently! Thanks a lot!
Best regards,
Diddy
I tested this now and it is working excellently! Thanks a lot!
Best regards,
Diddy
Log in by clicking the login link at the top of the screen
Go back to forum.
