Hallo zusammen,
beim Versuch einer Datenbankverbindung zu einem MySQL-Server über den ModulDesigner erhalte ich folgende Fehlermeldung.
Was muss ich hier anpassen? Liegt das Problem auf Seiten der STARFACE oder muss ich hier am MySQL-Server etwas ändern?
Verstehe ich die Fehlermeldung richtig, dass die STARFACE irgendwo was nicht mit der Zeitzone anfangen kann?
Liebe Grüße
Malte
Code
[2019-07-18 10:31:39,144] ERROR [main]
Root cause:
java.sql.SQLException: The server time zone value 'Mitteleurop�ische Sommerzeit' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:545)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:505)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:479)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:489)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:69)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1606)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:633)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:347)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:219)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at de.vertico.starface.module.core.runtime.functions.db.GetConnection.createMySQLConnection(GetConnection.java:119)
at de.vertico.starface.module.core.runtime.functions.db.GetConnection.execute(GetConnection.java:78)
at de.vertico.starface.module.core.runtime.executables.JavaFunctionExec.executeImpl(JavaFunctionExec.java:146)
at de.vertico.starface.module.core.runtime.executables.BaseExec.execute(BaseExec.java:116)
at de.vertico.starface.module.core.runtime.LoadedModule.invokeFunction(LoadedModule.java:213)
at de.vertico.starface.module.core.runtime.LoadedFunction.invoke(LoadedFunction.java:74)
at de.vertico.starface.module.core.runtime.RuntimeEnvironmentImpl.invokeFunction(RuntimeEnvironmentImpl.java:233)
at de.vertico.starface.module.core.runtime.executables.FunctionCallExec.executeImpl(FunctionCallExec.java:128)
at de.vertico.starface.module.core.runtime.executables.BaseExec.execute(BaseExec.java:116)
at de.vertico.starface.module.core.runtime.executables.ContainerExec.executeImpl(ContainerExec.java:82)
at de.vertico.starface.module.core.runtime.executables.IfExecutable.executeImpl(IfExecutable.java:90)
at de.vertico.starface.module.core.runtime.executables.BaseExec.execute(BaseExec.java:116)
at de.vertico.starface.module.core.runtime.executables.ContainerExec.executeImpl(ContainerExec.java:82)
at de.vertico.starface.module.core.runtime.executables.ElseExec.executeImpl(ElseExec.java:40)
at de.vertico.starface.module.core.runtime.executables.BaseExec.execute(BaseExec.java:116)
at de.vertico.starface.module.core.runtime.executables.ContainerExec.executeImpl(ContainerExec.java:82)
at de.vertico.starface.module.core.runtime.executables.FunctionExec.executeImpl(FunctionExec.java:57)
at de.vertico.starface.module.core.runtime.executables.BaseExec.execute(BaseExec.java:116)
at de.vertico.starface.module.core.runtime.ModuleRuntime.callEntryPoint(ModuleRuntime.java:336)
at de.vertico.starface.module.core.runtime.ModuleRuntime.callEntryPoint(ModuleRuntime.java:507)
at de.vertico.starface.module.core.runtime.ModuleRuntime.callLifeCycleEntryPointsForInstance(ModuleRuntime.java:2070)
at de.vertico.starface.module.core.runtime.ModuleRuntime.access$000(ModuleRuntime.java:121)
at de.vertico.starface.module.core.runtime.ModuleRuntime$1.run(ModuleRuntime.java:2044)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.cj.core.exceptions.InvalidConnectionAttributeException: The server time zone value 'Mitteleurop�ische Sommerzeit' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)
at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
at com.mysql.cj.jdbc.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:118)
at com.mysql.cj.mysqla.MysqlaSession.configureTimezone(MysqlaSession.java:293)
at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:2399)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1739)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1596)
... 29 more
Alles anzeigen