Connection Timeout ignored (mariaDB java Client 1.5.3)?


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 !


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.