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인 정적으로 바꿔서 테스트
'Database > MySQL' 카테고리의 다른 글
| Value '0000-00-00' can not be represented as java.sql.Timestamp (0) | 2019.11.12 |
|---|---|
| Auto_increment 마지막 결과 얻기 (0) | 2019.11.11 |
| MySQL - 일별통계, 주간통계, 월간통계, 기간별통계 (3) | 2019.10.04 |
| Native Data Type Code (0) | 2019.09.26 |
| auto_increment 값 초기화 (0) | 2019.07.05 |
