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:11:41
|
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: 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) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-06 : 13:22:16
|
| You need to look in the master database to see if the XA extended stored procedures have been created. According to the error, they have not. I've setup XA numerous times and am very familiar with its setup. Was the dll added to the BINN directory on the database server? If so, as the install SQL script run?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Receiving exception when using Sql Server XA datas