Database/MySQL

executeQuery() 에러

Jeffrey Oh 2019. 10. 8. 15:22
반응형

executeQuery() 에러


executeQuery() 실행 후 

com.mysql.jdbc.CommunicationsException: The last communications with the server was 63 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

문구가 나오면 DB 테이블 컬럼 중 Char 속성이 있는지 확인

있다면 PrepareStatement인 동적을 Statement인 정적으로 바꿔서 테스트


반응형