Transaction timeout + iBatis

[mwpluto]

Hi,

we use iBatis in the data access layer of our application and declarative transaction management.

It seems that the transaction timeout parameter is not supported for iBatis.
At least DataSourceUtils.applyTransactionTimeout is not called within the iBatis support classes as far as I have seen (Springframework version 1.2.3).

Is this correct?

[Juergen Hoeller]

Spring's SqlMapClientFactoryBean actually uses a transaction-aware DataSource by default (see "useTransactionAwareDataSource" property). This implicitly applies transaction timeouts to all JDBC Statements that the SqlMapClient creates underneath.

There is unfortunately no obvious way to apply transaction timeout at the JDBC Statement level, simply because SQL Maps doesn't expose them. However, that shouldn't matter too much: the transaction-aware DataSource should be fine as well.

Juergen

[rebingw]

by doing this we are applying transaction properties to all statements. Is there any way that we can apply timeout to specific methods or statements.