Hi All,

I am developing an integration… where in we have basically three tables…

Source … Buffer and Log…

on Buffer table we have the notification.

For Buffer and log table i am using one connection ex: Connection_01
For Source table i am using other connection ex: Connection_02

i am using local_transaction, i am using JDBC connection and my DB is oracle.

my flow is something like this…
Main
Try
----Select from source,
----- Publish to broker…
-----After successful publish…update the Log table fields…
Catch
-----lasterror
Initially the log table fields have STATUS === INSERT… after publishing i am updating with PUBLISHED…

but when i am doing this it is throwing this error…

. [ART.117.4015] Adapter Runtime (Adapter Service): Error(s) occurred while closing adapter connections…

2. [ART.117.4036] Adapter Runtime (Adapter Service): Unable to commit transaction. Transaction state: Transaction is rolled back

3. [SCC.0121.0034E] commit failed: more than 1 local trans enlisted

com.wm.pkg.art.error.DetailedServiceException: [ART.117.4018] Adapter Runtime (Adapter Service): Error while closing transactions at service completion Error:[ART.117.4015] Adapter Runtime (Adapter Service): Error(s) occurred while closing adapter connections.
[ART.117.4015] Adapter Runtime (Adapter Service): Error(s) occurred while closing adapter connections…
[ART.117.4015] Adapter Runtime (Adapter Service): Error(s) occurred while closing adapter connections.
[ART.117.4015] Adapter Runtime (Adapter Service): Error(s) occurred while closing adapter connections.
at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:125)
at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:116)
at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:103)
at com.wm.pkg.art.transaction.ServiceListener.serviceSucceeded(ConnectionState.java:460)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.serviceCompleted(ServiceCompletionImpl.java:167)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:252)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:198)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:39)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:407)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:503)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:325)
at com.wm.app.b2b.server.dispatcher.trigger.Trigger.invokeService(Trigger.java:291)
at com.wm.app.b2b.server.dispatcher.trigger.Trigger.processMessage(Trigger.java:195)
at com.wm.app.b2b.server.dispatcher.trigger.DefaultTriggerTaskHelper.process(DefaultTriggerTaskHelper.java:206)
at com.wm.app.b2b.server.dispatcher.trigger.TriggerTask.run(TriggerTask.java:228)
at com.wm.util.pool.Pooled

Please let me know wht could be the solution for this…

I cannot update the data in Log table… due to the above error…