Connection Timeout ignored (mariaDB java Client 1.5.3)?
Hi,
The problem i'm experiencing is: {tomcat 8 connection pool , spring application, mariadb java client} mariaDB java client 1.5.3, 1.4.6 (have tried both jars) lingers and hangs with the connection invalidated. (using iptables drop on Linux)
no timeout is issued and so the application hangs indefinitely.
i've tried to set an interceptor for the query timeout and also to set the connection timeout property in the datasource properties and also maxWait property - nothing seems to change the unresponsiveness issue.
the data source bean exert:
<bean id="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource"> <property name="driverClassName" value="${JDBC_DRIVER_CLASS_NAME}" /> <property name="url" value="${JDBC_URL}" /> <property name="username" value="${JDBC_USERNAME}" /> <property name="password" value="${JDBC_PASSWORD}" /> <property name="testWhileIdle" value="true" /> <property name="initialSize" value="10" /> <property name="maxActive" value="10" /> <property name="maxIdle" value="10" /> <property name="minIdle" value="10" /> <property name="maxWait" value="10000" /> <property name="timeBetweenEvictionRunsMillis" value="34000" /> <property name="minEvictableIdleTimeMillis" value="55000" /> <property name="validationQuery" value="SELECT 1" /> <property name="validationInterval" value="34000" /> <property name="testOnBorrow" value="true" /> <property name="removeAbandoned" value="true" /> <property name="removeAbandonedTimeout" value="55" /> </bean>
what other properties are there to configure? Thanks !
