-
JBOSS JTA for 2 phase commit in Distributed transactions
Hi folks,
I really need you help...I m stuck up......
I m getting challenges in implemting the 2 phase commit by using Jboss JTA (Arjuna Transaction)...I am using JBoss 4.0.5 and ojdbc14 jar file....Oracle XA resource....
but when I am trying to end the transaction branch...by using the XAResource.end(Xid,TMSUCESS)...I am getting the XA erros like XA -3,XA-4 which means invalid Xid...
and SQL errors like ORA 24771 which means "can not detach prepare,or forget a local transaction.. ,and ORA-24756...which mean "transaction does not exist;An invalid transaction identifier or context was used or the transaction has completed"
17:04:41,984 INFO [Server] Starting JBoss (MX MicroKernel)...
17:04:41,984 INFO [Server] Release ID: JBoss [Zion] 4.0.5.GA (build: CVSTag=Branch_4_0 date=200610162339)
17:04:42,000 INFO [Server] Home Dir: D:\Amit_jboss\jboss-4.0.5.GA
17:04:42,000 INFO [Server] Home URL: file:/D:/Amit_jboss/jboss-4.0.5.GA/
17:04:42,000 INFO [Server] Patch URL: null
17:04:42,000 INFO [Server] Server Name: default
17:04:42,000 INFO [Server] Server Home Dir: D:\Amit_jboss\jboss-4.0.5.GA\server\default
17:04:42,000 INFO [Server] Server Home URL: file:/D:/Amit_jboss/jboss-4.0.5.GA/server/default/
17:04:42,000 INFO [Server] Server Log Dir: D:\Amit_jboss\jboss-4.0.5.GA\server\default\log
17:04:42,000 INFO [Server] Server Temp Dir: D:\Amit_jboss\jboss-4.0.5.GA\server\default\tmp
17:04:42,000 INFO [Server] Root Deployment Filename: jboss-service.xml
17:04:42,515 INFO [ServerInfo] Java version: 1.5.0_11,Sun Microsystems Inc.
17:04:42,515 INFO [ServerInfo] Java VM: Java HotSpot(TM) Client VM 1.5.0_11-b03,Sun Microsystems Inc.
17:04:42,515 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
17:04:42,998 INFO [Server] Core system initialized
17:04:44,824 INFO [WebService] Using RMI server codebase: http://DK081AS10275:8083/
17:04:44,839 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resource:log4j.xml
17:04:49,286 INFO [ServiceEndpointManager] WebServices: jbossws-1.0.3.SP1 (date=200609291417)
17:04:50,628 INFO [Embedded] Catalina naming disabled
17:04:50,675 INFO [ClusterRuleSetFactory] Unable to find a cluster rule set in the classpath. Will load the default rule set.
17:04:50,675 INFO [ClusterRuleSetFactory] Unable to find a cluster rule set in the classpath. Will load the default rule set.
17:04:50,924 INFO [Http11BaseProtocol] Initializing Coyote HTTP/1.1 on http-0.0.0.0-8080
17:04:50,924 INFO [Catalina] Initialization processed in 249 ms
17:04:50,924 INFO [StandardService] Starting service jboss.web
17:04:50,940 INFO [StandardEngine] Starting Servlet Engine: Apache Tomcat/5.5.20
17:04:50,955 INFO [StandardHost] XML validation disabled
17:04:50,987 INFO [Catalina] Server startup in 63 ms
17:04:51,283 INFO [TomcatDeployer] deploy, ctxPath=/invoker, warUrl=.../deploy/http-invoker.sar/invoker.war/
17:04:51,533 INFO [WebappLoader] Dual registration of jndi stream handler: factory already defined
17:04:51,907 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=.../deploy/jbossweb-tomcat55.sar/ROOT.war/
17:04:52,126 INFO [TomcatDeployer] deploy, ctxPath=/jbossws, warUrl=.../tmp/deploy/tmp58799jbossws-context-exp.war/
17:04:52,266 INFO [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil, warUrl=.../deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
17:04:53,187 INFO [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=.../deploy/management/console-mgr.sar/web-console.war/
17:04:53,811 INFO [MailService] Mail Service bound to java:/Mail
17:04:54,060 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-local-jdbc.rar
17:04:54,107 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-xa-jdbc.rar
17:04:54,138 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar
17:04:54,170 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-xa-jdbc.rar
17:04:54,232 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jms/jms-ra.rar
17:04:54,279 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/mail-ra.rar
17:04:55,621 INFO [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java efaultDS'
17:04:55,870 INFO [A] Bound to JNDI name: queue/A
17:04:55,886 INFO [B] Bound to JNDI name: queue/B
17:04:55,886 INFO [C] Bound to JNDI name: queue/C
17:04:55,886 INFO [D] Bound to JNDI name: queue/D
17:04:55,886 INFO [ex] Bound to JNDI name: queue/ex
17:04:55,901 INFO [testTopic] Bound to JNDI name: topic/testTopic
17:04:55,901 INFO [securedTopic] Bound to JNDI name: topic/securedTopic
17:04:55,901 INFO [testDurableTopic] Bound to JNDI name: topic/testDurableTopic
17:04:55,901 INFO [testQueue] Bound to JNDI name: queue/testQueue
17:04:55,948 INFO [UILServerILService] JBossMQ UIL service available at : /0.0.0.0:8093
17:04:55,995 INFO [DLQ] Bound to JNDI name: queue/DLQ
17:04:56,167 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
17:04:56,229 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
17:04:56,416 INFO [TomcatDeployer] deploy, ctxPath=/jtapoc, warUrl=.../tmp/deploy/tmp58831jtapoc-exp.war/
17:04:56,588 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
17:04:56,650 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
17:04:56,666 INFO [JkMain] Jk running ID=0 time=0/31 config=null
17:04:56,682 INFO [Server] JBoss (MX MicroKernel) [4.0.5.GA (build: CVSTag=Branch_4_0 date=200610162339)] Started in 14s:682ms
17:05:07,634 ERROR [STDERR] oracle.jdbc.xa.OracleXAException
17:05:07,634 ERROR [STDERR] at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1223)
17:05:07,634 ERROR [STDERR] at oracle.jdbc.xa.client.OracleXAResource.end(OracleXAResource.java:480)
17:05:07,634 ERROR [STDERR] at com.amt.TMServlet.doGet(TMServlet.java:228)
17:05:07,634 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
17:05:07,634 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
17:05:07,634 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.ja va:252)
17:05:07,634 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
17:05:07,634 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
17:05:07,634 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.ja va:202)
17:05:07,634 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
17:05:07,634 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
17:05:07,634 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
17:05:07,634 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.jav a:175)
17:05:07,634 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
17:05:07,634 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
17:05:07,634 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
17:05:07,634 ERROR [STDERR] at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
17:05:07,634 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
17:05:07,634 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
17:05:07,634 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
17:05:07,634 ERROR [STDERR] at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http 11BaseProtocol.java:664)
17:05:07,634 ERROR [STDERR] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
17:05:07,634 ERROR [STDERR] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
17:05:07,634 ERROR [STDERR] at java.lang.Thread.run(Unknown Source)
17:05:07,634 INFO [STDOUT] Target DB is being populated with the records from Source DB...
17:05:07,775 INFO [STDOUT] XA Error is -4
17:05:07,775 INFO [STDOUT] SQL Error is 24756
17:05:07,837 INFO [STDOUT] XA Error is -3
17:05:07,837 INFO [STDOUT] SQL Error is 24771
17:05:07,868 INFO [STDOUT] XA Error is -3
17:05:07,868 INFO [STDOUT] SQL Error is 24771
17:05:07,868 INFO [STDOUT] Return value of prepare 1 is 10
17:05:07,868 INFO [STDOUT] Return value of prepare 2 is 70
17:05:07,868 INFO [STDOUT] do_commit is false
17:05:07,868 INFO [STDOUT] Is oxar1 same as oxar2 ? true
17:05:07,915 INFO [STDOUT] SRC Col1 is 0
17:05:07,915 INFO [STDOUT] SRC Col1 is 1
17:05:07,915 INFO [STDOUT] SRC Col1 is 2
17:05:07,915 INFO [STDOUT] SRC Col1 is 3
17:05:07,915 INFO [STDOUT] SRC Col1 is 4
17:05:07,931 INFO [STDOUT] SRC Col1 is 5
17:05:07,931 INFO [STDOUT] SRC Col1 is 6
17:05:07,931 INFO [STDOUT] SRC Col1 is 7
17:05:07,931 INFO [STDOUT] SRC Col1 is 8
17:05:07,931 INFO [STDOUT] SRC Col1 is 9
17:05:07,931 INFO [STDOUT] SRC Col1 is 10
17:05:07,993 INFO [STDOUT] Target Col1 is 0
17:05:07,993 INFO [STDOUT] Target Col1 is 1
17:05:07,993 INFO [STDOUT] Target Col1 is 2
Similar Threads
-
By shahid in forum Enterprise
Replies: 0
Last Post: 10-03-2002, 08:24 AM
-
By Razvan in forum Database
Replies: 4
Last Post: 05-03-2002, 05:23 AM
-
Replies: 0
Last Post: 06-20-2001, 09:21 AM
-
By Andy Cortwright in forum Database
Replies: 1
Last Post: 06-20-2001, 09:09 AM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Bookmarks