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

[Takayoshi Kimura (JIRA)]

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

Takayoshi Kimura updated JBJCA-634:
-----------------------------------

    Description: 
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.

  was:
When network hangs and check-valid-connection-sql is executed, it hangs until socket timeout which is normally 5min or more 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.



> 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