Hi ...can any one help me on this...
I am trying to implement 2 phase commit in a distributed transaction....I am using JBoss 4.0.5 JTA ...and I m using Oracle XAResource..ojdbc14 jar file in classpath.
..and when I am ending a transaction branch..using the end method OracleXAResource.end(xid1, XAResource.TMSUCCESS);I am getting oracle errror 24756( transaction does not exist),and XA -4 (invalid Xid)..and Oracle error 24771(can not detach,prepare ,forget a local transaction) XA-3....
17:10:56,163 INFO [Server] Starting JBoss (MX MicroKernel)...
17:10:56,163 INFO [Server] Release ID: JBoss [Zion] 4.0.5.GA (build: CVSTag=Branch_4_0 date=200610162339)
17:10:56,163 INFO [Server] Home Dir: D:\Amit_jboss\jboss-4.0.5.GA
17:10:56,163 INFO [Server] Home URL: file:/D:/Amit_jboss/jboss-4.0.5.GA/
17:10:56,178 INFO [Server] Patch URL: null
17:10:56,178 INFO [Server] Server Name: default
17:10:56,178 INFO [Server] Server Home Dir: D:\Amit_jboss\jboss-4.0.5.GA\server\default
17:10:56,178 INFO [Server] Server Home URL: file:/D:/Amit_jboss/jboss-4.0.5.GA/server/default/
17:10:56,178 INFO [Server] Server Log Dir: D:\Amit_jboss\jboss-4.0.5.GA\server\default\log
17:10:56,178 INFO [Server] Server Temp Dir: D:\Amit_jboss\jboss-4.0.5.GA\server\default\tmp
17:10:56,178 INFO [Server] Root Deployment Filename: jboss-service.xml
17:10:56,584 INFO [ServerInfo] Java version: 1.5.0_11,Sun Microsystems Inc.
17:10:56,584 INFO [ServerInfo] Java VM: Java HotSpot(TM) Client VM 1.5.0_11-b03,Sun Microsystems Inc.
17:10:56,584 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
17:10:57,038 INFO [Server] Core system initialized
17:10:59,100 INFO [WebService] Using RMI server codebase:
http://DK081AS10275:8083/
17:10:59,116 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resource:log4j.xml
17:11:03,882 INFO [ServiceEndpointManager] WebServices: jbossws-1.0.3.SP1 (date=200609291417)
17:11:05,648 INFO [Embedded] Catalina naming disabled
17:11:05,726 INFO [ClusterRuleSetFactory] Unable to find a cluster rule set in the classpath. Will load the default rule set.
17:11:05,726 INFO [ClusterRuleSetFactory] Unable to find a cluster rule set in the classpath. Will load the default rule set.
17:11:06,148 INFO [Http11BaseProtocol] Initializing Coyote HTTP/1.1 on http-0.0.0.0-8080
17:11:06,148 INFO [Catalina] Initialization processed in 422 ms
17:11:06,148 INFO [StandardService] Starting service jboss.web
17:11:06,148 INFO [StandardEngine] Starting Servlet Engine: Apache Tomcat/5.5.20
17:11:06,195 INFO [StandardHost] XML validation disabled
17:11:06,257 INFO [Catalina] Server startup in 109 ms
17:11:06,632 INFO [TomcatDeployer] deploy, ctxPath=/invoker, warUrl=.../deploy/http-invoker.sar/invoker.war/
17:11:07,273 INFO [WebappLoader] Dual registration of jndi stream handler: factory already defined
17:11:07,867 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=.../deploy/jbossweb-tomcat55.sar/ROOT.war/
17:11:08,133 INFO [TomcatDeployer] deploy, ctxPath=/jbossws, warUrl=.../tmp/deploy/tmp31298jbossws-context-exp.war/
17:11:08,367 INFO [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil, warUrl=.../deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
17:11:10,008 INFO [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=.../deploy/management/console-mgr.sar/web-console.war/
17:11:11,008 INFO [MailService] Mail Service bound to java:/Mail
17:11:11,383 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-local-jdbc.rar
17:11:11,461 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-xa-jdbc.rar
17:11:11,524 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar
17:11:11,570 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-xa-jdbc.rar
17:11:11,649 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jms/jms-ra.rar
17:11:11,711 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/mail-ra.rar
17:11:13,336 INFO [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'
17:11:13,743 INFO [A] Bound to JNDI name: queue/A
17:11:13,743 INFO [B] Bound to JNDI name: queue/B
17:11:13,743 INFO [C] Bound to JNDI name: queue/C
17:11:13,743 INFO [D] Bound to JNDI name: queue/D
17:11:13,743 INFO [ex] Bound to JNDI name: queue/ex
17:11:13,789 INFO [testTopic] Bound to JNDI name: topic/testTopic
17:11:13,789 INFO [securedTopic] Bound to JNDI name: topic/securedTopic
17:11:13,789 INFO [testDurableTopic] Bound to JNDI name: topic/testDurableTopic
17:11:13,789 INFO [testQueue] Bound to JNDI name: queue/testQueue
17:11:13,883 INFO [UILServerILService] JBossMQ UIL service available at : /0.0.0.0:8093
17:11:13,961 INFO [DLQ] Bound to JNDI name: queue/DLQ
17:11:14,243 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
17:11:14,336 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
17:11:14,649 INFO [TomcatDeployer] deploy, ctxPath=/jtapoc, warUrl=.../tmp/deploy/tmp31330jtapoc-exp.war/
17:11:14,977 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
17:11:15,196 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
17:11:15,243 INFO [JkMain] Jk running ID=0 time=0/125 config=null
17:11:15,258 INFO [Server] JBoss (MX MicroKernel) [4.0.5.GA (build: CVSTag=Branch_4_0 date=200610162339)] Started in 19s:80ms
17:12:23,469 INFO [STDOUT] Target DB is being populated with the records from Source DB...
17:12:42,393 INFO [STDOUT] XA Error is -4
17:12:46,456 INFO [STDOUT] SQL Error is 24756
17:12:51,019 INFO [STDOUT] XA Error is -4
17:12:54,410 INFO [STDOUT] SQL Error is 24756
17:12:57,223 INFO [STDOUT] XA Error is -3
17:13:17,428 INFO [STDOUT] SQL Error is 24771
17:13:21,475 INFO [STDOUT] XA Error is -3
17:13:23,022 INFO [STDOUT] SQL Error is 24771
17:13:24,022 INFO [STDOUT] Return value of prepare 1 is 10
17:13:25,210 INFO [STDOUT] Return value of prepare 2 is 70
17:13:27,757 INFO [STDOUT] do_commit is false
17:13:28,148 INFO [STDOUT] Is oxar1 same as oxar2 ? true
17:13:35,149 INFO [STDOUT] SRC Col1 is 0
17:13:37,868 INFO [STDOUT] SRC Col1 is 1
17:13:38,633 INFO [STDOUT] SRC Col1 is 2
17:13:39,337 INFO [STDOUT] SRC Col1 is 3
17:13:39,977 INFO [STDOUT] SRC Col1 is 4
17:13:41,180 INFO [STDOUT] SRC Col1 is 5
17:13:41,649 INFO [STDOUT] SRC Col1 is 6
17:13:42,337 INFO [STDOUT] SRC Col1 is 7
17:13:42,712 INFO [STDOUT] SRC Col1 is 8
17:13:43,728 INFO [STDOUT] SRC Col1 is 9
17:13:44,228 INFO [STDOUT] SRC Col1 is 10
17:13:45,509 INFO [STDOUT] Target Col1 is 0
17:13:46,181 INFO [STDOUT] Target Col1 is 1
17:13:46,619 INFO [STDOUT] Target Col1 is 2
17:13:47,275 INFO [STDOUT] Target Col1 is 3
17:13:47,712 INFO [STDOUT] Target Col1 is 4
17:13:49,791 INFO [STDOUT] Target Col1 is 5
17:13:50,291 INFO [STDOUT] Target Col1 is 6
17:13:50,728 INFO [STDOUT] Target Col1 is 7
17:13:51,088 INFO [STDOUT] Target Col1 is 8
17:13:51,447 INFO [STDOUT] Target Col1 is 9