[jboss-jira] [JBoss JIRA] Resolved: (JBJCA-634) Support query timeout for check-valid-connection-sql

[Jesper Pedersen (JIRA)]

     [ https://issues.jboss.org/browse/JBJCA-634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesper Pedersen resolved JBJCA-634.
-----------------------------------

    Resolution: Rejected


You should use a 'valid-connection-checker' with a 'config-property' with the query timeout.

  <valid-connection-checker class="MyClass">
     <config-property name="MyQueryTimeout">5</config-property>
  </valid-connection-checker>

Please, use the forum to discuss new features in the future

> Support query timeout for check-valid-connection-sql
> ----------------------------------------------------
>
>                 Key: JBJCA-634
>                 URL: https://issues.jboss.org/browse/JBJCA-634
>             Project: IronJacamar
>          Issue Type: Feature Request
>          Components: JDBC
>    Affects Versions: 1.0.0.Final
>            Reporter: Takayoshi Kimura
>            Assignee: Jesper Pedersen
>
> When network hangs and check-valid-connection-sql is executed, it hangs until socket timeout which is normally 5min or longer.
> We can avoid this long timeout if we have ability to set query timeout for check-valid-connection-sql and the underlying JDBC driver supports query timeout.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira