Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mgreen84
Yak Posting Veteran
94 Posts |
 Posted - 2014-06-06 : 11:03:03
|
| I am trying to use the Sql Server XA datasource, and I am getting the following exception on my db, has anyone seen this error before or can stare me in correct path to address it?Error: [CODE]javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'master..xp_sqljdbc_xa_start'. at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:647) at com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(SQLServerXAResource.java:679) at com.sun.gjc.spi.XAResourceImpl.start(XAResourceImpl.java:224) at com.sun.jts.jta.TransactionState.startAssociation(TransactionState.java:304) at com.sun.jts.jta.TransactionImpl.enlistResource(TransactionImpl.java:212) at com.sun.enterprise.transaction.JavaEETransactionImpl.enlistResource(JavaEETransactionImpl.java:639) at com.sun.enterprise.transaction.JavaEETransactionManagerSimplified.enlistXAResource(JavaEETransactionManagerSimplified.java:1314)[/CODE] |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-06-06 : 11:42:04
|
| I am not familiar with XA, but the error message indicates that it is not finding an extended stored proc in the master database. Googling for it shows lot of resources - for example http://www.sqlservercentral.com/blogs/sql_server_dba/2011/12/05/enable-xa-transactions-for-sql-server-/ where they advise you to run "exec sp_addextendedproc 'xp_sqljdbc_xa_init', 'SQLJDBC_XA.dll'" to install the procs.To reiterate, I have no experience with it, so I can't comment on the safety or otherwise of doing this. |
 |
|
|
|
|
|
Receiving exception when using Sql Server XA datas