mysql 접속시에 자꾸 아래와 같은 에러가 나서..
Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
context.xml의 설정을 아래와 같이 바꿔주니 해결된듯하다.
<Resource auth="Container"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://xxx.xxx.xxx.xxx:3306/dbname?characterEncoding=utf-8&interactiveClient=true&autoReconnect=true&autoReconnectForPools=true&useUnicode=true&characterSetResults=UTF-8"
type="javax.sql.DataSource"
name="jdbc/xxxxx"
username="userid"
password="userpw"
initialSize="0"
maxActive="20"
maxIdle="10"
minIdle="0"
maxWait="-1"
validationQuery="SELECT 1"
testOnBorrow="true"
poolPreparedStatements="true"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"
loginTimeout="10"
/>