2016. 9. 23. 11:19ㆍ99. 정리전 - IT/15. SQL 따라잡기
현상 : OS X El Capitan -> mac OS Sierra 로 업그레이드 후 아래와 같은 현상이 발생
java.sql.SQLException: Cannot create PoolableConnectionFactory (로케일을 인식할 수 없습니다.)
1 > POST http://localhost:8081/restapi/V1/auth/token/publish
1 > accept: */*
1 > accept-encoding: gzip, deflate
1 > accept-language: ko-KR
1 > connection: keep-alive
1 > content-length: 108
1 > content-type: application/x-www-form-urlencoded
1 > host: localhost:8081
1 > origin: http://192.168.5.145
1 > referer: http://192.168.5.145/doc/
1 > user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36
[2016-09-23 11:13:56.238|20160923111356-57e4f11f83f6412aa71abc4aeae437ed|DEBUG|o.s.j.d.DataSourceTransactionManager:367] Creating new transaction with name [net.minigate.mslp2.api.ejb.AuthBean.insertHandshake]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
[2016-09-23 11:13:56.900|20160923111356-57e4f11f83f6412aa71abc4aeae437ed|INFO |n.m.m.api.jaxrs.util.LoggingFilter:172] 2 * Server responded with a response on thread http-nio-8081-exec-2
2 < 500
2 < Content-Type: application/json
{"ok":false,"errorState":{"code":904,"message":"App 오류","reason":"java.sql.SQLException: Cannot create PoolableConnectionFactory (로케일을 인식할 수 없습니다.)"},"responseTime":"2016-09-23T11:13:56.764","newAccessToken":null}
Error 대처법
상기의 설정값 처럼 톰캣 실행 옵션 중 아래와 같이 추가한다
-Duser.language=ko
-Duser.country=KR
끝.