users@glassfish.java.net

JAX-WS and distributed transactions

From: Ryan de Laplante <ryan_at_ijws.com>
Date: Thu, 07 Jun 2007 10:42:40 -0400

Hi,

I have a JAX-WS client in an EJB session bean. It calls a web service
(EJB endpoint) I wrote that queries a database. I've noticed that it
forces distributed transactions on the service, and the service won't
work unless I use an XA datasource to access the database. The service
is querying an MS SQL Server 2005 database which doesn't support
two-phase commits unless you install MS Distributed Transaction
Coordinator (DTC) and basically fails immediately. The only way I can
get the XA driver to work is by enabling the "Non Transactional
Connections" setting on the connection pool.

Is there a way to disable distributed transactions with JAX-WS?


Thanks,
Ryan