inflearn logo
강의

講義

知識共有

JSP講義評価ウェブサイトの開発

MySQLとJSPの連携と実践

이 에러 어떻게 해결하나요? 회원가입 버튼 누르니 이런 에러 뜨네요

531

겸손한 바다사자

投稿した質問数 0

0

Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

Thu Jun 14 00:00:33 KST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

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:127)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:87)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:61)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:71)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)

at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:862)

at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:444)

at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:230)

at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:226)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at util.DatabaseUtil.getConnection(DatabaseUtil.java:14)

at user.UserDAO.join(UserDAO.java:14)

at org.apache.jsp.userJoinAction_jsp._jspService(userJoinAction_jsp.java:139)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:443)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

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:198)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1468)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)

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(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:59)

at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:83)

at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:128)

at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2201)

at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2225)

at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1391)

at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:993)

at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:852)

... 36 more

java.lang.NullPointerException

at user.UserDAO.join(UserDAO.java:15)

at org.apache.jsp.userJoinAction_jsp._jspService(userJoinAction_jsp.java:139)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:443)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

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:198)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1468)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)

jsp java

回答 2

0

jtig061760316

mysql-connector-java 파일 버전을 사용하시는 mysql 버전과 맞춰보세요.

-1

cyuco

다이렉트 자동차보험

운전자보험비교사이트

삼성화재다이렉트자동차보험

kb다이렉트자동차보험

캐롯퍼마일자동차보험

현대해상다이렉트자동차보험

db다이렉트자동차보험

오토바이보험비교견적

오토바이운전자보험

이륜차다이렉트보험

0

cyuco

자동차보험 할인특약

커넥티드카 할인

자녀할인 특약

어라운드뷰 할인

마일리지 특약

자동차보험갱신

자동차보험료1년

만26세자동차보험

자동차책임보험

오토바이 책임보험

다이렉트자동차보험순위

20대자동차보험료

자동차보험 할인

악사다이렉트자동차보험

자동차정기검사

흥국화재자동차보험

오토바이보험비교견적

 

0

cyuco

DB운전자보험

삼성화재운전자보험

KB이륜차보험

현대해상이륜차보험

듀오가입비

암보험비갱신형

티맵운전자할인

네이버 자동차보험 비교

자동차보험마일리지환급

현대해상할인특약-

자동차보험자녀할인

자기신체사고자동차상해

근로자녀장려금

국민내일배움카드

엠베스트중등가격

엘리하이가격

천재교육밀크티

밀크티아이가격

에이스치아보험

윙크학습지

유튜브프리미엄가격

 

 

0

cyuco

노인기초연금 금액

다이렉트자동차보험료비교견적사이트

다이렉트자동차보험

자동차보험

자동차보험비교견적사이트

실시간인터넷다이렉트자동차보험료비교견적사이트

삼성화재다이렉트자동차보험이벤트

삼성화재다이렉트자동차보험

삼성다이렉트자동차보험

db다이렉트자동차보험

db자동차보험

동부화재다이렉트자동차보험

현대해상다이렉트자동차보험

현대해상자동차보험

현대다이렉트자동차보험

캐롯퍼마일자동차보험

캐롯퍼마일자동차보험후기

KB다이렉트자동차보험

KB자동차보험

케이비자동차보험

오토바이보험

오토바이보험료

125cc오토바이보험료

전기오토바이보험료

배달오토바이보험료

이륜차보험

이륜차다이렉트보험

이륜차보험비교견적

이륜차보험비교

 

패키지 구분에 대해 궁금한게 있습니다

0

7

1

안녕하세요. 바뀐 채점사이트 관련해서 문의드립니다.

0

19

1

갑자기 채점 사이트가 바뀌었어요

0

19

1

문제 리스트 페이지

0

22

1

part8 Notion 링크

0

22

1

채점 사이트 관련 질문드립니다

0

20

1

인텔리제이 MCP 서버 설정 관련

0

25

1

조회속도 개선에서 더 개선하는 방법이 궁금합니다.

0

28

2

드롭다운 에러 Uncaught TypeError: i.createPopper is not a function

0

422

1

No value specified for parameter 2 에러

0

415

1

2강 null값 질문입니다

0

287

1

오류에 conn is null 이라고 떠요

0

1080

1

무조껀 회원가입에 성공했습니다라고 뜹니다.

0

305

1

dead코드... userDAO 클래스가 아닌 jsp파일쪽 임포트한 클래스쪽이 ㅠ

0

372

0

UserDAO userDAO = new UserDAO(); 해당 코드가 dead code라는데 어떻게 해야하나요??

0

294

0

오류가 뜨는데 왜그러는 걸까요 ? ㅜㅜ

0

292

0

명령 프롬프트에서 javac를 입력하면

0

321

0

이미 존재하는 아이디..

1

799

2

영어발음이너무구려요..

1

655

2

오류가 도저히 맥락을 모르겠어요 ㅜㅜ

2

485

3

dropdown 하위메뉴가 보이질 않아요

0

587

2

강의자료 다운받는 곳

2

337

0

이런 오류가 뜨는데 타이핑이 잘못된건가요??

0

247

0

mysql에 한글이 모두 ?로 저장됩니다.

0

270

1