When I try to connect to a MySQL DB I get a java.lang.ClassCastException. In particular a MySQL DB listening on port 3301.
See attached for system info. Stack trace below. I can connect from MySQL Workbench. I have successfully connected to other MySQL DBs on port 3306. I encountered this on version 16.04, which is what I am licensed for, so I dl'd 18.5 and installed it to try to duplicate, and I did. So this 18.5 installation is brand new, this was the first connection I tried.
|
52 KB
|
36 KB
|
104 KB
|
31 KB
|
49 KB
|
92 KB
![]() |
27 KB
![]() |
305 KB
Hi Tom,
What version of MySQL are you using? Looks like you are using Ubuntu for an OS? Would you also attach the log files found in <USER_HOME>\.datastudio\logs.
Thanks, Tom
I'm attaching the version info shown in MySQL Workbench. Also uploading two log files. One from DataStudio 16 on Win 7, the other from DataStudio 18.5 on Ubuntu 16.04.
I'm attaching the version info shown in MySQL Workbench. Also uploading two log files. One from DataStudio 16 on Win 7, the other from DataStudio 18.5 on Ubuntu 16.04.
Hi Tom,
It looks like you are using version 8 of MySQL. Aqua Data Studio does not support that version yet. However, you can try downloading the latest MySQL jdbc driver 5.1.45 and installing it in \datastudio\lib\drivers directory.
Exit out of Aqua Data Studio first and remember to remove the current mysql.jar file. Store it in a safe place in case you need to add it back in. Re-start Aqua Data Studio.
Keep in mind, that we have not tested with the latest MySQL driver.
Hope that helps,
Tom
Hi Tom,
It looks like you are using version 8 of MySQL. Aqua Data Studio does not support that version yet. However, you can try downloading the latest MySQL jdbc driver 5.1.45 and installing it in \datastudio\lib\drivers directory.
Exit out of Aqua Data Studio first and remember to remove the current mysql.jar file. Store it in a safe place in case you need to add it back in. Re-start Aqua Data Studio.
Keep in mind, that we have not tested with the latest MySQL driver.
Hope that helps,
Tom
Thanks Tom. That actually worked!
I was wondering about it being version 8 when I sent you the screenshot the other day, as in whether that was the source of the problem, and why we had decided to use it. Normally we use 5.7 lately.
Regards,
Tom Spitzer
Thanks Tom. That actually worked!
I was wondering about it being version 8 when I sent you the screenshot the other day, as in whether that was the source of the problem, and why we had decided to use it. Normally we use 5.7 lately.
Regards,
Tom Spitzer
Thanks Tom. That actually worked!
I was wondering about it being version 8 when I sent you the screenshot the other day, as in whether that was the source of the problem, and why we had decided to use it. Normally we use 5.7 lately.
Regards,
Tom Spitzer
Thanks Tom. That actually worked!
I was wondering about it being version 8 when I sent you the screenshot the other day, as in whether that was the source of the problem, and why we had decided to use it. Normally we use 5.7 lately.
Regards,
Tom Spitzer
Hi Tom,
Good to hear. I will close this issue out.
Take care,
Tom
Hi Tom,
Good to hear. I will close this issue out.
Take care,
Tom
Issue #15497 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
Hi Tom,
What version of MySQL are you using? Looks like you are using Ubuntu for an OS? Would you also attach the log files found in <USER_HOME>\.datastudio\logs.
Thanks, Tom