數(shù)據(jù)庫問題
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value '?й???????' 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) ~[na:1.8.0_121]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_121]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_121]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_121]
2020-02-07
我能正常啟動，但是沒有生成表。大哥碰見過這個問題嗎
2020-02-07 09:42:09.125? INFO 9824 --- [? ? ? ? ? ?main] c.i.luckymoney.LuckymoneyApplication? ? ?: Starting LuckymoneyApplication on v_rslv-NB2 with PID 9824 (D:\softwore\Idea\Project\luckymoney\target\classes started by v_rslv in D:\softwore\Idea\Project\luckymoney)
2020-02-07 09:42:09.128? INFO 9824 --- [? ? ? ? ? ?main] c.i.luckymoney.LuckymoneyApplication? ? ?: The following profiles are active: dev
2020-02-07 09:42:09.946? INFO 9824 --- [? ? ? ? ? ?main] o.s.b.w.embedded.tomcat.TomcatWebServer? : Tomcat initialized with port(s): 8081 (http)
2020-02-07 09:42:09.960? INFO 9824 --- [? ? ? ? ? ?main] o.apache.catalina.core.StandardService? ?: Starting service [Tomcat]
2020-02-07 09:42:09.960? INFO 9824 --- [? ? ? ? ? ?main] org.apache.catalina.core.StandardEngine? : Starting Servlet engine: [Apache Tomcat/9.0.16]
2020-02-07 09:42:09.965? INFO 9824 --- [? ? ? ? ? ?main] o.a.catalina.core.AprLifecycleListener? ?: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [C:\Program Files\Java\jdk1.8.0_191\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files\Java\jdk1.8.0_191;C:\Program Files\NVIDIA GPU Computing Toolkit\CUDA\v10.0\bin;C:\Program Files\NVIDIA GPU Computing Toolkit\CUDA\v10.0\libnvvp;D:\softwore\Anaconda;D:\softwore\Anaconda\Library\mingw-w64\bin;D:\softwore\Anaconda\Library\usr\bin;D:\softwore\Anaconda\Library\bin;D:\softwore\Anaconda\Scripts;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;D:\softwore\MATLAB\runtime\win64;D:\softwore\MATLAB\bin;D:\softwore\Python36\Scripts;D:\softwore\Python36;D:\softwore\Node\;C:\Users\v_rslv\AppData\Roaming\npm\node_modules\npm;D:\softwore\Go\bin;D:\softwore\Git\Git\cmd;C:\Program Files\Java\jdk1.8.0_191\bin;C:\Program Files\Java\jre1.8.0_191\bin;C:\Program Files\MySQL\MySQL Server 5.7\bin;D:\softwore\Maven\apache-maven-3.6.3-bin\apache-maven-3.6.3\bin;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;D:\softwore\Python36\Scripts\;D:\softwore\Python36\;C:\Users\v_rslv\AppData\Local\Microsoft\WindowsApps;C:\Program Files\Java;C:\Users\v_rslv\AppData\Roaming\npm;D:\softwore\VScode\Microsoft VS Code\bin;C:\Users\v_rslv\go\bin;D:\softwore\SSH secure shell client;D:\softwore\Idea\IntelliJ IDEA 2019.3.2\bin;;.]
2020-02-07 09:42:10.097? INFO 9824 --- [? ? ? ? ? ?main] o.a.c.c.C.[.[localhost].[/luckymoney]? ? : Initializing Spring embedded WebApplicationContext
2020-02-07 09:42:10.097? INFO 9824 --- [? ? ? ? ? ?main] o.s.web.context.ContextLoader? ? ? ? ? ? : Root WebApplicationContext: initialization completed in 940 ms
2020-02-07 09:42:10.258? INFO 9824 --- [? ? ? ? ? ?main] o.s.s.concurrent.ThreadPoolTaskExecutor? : Initializing ExecutorService 'applicationTaskExecutor'
2020-02-07 09:42:10.403? INFO 9824 --- [? ? ? ? ? ?main] o.s.b.w.embedded.tomcat.TomcatWebServer? : Tomcat started on port(s): 8081 (http) with context path '/luckymoney'
2020-02-07 09:42:10.405? INFO 9824 --- [? ? ? ? ? ?main] c.i.luckymoney.LuckymoneyApplication? ? ?: Started LuckymoneyApplication in 1.587 seconds (JVM running for 2.372)
2020-02-05
該問題是MySql本身的時區(qū)設(shè)置的問題導(dǎo)致的,MySql安裝默認(rèn)設(shè)置為美國時區(qū)，而北京時間比美國遲8小時
2020-01-28
UTC是全球標(biāo)準(zhǔn)時間
保證MySQL和JAVA插入的時區(qū)一致應(yīng)該就行
2020-01-15
我也是這個問題，感謝
2019-11-22
serverTimezone=UTC？網(wǎng)上查找后確實有用，但是不明白為什么會出現(xiàn)這個問題