search

brenoepics / morningstar

An open-source Arcturus Community Fork.
GNU General Public License v3.0
3 stars 2 forks source link

Error java.sql.SQLException: The server time zone value 'Paris, Madrid' #1030

Closed brenoepics closed 1 year ago

brenoepics commented 1 year ago

In GitLab by @Freefox on Nov 23, 2022, 12:14

## Build Information

Emulator Version: 3.5.1

What is the error?

As soon as the emulator starts, an error appears.
Here is the photo attached, it would be hard in a while with a JDBC server driver (via the 'serverTimezone' configuration property)

emu-error_3_5_1

brenoepics commented 1 year ago

In GitLab by @SenpaiDipper on Nov 24, 2022, 14:03

Not a bug, use these instead https://docs.oracle.com/middleware/1221/wcs/tag-ref/MISC/TimeZones.html

brenoepics commented 1 year ago

In GitLab by @Freefox on Nov 26, 2022, 06:58

Thank you for your answer @SenpaiDipper , But I can't find or change this configuration. I think it must be in the sources of the emulator but how to modify it...?

brenoepics commented 1 year ago

In GitLab by @duckietm on Nov 27, 2022, 10:19

In your case, update the : config.ini

db.params=?characterEncoding=utf8&useSSL=false&serverTimezone=Europe/Paris

or

db.params=?characterEncoding=utf8&useSSL=false&serverTimezone=Europe/Madrid

brenoepics commented 1 year ago

In GitLab by @Freefox on Dec 2, 2022, 14:17

It works correctly. Thanks to you. I close the ticket immediately.