MySQL AutoReconnect 설정.

참조 : http://hmjkor.tistory.com/176

?

1 2 3 4 5 6 7 8 9 10 11 12

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">         <property name="driverClass" value="com.mysql.jdbc.Driver"></property>         <property name="jdbcUrl" value="jdbc:mysql://{your_ip}:{your_port}/{your_db}?autoReconnect=true"> </property>         <property name="user" value="${user_id}"></property>         <property name="password" value="{user_pw}"></property>         <property name="initialPoolSize" value="10"></property>         <property name="maxPoolSize" value="30"></property>         <!-- 아래 설정이 reconnect -->         <property name="idleConnectionTestPeriod" value="1800"></property>         <property name="preferredTestQuery" value="SELECT 1"></property>         <property name="testConnectionOnCheckin" value="true"></property> </bean>