How to set XA Datasouce transaction timeout

[tawalisa]

Hi all,

          I met a question about setting XA Datasouce transaction timeout.

     We use Teiid 7.2 as our server. A VDB integrate 2 datasouces. Those double datasouces used XA datasouce. Our teiid client use jdbc local transaction. Our client need spend so many time to execute VDB.  So teiid will throw Exception of set XA Datasouce transaction timeout at this time. My question is how and where to set XA Datasouce transaction timeout. Which configuration file will we update? Need I configure those double datasouce?

Thanks.

Best Regards

[rareddy]

Allen,

Change the below property in {jboss-as}/server/{profile}/deploy/transaction-jboss-beans.xml

<property name="transactionTimeout">1500</property>

Note that the above property is defined in "seconds".

Thanks.

Ramesh..