java - Tomcat Data Source Losing Connection With DB -


i need solution tomcat datasource configuration. have 2 nginx front of tomcats.these feeding app, these webservice. tomcat machines , database in different ip blog going firewall in each request. when started tomcats everythigs well.but example after 10 hour our after 20 hour later everythings going bad.that tomcats can not set connection.all service down.i share datasource file , hope find solution or other suggestions other datasource file.

http://www.springframework.org/schema/beans ---- http://www.springframework.org/schema/context/spring-context.xsd">

    <property name="connectionproperties">         <props merge="default">             <prop key="v$session.program">ws_${server}</prop>         </props>     </property>      <property name="connectioncacheproperties">         <props merge="default">             <prop key="minlimit">1</prop>             <prop key="maxlimit">120</prop>             <prop key="initiallimit">5</prop>             <prop key="maxstatementslimit">50</prop>                             <prop key="connectionwaittimeout">30</prop>             <prop key="inactivitytimeout">600</prop>             <prop key="abandonedconnectiontimeout">180</prop>             <prop key="propertycheckinterval">300</prop>                             <prop key="validateconnection">true</prop>               <prop key="timetolivetimeout">600</prop>          </props>     </property> </bean>   <bean id="jdbctemplate" class="org.springframework.jdbc.core.jdbctemplate">     <property name="nativejdbcextractor">         <bean class="org.springframework.jdbc.support.nativejdbc.simplenativejdbcextractor" />     </property>     <property name="datasource" ref="datasource" /> </bean>  <bean class="com.ws.oracle.pool.jndiexporter">     <property name="bean" ref="datasource" />     <property name="jndiname" value="dsname" /> </bean> 


Comments

Popular posts from this blog

ios - RestKit 0.20 — CoreData: error: Failed to call designated initializer on NSManagedObject class (again) -

java - Digest auth with Spring Security using javaconfig -

laravel - PDOException in Connector.php line 55: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) -