[jira] Commented: (IBATIS-22) Specify Query Timeout

["Robert DeVito (JIRA)" <ib...@incubator.apache.org>]

    [ http://issues.apache.org/jira/browse/IBATIS-22?page=comments#action_12412624 ] 

Robert DeVito commented on IBATIS-22:
-------------------------------------

My team is new to iBATIS, but is also interested in utilizing a "setQueryTimeout" method, to take advantage of the JDBC drivers that support it. We've used it in the past as an alternative to looking to JTA for enforcing operation timeouts in a x-action (I'm guessing this is how some JTA implementations actually make their x-action timeouts work).

(fwiw - I decompiled the Oracle type-4 JDBC driver to see what they're doing. Looks like they actually spawn a separate thread, and call "cancel( )" on the statement if the timeout occurs b4 the operation is done)

Anyway - any news on the IBAtis team exposing this functionality ? 

(thanks)

> Specify Query Timeout
> ---------------------
>
>          Key: IBATIS-22
>          URL: http://issues.apache.org/jira/browse/IBATIS-22
>      Project: iBatis for Java
>         Type: New Feature

>   Components: SQL Maps
>     Reporter: Rahul Kapoor

>
> There seems to be no current way to specify timeouts for select statements. I did see a message in the sf forum that using driver properties is a possible workaround. But it would be really nice to have a per statement timeout.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira