Informix query timeout does not work while using connection pooling in JBoss

Question

I have added the following in domain.xml file:

<datasource ...>
...
    <timeout>
       <set-tx-query-timeout>true</set-tx-query-timeout>
       <query-timeout>1</query-timeout>
    </timeout>
</datasource>

and

<property name="javax.persistence.query.timeout" value="1"/>

in persistence.xml file.

But sql query takes more than one second and I did not encounter with any timeout exception. I am using :

• JBoss 7.2
• jdbc driver: ifxjdbc 3.7