Atomikos Forum

Hi

I have a transaction which takes about 30 minutes to process but den max query timeout is 5min (300000ms).

Is there a way to handle this?

Regards,
Wolfgang

You can increase the default timeout using com.atomikos.icatch.max_timeout property.

But it's generally a bad design to have long running transactions. You should fight for several shorter transactions instead.

Here is a Spring example:

    <bean id="userTransactionService" class="com.atomikos.icatch.config.UserTransactionServiceImp"
        init-method="init" destroy-method="shutdownForce">
        <constructor-arg>
            <props>
                <prop key="com.atomikos.icatch.service">com.atomikos.icatch.standalone.UserTransactionServiceFactory</prop>
                <prop key="com.atomikos.icatch.output_dir">${transaction_manager.work.path}</prop>
                <prop key="com.atomikos.icatch.log_base_dir">${transaction_manager.log.path}</prop>
                <prop key="com.atomikos.icatch.console_log_level">${transaction_manager.log.level}</prop>
                <prop key="com.atomikos.icatch.enable_logging">${transaction_manager.recovery.enable}</prop>
                <!-- FIXME: Temporarily set the max transaction timeout to 3h -->
                <prop key="com.atomikos.icatch.max_timeout">10800000</prop>
            </props>
        </constructor-arg>
    </bean>