How to configure the transaction timeout on an XAResource?

[chalakanth]

We use JBoss 3.2.3 and SQL Server 2000 at the back, through Microsft's SQL Server JDBC driver.

The most recent service pack of the driver, 3a, has some functionality that we want to use. It is now possible to set a transaction timeout on the database, through the setTransactionTimeout method of the XAResource interface.

http://knowledgebase2.datadirect.com/kbase.nsf/SupportLink+Online/2466876BD?OpenDocument

Is there some way for me to specify this timeout in the data source related configuration files in JBoss. I looked at the jboss-ds_1_0.dtd, and did not find anything. The XAResource is not exposed to the client and the transaction timeout I set for the transaction manager does not seem to be passed on to the XAResource.

Any help is appreciated.

thanks,

chalakanth

[adrian.brock]

There is currently no way to do this.
Perhaps you would care to provide a patch, it should be a property on the
ManagedConnectionFactory.

[chalakanth]

Thanks for the reply. We really want this fix, so we'll take a shot at creating the patch. Thanks again.