[jboss-jira] [JBoss JIRA] (JBJCA-1309) Query timeout (set-tx-query-timeout) not applied within last second before transaction timeout

[Jesper Pedersen (JIRA)]

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

Jesper Pedersen moved WFLY-6050 to JBJCA-1309:
----------------------------------------------

              Project: IronJacamar  (was: WildFly)
                  Key: JBJCA-1309  (was: WFLY-6050)
             Workflow: classic default workflow  (was: GIT Pull Request workflow )
          Component/s: JDBC
                           (was: JCA)
    Affects Version/s: 1.2.6.Final
                           (was: 9.0.2.Final)


> Query timeout (set-tx-query-timeout) not applied within last second before transaction timeout
> ----------------------------------------------------------------------------------------------
>
>                 Key: JBJCA-1309
>                 URL: https://issues.jboss.org/browse/JBJCA-1309
>             Project: IronJacamar
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 1.2.6.Final
>            Reporter: Piotr Findeisen
>            Assignee: Jesper Pedersen
>
> When using {{<set-tx-query-timeout>true</set-tx-query-timeout}}, the query timeout is applied, unless less than 1 second remains until transaction timeout.
> This is due to a typo in code converting transaction timeout (millis) into jdbc timeout (seconds).
> Widlfy 9.0.2 uses IronJacama 1.2.5, so here's the code (https://github.com/ironjacamar/ironjacamar/blob/ironjacamar-1.2.5.Final/adapters/src/main/java/org/jboss/jca/adapters/jdbc/WrapperDataSource.java#L207):
> {code}
>             long result = timeout / 1000;
>             if ((result % 1000) != 0) // <------   the `timeout % 1000` was supposed to be
>                ++result;
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)