[SAP DB Dev] for sources

[news.omnitel.net]

I expect it should be posted to the *.sources
----- Original Message ----- 
From: Eckenfels. Bernd
Newsgroups: gmane.comp.db.sapdb.general
Cc: Schuster. Reinhard
Sent: Thursday, July 31, 2003 12:37 PM
Subject: Slow XADatasource with JBoss 3.2.0


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/