Hello,
currently we are using SAP DB 7.4 and the 7.4.4 driver jar (both builds, the one from the web page and the (newer) from the software distribution). We have configured SAB DB as a XADataSource jca service .
Out Application is a J2EE Application including heavy CMP 2.x and JMS Operations (on this data source).
If we use the xa-transaction mode, we get very poor performance, if we switch to local-tx, everything works fine. We are not talking about x% degradation, but it is factor 100 slower. It works fine with MS SQL Server 2000 (using the JSqlConnect XA Datasource).
Has anybody experiences with SAP DB XA Driver on Jboss 3.2? Are there any hints how we can debug possible deadlocks or other sleeps? (We do not think there are any, since it works with MS SQL and Oracle just fine).
We need to do XA, because we want to have the CMP and the JMS in a joined transaction and JBoss can do this only with XA Transactions.
A Test Program doing JDBC Operations performs well, but this is not using the XADatasource. So we do not have a network issue here.
The both hosts (App Server and Database) on Windows 2000 are nearly idle, if we run our test suite, so this looks like some sleep somewhere.
Comments welcome.
Greetings
Bernd
--
Chief Architect, SEEBURGER AG
http://www.seeburger.de/
