message240214.html

Hi,

I am trying to use XA driver  ( two phase commit) in my app server but getti
ng "Unable to get a XAConnection from the DataSource. exception" exception:

c740c74 FreePool      E J2CA0046E: Method createManagedConnctionWithMCWrappe
r caught an exception during creation of the ManagedConnection for resource 
jdbc/TeraSolve_SQL, throwing ResourceAllocationException.  Original exceptio
n: com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a XAConnection
 from the DataSource.


which followed by "Could not find stored procedure 'master..xp_jdbc_open'." 
exception :

[5/26/04 13:55:56:899 NZST]  c740c74 SystemErr     R com.dss.server.DSSException: [IBM][SQLServer JD
BC Driver][SQLServer]Could not find stored procedure 'master..xp_jdbc_open'.

I am new to this stuff and would appreciate any help to fix this problem.

I suspect that the zip/jar you're getting your driver from doesn't
support XA - or your database server does not. That will have to be fixed.

And how would I know what I am missing? What is the required jar ?

I am using "WebSphere embedded ConnectJDBC driver for MS SQL Server (XA)"  
that shipped with WebSphere and it uses sqlserver.jar,base.jar,util.jar and 
spy.jar.

You'll need to find an XA-compliant driver for
SQLServer.