1 person found this helpful
There are a couple of suggestions you can try, mentioned here:
. Tinker with the serverTimeZone setting, setting it to "+00:00"
. Setup an Advanced connection, and use a URL like this, for example:
substituting localhost:3306/<databasename> with your specific database connectivity...
@Gaz in Oz:
Thank you for the hint.
BUT: Where exactly do I have to add the new part of the connection string?
An "Advanced" connection type as you suggested is only possible for Oracle DBs and NOT for MySQL DBs
Can I switch an existing Basic (MySQL) connection later into an advanced (MySQL) connection or do I have to setup it again from scratch?
You can use the advanced connection type for a MySQL connection string
There is NO Advanced connection type for MySQL (only for Oracle).
So again: How do I create an "advanced" connection otherwise?
You use the Oracle advanced connection type and put in a MySQL jdbc url
Please post an example of the Oracle Advanced connection with a jdbc:mysql URL, working. I have tried with no success in getting that method to work.
For example in SQL Developer 220.127.116.117.2354 Connections -> Oracle -> Advanced both these formats fail:
When pressing the Test button.