API tools faq
paste
Advertisement
Guest User

XA Exception

a guest
Oct 31st, 2010
484
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 8.77 KB | None | 0 0
raw download clone embed print report
  1. <<< beginning the transaction >>>
  2. No properties path set - looking for transactions.properties in classpath...
  3. transactions.properties not found - looking for jta.properties in classpath...
  4. Using init file: /C:/Botswana/apache/lib/jta.properties
  5. before conn.createStatement()
  6. DBTest >> com.atomikos.datasource.ResourceException: XA resource 'jdbc/myDB': resume for XID '31302E3130302E3130302E32392E746D30303030313030303032:31302E3130302
  7. E3130302E32392E746D31' raised -3: the XA resource detected an internal error
  8.         at com.atomikos.datasource.xa.XAResourceTransaction.resume(XAResourceTransaction.java:483)
  9.         at com.atomikos.datasource.xa.session.BranchEnlistedStateHandler.<init>(BranchEnlistedStateHandler.java:57)
  10.         at com.atomikos.datasource.xa.session.NotInBranchStateHandler.checkEnlistBeforeUse(NotInBranchStateHandler.java:66)
  11.         at com.atomikos.datasource.xa.session.TransactionContext.checkEnlistBeforeUse(TransactionContext.java:85)
  12.         at com.atomikos.datasource.xa.session.SessionHandleState.notifyBeforeUse(SessionHandleState.java:176)
  13.         at com.atomikos.jdbc.AtomikosConnectionProxy.enlist(AtomikosConnectionProxy.java:197)
  14.         at com.atomikos.jdbc.AtomikosConnectionProxy.invoke(AtomikosConnectionProxy.java:131)
  15.         at $Proxy1.createStatement(Unknown Source)
  16.         at com.medcpu.testJTA.TestJTA.init(TestJTA.java:53)
  17.         at org.apache.jsp.test_jsp._jspService(test_jsp.java:63)
  18.         at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
  19.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
  20.         at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
  21.         at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
  22.         at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
  23.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
  24.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  25.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  26.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  27.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
  28.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
  29.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  30.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  31.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
  32.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
  33.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
  34.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
  35.         at java.lang.Thread.run(Thread.java:619)
  36. Nested exception is:
  37. javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Failed to create the XA control connection. Error: "The EXECUTE permission was denied on the object 'xp_sqljdbc_xa_init_ex', database 'master', schema 'dbo'."
  38.         at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:642)
  39.         at com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(SQLServerXAResource.java:674)
  40.         at com.atomikos.datasource.xa.XAResourceTransaction.resume(XAResourceTransaction.java:476)
  41.         at com.atomikos.datasource.xa.session.BranchEnlistedStateHandler.<init>(BranchEnlistedStateHandler.java:57)
  42.         at com.atomikos.datasource.xa.session.NotInBranchStateHandler.checkEnlistBeforeUse(NotInBranchStateHandler.java:66)
  43.         at com.atomikos.datasource.xa.session.TransactionContext.checkEnlistBeforeUse(TransactionContext.java:85)
  44.         at com.atomikos.datasource.xa.session.SessionHandleState.notifyBeforeUse(SessionHandleState.java:176)
  45.         at com.atomikos.jdbc.AtomikosConnectionProxy.enlist(AtomikosConnectionProxy.java:197)
  46.         at com.atomikos.jdbc.AtomikosConnectionProxy.invoke(AtomikosConnectionProxy.java:131)
  47.         at $Proxy1.createStatement(Unknown Source)
  48.         at com.medcpu.testJTA.TestJTA.init(TestJTA.java:53)
  49.         at org.apache.jsp.test_jsp._jspService(test_jsp.java:63)
  50.         at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
  51.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
  52.         at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
  53.         at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
  54.         at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
  55.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
  56.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  57.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  58.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  59.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
  60.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
  61.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  62.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  63.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
  64.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
  65.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
  66.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
  67.         at java.lang.Thread.run(Thread.java:619)
  68. javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Failed to create the XA control connection. Error: "The EXECUTE permission was denied on the object 'xp_sqljdbc_xa_init_ex', database 'master', schema 'dbo'."
  69.         at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:642)
  70.         at com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(SQLServerXAResource.java:674)
  71.         at com.atomikos.datasource.xa.XAResourceTransaction.resume(XAResourceTransaction.java:476)
  72.         at com.atomikos.datasource.xa.session.BranchEnlistedStateHandler.<init>(BranchEnlistedStateHandler.java:57)
  73.         at com.atomikos.datasource.xa.session.NotInBranchStateHandler.checkEnlistBeforeUse(NotInBranchStateHandler.java:66)
  74.         at com.atomikos.datasource.xa.session.TransactionContext.checkEnlistBeforeUse(TransactionContext.java:85)
  75.         at com.atomikos.datasource.xa.session.SessionHandleState.notifyBeforeUse(SessionHandleState.java:176)
  76.         at com.atomikos.jdbc.AtomikosConnectionProxy.enlist(AtomikosConnectionProxy.java:197)
  77.         at com.atomikos.jdbc.AtomikosConnectionProxy.invoke(AtomikosConnectionProxy.java:131)
  78.         at $Proxy1.createStatement(Unknown Source)
  79.         at com.medcpu.testJTA.TestJTA.init(TestJTA.java:53)
  80.         at org.apache.jsp.test_jsp._jspService(test_jsp.java:63)
  81.         at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
  82.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
  83.         at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
  84.         at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
  85.         at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
  86.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
  87.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  88.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  89.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  90.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
  91.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
  92.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  93.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  94.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
  95.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
  96.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
  97.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
  98.         at java.lang.Thread.run(Thread.java:619)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!