Hi To use XA with SQL Server, there's a DLL you need to copy on your SQL Server machine itself, some stored procedures that need to be imported, and MSDTC needs to be configured.
Hopefully this will help, https://msdn.microsoft.com/en-us/library/aa342335.aspx, but let us know if not and I'll try and put some better instructions together. Jon On Thu, Mar 30, 2017 at 10:56 AM, Dignesh <[email protected]> wrote: > Hi Romain, > > I resolved the issue somehow. I recreated the ear , deleted the tmp etc... > > I see a different issue now. Do I need to enable something in Sqlserver ? > Or > is there any other configuration that needs to be done in tomee. > > Mar 30, 2017 3:28:34 PM > org.apache.geronimo.transaction.manager.TransactionImpl enlistResource > WARNING: Unable to enlist XAResource XAResourceID:1, errorCode: -3 > javax.transaction.xa.XAException: > com.microsoft.sqlserver.jdbc.SQLServerException: Failed to create the XA > control connection. Error: Could not find stored procedure > 'master..xp_sqljdbc_xa_init'.. > at > com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_ > Interface(SQLServerXAResource.java:640) > at > com.microsoft.sqlserver.jdbc.SQLServerXAResource.start( > SQLServerXAResource.java:672) > at > org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource( > TransactionImpl.java:209) > at > org.apache.openejb.resource.jdbc.managed.local.ManagedConnection.invoke( > ManagedConnection.java:134) > at com.sun.proxy.$Proxy82.prepareStatement(Unknown Source) > at > org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare( > StatementPreparerImpl.java:159) > at > org.hibernate.engine.jdbc.internal.StatementPreparerImpl$ > StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java: > 183) > at > org.hibernate.engine.jdbc.internal.StatementPreparerImpl. > prepareQueryStatement(StatementPreparerImpl.java:157) > > Thank you very much. > > > > > -- > View this message in context: http://tomee-openejb.979440. > n4.nabble.com/issue-with-XADatasource-in-sqlserver-tp4681379p4681392.html > Sent from the TomEE Dev mailing list archive at Nabble.com. > -- Jonathan Gallimore http://twitter.com/jongallimore http://www.tomitribe.com
