Posts
Q&A
๊ฒฉ์ํ์ด 5*5์์ ๊ผญ 5๊ฐ๋ฅผ ๋ํด์ผ ๋ต์ด ๋๋๊ฑด๊ฐ์?
์ 2์๊ฐ ๋ ธ๊ฐ๋ค ๋์ ๊ฐ์ฅ ๊ธด ๋๊ฐ์ ํฉ ๋ง๊ณ ๋ ๋ค๋ฅธ ๋๊ฐ์ ๋ค ์ฐํํฅ ์ฐ์ํฅ ํฉ๋ ๊ณ ๋ คํด์ ํ์์ต๋๋ค. ๊ฐ์ฌํฉ๋๋ค.
- 0
- 1
- 304
Q&A
์๋ ํ์ธ์ ์ง๋ฌธ์ ๋๋ค.
์์ ์ ๋๋ก ๋ฃ์๊ฑฐ ๊ฐ์๋ฐ๋ ์ ์๋๋ค์. (์ฌ์ง ์ฒ๋ผ ํด๋์ ๊ทธ๋๋ก ๋ฃ์์ต๋๋ค)์ํฌํธ๋ฅผ ๊ทธ๋๋ก ํด๋ด๋ ์ ์๋๊ณ ํ์๊ฐ ์ ๋ ๊ฒ java resource๋ ์๋์ค๋๋ฐ ๋ญ๊ฐ ๋ฌธ์ ์ผ๊น์ ใ .. (์ฌ์ง) ๊ทธ๋ฆฌ๊ณ web.xml์ด ์์ ์์ค์ ์๋๋ฐ ๊ณ์ ์๊ธฐ๋ค์. ํน์ ์์ด๋ ๋๋๊ฑด๊ฐ์? ์๋ฌ๋ถ๋ถ ๋ฌ๋ค๊ณ ๊ณ์ ๋ ์ ์ฌ์ญค๋ด ๋๋ค.
- 0
- 2
- 230
Q&A
๋น๋ ์ง๋ฌธ์ ๋๋ค.
(์ฌ์ง) ํน์ ์ด๋ฌ๋ฉด ์ฑ๊ณต์ธ๊ฑด๊ฐ์.? ์๋์ฐ ๊ธฐ๋ฐ ๋ ธํธ๋ถ์์๋ ์ ๋๋๋ฐ ๋๊ฐ์ด ์กฐ๊ฑด์ ๊ฐ์ ์๋์ฐ ๊ธฐ๋ฐ ๋ฐ์คํฌํ์์ ํ๋๊น successful์ด๋ ์ ๋ ๊ฒ ๋์ค๋ค์. build.gradle์ ๋ฌธ์ ๊ฐ ์๋๊ฑด๊ฐ์?
- 0
- 3
- 1.1K
Q&A
๋น๋ ์ง๋ฌธ์ ๋๋ค.
plugins { id 'org.springframework.boot' version '2.5.0' id 'io.spring.dependency-management' version '1.0.11.RELEASE' id 'java'}group = 'hello'version = '0.0.1-SNAPSHOT'sourceCompatibility = '11'repositories { mavenCentral()}dependencies { implementation 'org.springframework.boot:spring-boot-starter-thymeleaf' implementation 'org.springframework.boot:spring-boot-starter-web' developmentOnly 'org.springframework.boot:spring-boot-devtools' testImplementation 'org.springframework.boot:spring-boot-starter-test'}test { useJUnitPlatform()}์ ๋๋ค. ๋ง๋ค๋ ์ธํ ๋ฆฌ์ ์ด ํ๋ก์์ ๋ง๋ค๊ณ ๊ฐ์ ๋ฐ๋ผํ์ต๋๋ค.
- 0
- 3
- 1.1K
Q&A
๋๋น ์ฐ๊ฒฐ ์ง๋ฌธ์ ๋๋ค.
์ mysql ์ปค๋ฅํฐ 8 ๋ฃ์ผ๋๊น ๋๋ค์.
- 0
- 1
- 196
Q&A
์๋ ํ์ธ์ ์ค๋ฅ ์ง๋ฌธ์ ๋๋ค.
(์ฌ์ง) ์ฒ์๋ถํฐ ๊ฐ์ ๋ค์ผ๋ฉด์ ๋ค์ ๋ค ๋ง๋ค๊ณ ๋๋น๋ 8.0๋ฒ์ ์์ ์ผ๋ถ๋ฌ ๊ฐ์ ๋ง์ถ๋ ค๊ณ 5.1๋ฒ์ ๋ ๋ค์ ํ๊ณ ๋ค ํ๋๋ฐ ์ฝ์ง ์ด์ฌํ ํ๋๋ฐ ๊ฐ์ ๋ฐ์ ์์ค์ฝ๋๋ ์ํฌํธ ํ๋ ๋ฒ ๊ฐ์๊ฐ ์๋๋ผ๊ตฌ์.. ๊ทธ๋์ ์ผ๋จ ๊ฐ์ ์ฐ๋ ์๋ฃ ์ ๋ถ๋ค ๋ณต์ฌ ๋ถ์ฌ๋ฃ๊ธฐํด์ ์จ๋ดค๋๋ฐ๋ ์ ๋ถ๋ถ์ ์คํํ๋ฉด ์ฌ์ง๊ณผ ๊ฐ์ ์๋ฌ๊ฐ ๋จ๋ค์.. ์ด๋ฒ์ ์๋ฌ ๋ฌธ๊ตฌ๊น์ง ์ ๋จ๋๋ฐ ๊ฐ์์์ insert success๊ฐ ๋จ๋๋ฐ ์ ๊ฒฝ์ฐ์๋ ์ ๋จ๋ค์.. ๊ทธ๋ฆฌ๊ณ form action="/MVC01/memberInsert.do" ์์ MVC01๋ถ๋ถ์ ๊ผญ ์จ์ค์ผ ๋์ํ๋์?
- 0
- 4
- 4.7K
Q&A
์๋ ํ์ธ์ ์ค๋ฅ ์ง๋ฌธ์ ๋๋ค.
์ด๋ป๊ฒ memberInsertdo ๋ฌธ์ ๋ ํด๊ฒฐ ํ๋๋ฐ ์ด๋ฒ์ ์๋ฌ๋ถ๋ถ์๋ ํ๊ธ์ด ๊บ ์ ธ์ ๋์ค๋ค์.. 20๋ฒ ๊ฐ์๊น์ง๋ ์ด๋ป๊ฒ ์ ํด๊ฒฐํ๋๋ฐ ์ผ๋จ ์๋ฌ๋ก๊ทธ๋ ์ฌ๋ ค๋ด ๋๋ค. (์ฌ์ง) 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.startup.VersionLoggerListener log ์ ๋ณด: ์๋ฒ ๋ฒ์ ์ด๋ฆ: Apache Tomcat/8.5.50 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.startup.VersionLoggerListener log ์ ๋ณด: Server ๋น๋ ์๊ฐ: Dec 7 2019 19:19:46 UTC 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.startup.VersionLoggerListener log ์ ๋ณด: Server ๋ฒ์ ๋ฒํธ: 8.5.50.0 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.startup.VersionLoggerListener log ์ ๋ณด: ์ด์์ฒด์ ์ด๋ฆ: Windows 10 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.startup.VersionLoggerListener log ์ ๋ณด: ์ด์์ฒด์ ๋ฒ์ : 10.0 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.startup.VersionLoggerListener log ์ ๋ณด: ์ํคํ ์ฒ: amd64 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.startup.VersionLoggerListener log ์ ๋ณด: ์๋ฐ ํ: C:\Program Files\Java\jdk1.8.0_201\jre 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.startup.VersionLoggerListener log ์ ๋ณด: JVM ๋ฒ์ : 1.8.0_201-b09 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.startup.VersionLoggerListener log ์ ๋ณด: JVM ๋ฒค๋: Oracle Corporation 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.startup.VersionLoggerListener log ์ ๋ณด: CATALINA_BASE: C:\eGovFrame-3.10.0\workspace.edu\.metadata\.plugins\org.eclipse.wst.server.core\tmp0 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.startup.VersionLoggerListener log ์ ๋ณด: CATALINA_HOME: C:\eGovFrame-3.10.0\bin\apache-tomcat-8.5.50 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.startup.VersionLoggerListener log ์ ๋ณด: ๋ช ๋ น ํ ์๊ท๋จผํธ: -Dcatalina.base=C:\eGovFrame-3.10.0\workspace.edu\.metadata\.plugins\org.eclipse.wst.server.core\tmp0 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.startup.VersionLoggerListener log ์ ๋ณด: ๋ช ๋ น ํ ์๊ท๋จผํธ: -Dcatalina.home=C:\eGovFrame-3.10.0\bin\apache-tomcat-8.5.50 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.startup.VersionLoggerListener log ์ ๋ณด: ๋ช ๋ น ํ ์๊ท๋จผํธ: -Dwtp.deploy=C:\eGovFrame-3.10.0\workspace.edu\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.startup.VersionLoggerListener log ์ ๋ณด: ๋ช ๋ น ํ ์๊ท๋จผํธ: -Djava.endorsed.dirs=C:\eGovFrame-3.10.0\bin\apache-tomcat-8.5.50\endorsed 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.startup.VersionLoggerListener log ์ ๋ณด: ๋ช ๋ น ํ ์๊ท๋จผํธ: -Dfile.encoding=UTF-8 4์ 01, 2021 5:15:06 ์ค์ org.apache.catalina.core.AprLifecycleListener lifecycleEvent ์ ๋ณด: ํ๋ก๋์ ํ๊ฒฝ๋ค์์ ์ต์ ์ ์ฑ๋ฅ์ ์ ๊ณตํ๋, APR ๊ธฐ๋ฐ Apache Tomcat Native ๋ผ์ด๋ธ๋ฌ๋ฆฌ๊ฐ, ๋ค์ java.library.path์์ ๋ฐ๊ฒฌ๋์ง ์์ต๋๋ค: [C:\Program Files\Java\jdk1.8.0_201\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Zulu\zulu-8\\bin;C:\Program Files\Zulu\zulu-8\bin\;C:\Program Files\Java\jdk1.8.0_201\bin;C:\Program Files\Amazon Corretto\jdk11.0.7_10\bin;C:\Program Files (x86)\NAT Service;C:\app\cyh12\product\11.2.0\dbhome_1\bin;D:\app\cyh12\product\11.2.0\dbhome_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files\Git\cmd;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program Files\MySQL\MySQL Server 8.0\bin;C:\Program Files\SourceGear\Common\DiffMerge\;D:\github\vcpkg;C:\Gradle\gradle-6.6.1\bin;C:\Program Files\mingw-w64\x86_64-8.1.0-posix-seh-rt_v6-rev0\mingw64\bin;C:\Program Files (x86)\Vim\vim82;C:\MinGW\bin;C:\Program Files\LLVM\bin;C:\Users\cyh12\anaconda3;C:\ProgramData\chocolatey\bin;C:\nodejs\;C:\Program Files\dotnet\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\MySQL\MySQL Server 8.0\bin;C:\Ruby27-x64\bin;C:\Python39\Scripts\;C:\Python39\;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;C:\Users\cyh12\AppData\Local\Microsoft\WindowsApps;C:\Program Files\Bandizip\;C:\Program Files\JetBrains\IntelliJ IDEA 2020.3.2\bin;C:\flutter\bin;C:\Program Files\mingw-w64\x86_64-8.1.0-posix-seh-rt_v6-rev0\mingw64\bin;C:\Program Files\JetBrains\PyCharm Community Edition 2020.2.2\bin;C:\venvs;C:\Users\cyh12\AppData\Local\Programs\Microsoft VS Code\bin;C:\Users\cyh12\AppData\Roaming\npm;C:\Users\cyh12\.dotnet\tools;C:\Users\cyh12\AppData\Local\atom\bin;C:\Program Files\JetBrains\IntelliJ IDEA 2020.3.3\bin;;C:\Program Files\JetBrains\PyCharm 2020.3.5\bin;;C:\Program Files (x86)\ESTsoft\ALSee\x64;.] 4์ 01, 2021 5:15:06 ์ค์ org.apache.coyote.AbstractProtocol init ์ ๋ณด: ํ๋กํ ์ฝ ํธ๋ค๋ฌ ["http-nio-8080"]์(๋ฅผ) ์ด๊ธฐํํฉ๋๋ค. 4์ 01, 2021 5:15:08 ์ค์ org.apache.tomcat.util.net.NioSelectorPool getSharedSelector ์ ๋ณด: Using a shared selector for servlet write/read 4์ 01, 2021 5:15:08 ์ค์ org.apache.coyote.AbstractProtocol init ์ ๋ณด: ํ๋กํ ์ฝ ํธ๋ค๋ฌ ["ajp-nio-8009"]์(๋ฅผ) ์ด๊ธฐํํฉ๋๋ค. 4์ 01, 2021 5:15:08 ์ค์ org.apache.tomcat.util.net.NioSelectorPool getSharedSelector ์ ๋ณด: Using a shared selector for servlet write/read 4์ 01, 2021 5:15:08 ์ค์ org.apache.catalina.startup.Catalina load ์ ๋ณด: Initialization processed in 1832 ms 4์ 01, 2021 5:15:08 ์ค์ org.apache.catalina.core.StandardService startInternal ์ ๋ณด: ์๋น์ค [Catalina]์(๋ฅผ) ์์ํฉ๋๋ค. 4์ 01, 2021 5:15:08 ์ค์ org.apache.catalina.core.StandardEngine startInternal ์ ๋ณด: Starting Servlet Engine: Apache Tomcat/8.5.50 4์ 01, 2021 5:15:08 ์ค์ org.apache.jasper.servlet.TldScanner scanJars ์ ๋ณด: ์ ์ด๋ ํ๋์ JAR๊ฐ TLD๋ค์ ์ฐพ๊ธฐ ์ํด ์ค์บ๋์์ผ๋ ์๋ฌด ๊ฒ๋ ์ฐพ์ง ๋ชปํ์ต๋๋ค. ์ค์บํ์ผ๋ TLD๊ฐ ์๋ JAR๋ค์ ์ ์ฒด ๋ชฉ๋ก์ ๋ณด์๋ ค๋ฉด, ๋ก๊ทธ ๋ ๋ฒจ์ ๋๋ฒ๊ทธ ๋ ๋ฒจ๋ก ์ค์ ํ์ญ์์ค. ์ค์บ ๊ณผ์ ์์ ๋ถํ์ํ JAR๋ค์ ๊ฑด๋๋ฐ๋ฉด, ์์คํ ์์ ์๊ฐ๊ณผ JSP ์ปดํ์ผ ์๊ฐ์ ๋จ์ถ์ํฌ ์ ์์ต๋๋ค. 4์ 01, 2021 5:15:08 ์ค์ org.apache.coyote.AbstractProtocol start ์ ๋ณด: ํ๋กํ ์ฝ ํธ๋ค๋ฌ ["http-nio-8080"]์(๋ฅผ) ์์ํฉ๋๋ค. 4์ 01, 2021 5:15:08 ์ค์ org.apache.coyote.AbstractProtocol start ์ ๋ณด: ํ๋กํ ์ฝ ํธ๋ค๋ฌ ["ajp-nio-8009"]์(๋ฅผ) ์์ํฉ๋๋ค. 4์ 01, 2021 5:15:08 ์ค์ org.apache.catalina.startup.Catalina start ์ ๋ณด: Server startup in 865 ms 4์ 01, 2021 5:15:09 ์ค์ org.apache.catalina.core.StandardWrapperValve invoke ์ฌ๊ฐ: ๊ฒฝ๋ก๊ฐ [/MVC01]์ธ ์ปจํ ์คํธ์ ์๋ธ๋ฆฟ [kr.bit.controller.MemberInsertController]์(๋ฅผ) ์ํ Servlet.service() ํธ์ถ์ด ์์ธ๋ฅผ ๋ฐ์์์ผฐ์ต๋๋ค. java.lang.NumberFormatException: null at java.lang.Integer.parseInt(Integer.java:542) at java.lang.Integer.parseInt(Integer.java:615) at kr.bit.controller.MemberInsertController.service(MemberInsertController.java:24) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:609) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:810) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1623) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. java.sql.SQLException: 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 com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:456) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at kr.bit.model.MemberDAO.getConnect(MemberDAO.java:22) at kr.bit.model.MemberDAO.memberInsert(MemberDAO.java:34) at kr.bit.controller.MemberInsertController.service(MemberInsertController.java:40) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:609) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:810) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1623) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) 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) 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.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85) at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132) at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2118) at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2142) at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1310) at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:967) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826) ... 31 more java.lang.NullPointerException at kr.bit.model.MemberDAO.memberInsert(MemberDAO.java:39) at kr.bit.controller.MemberInsertController.service(MemberInsertController.java:40) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:609) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:810) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1623) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) 4์ 01, 2021 5:16:29 ์ค์ org.apache.catalina.core.StandardWrapperValve invoke ์ฌ๊ฐ: ๊ฒฝ๋ก [/MVC01]์ ์ปจํ ์คํธ ๋ด์ ์๋ธ๋ฆฟ [kr.bit.controller.MemberInsertController]์(๋ฅผ) ์ํ Servlet.service() ํธ์ถ์ด, ๊ทผ๋ณธ ์์ธ(root cause)๊ณผ ํจ๊ป, ์์ธ [not insert]์(๋ฅผ) ๋ฐ์์์ผฐ์ต๋๋ค. javax.servlet.ServletException: not insert at kr.bit.controller.MemberInsertController.service(MemberInsertController.java:48) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:609) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:810) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1623) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)
- 0
- 4
- 4.7K
Q&A
์๋ ํ์ธ์ ์ง๋ฌธ์ ๋๋ค.
์๋ ์ฐ๋ mysql์ root์์ด๋์ ๋น๋ฐ๋ฒํธ๋ก cmd๋ก ์ด๋ป๊ฒ ๋ค์ด๊ฐ์ต๋๋ค. ๊ทผ๋ฐ mysql ๊ณ์ ์๋ก ๋ง๋ค ํ์ ์์ด ๊ทธ๋ฅ ์๋ ์์ด๋ ๋ฃจํธ ๊ณ์ ์ ๊ทธ๋๋ก ๋ฐ๋ผํด๋ ์๋ฌด ์ง์ฅ ์๋์? ๊ทธ๋ฆฌ๊ณ mysql ๋ฒ์ ๋ 8๋ฒ์ ๊ฐ์๋ฐ ๋ฒ์ ๋ฌ๋ผ๋ ์๋ฌด ๋ฌธ์ ์๋์?
- 0
- 4
- 273
Q&A
Comparator ์ง๋ฌธ์ ๋๋ค.
์์ธํ ์์ ๋ ๋ต๋ณ ์ ๋ง ๊ฐ์ฌํฉ๋๋ค. ์๋ฐ๋ก ์ฝํ ๋ฅผ ์ค๋นํ์ง ์ผ๋ง ์ ๋์ง๋ง ์ comparator ๋ถ๋ถ์ ๋ณผ ๋๋ง๋ค ๊ณ์ ์ด๋ ต๊ณ ํท๊ฐ๋ ธ๊ฑฐ๋ ์. ์ ์นํ๋ค ํ์ จ๋๋ฐ ์คํ๋ ค ์ ์ดํด๊ฐ ๋ ์ ๋์ ์ข์ ๊ฑฐ ๊ฐ์์. ๋ค๋ฅธ ๊ฐ์๋ ์ผ๋ฅธ ๋์์ผ๋ฉด ์ข๊ฒ ๋ค์. ๋ต๋ณ ๊ฐ์ฌํฉ๋๋ค.
- 1
- 2
- 442
Q&A
1๋ฒ ์คํํ๋ฉด ์๋ฌ๊ฐ ๋จ๋๋ฐ ์ด์ ๋ฅผ ๋ชจ๋ฅด๊ฒ ์ต๋๋ค..
(์ฌ์ง)
- 0
- 2
- 326