synapse-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rajika Kumarasiri <raj...@wso2.com>
Subject DBreport mediator and tx mediator
Date Mon, 24 Aug 2009 11:23:15 GMT
hello every body,
When using dbreport mediator together with tx mediator in a distributed
transaction due to the commit operation in DBReport mediator
(DBReportMediator.java:57) the following exception occurs[1].  This is due
to we can't manage the commit during a container manage transaction. I think
we should have a parameter  saying this is a distributed transaction and
disable the commit operation in DBReport mediator.  Having a
parameter(indicating using a distributed transaction) in axis2.xml would be
a solution for this. WDYT?

-Rajika

[1] -
java.sql.SQLException: You cannot set autocommit during a managed
transaction!
    at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.setJdbcAutoCommit(BaseWrapperManagedConnection.java:598)
    at
org.jboss.resource.adapter.jdbc.WrappedConnection.setAutoCommit(WrappedConnection.java:458)
    at
org.apache.synapse.mediators.db.DBReportMediator.processStatement(DBReportMediator.java:42)
    at
org.apache.synapse.mediators.db.AbstractDBMediator.mediate(AbstractDBMediator.java:102)
    at
org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:60)
    at
org.apache.synapse.mediators.filters.OutMediator.mediate(OutMediator.java:55)
    at
org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:60)
    at
org.apache.synapse.mediators.base.SequenceMediator.mediate(SequenceMediator.java:115)
    at
org.apache.synapse.core.axis2.Axis2SynapseEnvironment.injectMessage(Axis2SynapseEnvironment.java:131)
    at
org.apache.synapse.core.axis2.SynapseCallbackReceiver.handleMessage(SynapseCallbackReceiver.java:339)
    at
org.apache.synapse.core.axis2.SynapseCallbackReceiver.receive(SynapseCallbackReceiver.java:135)
    at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:178)
    at
org.apache.synapse.transport.nhttp.ClientWorker.run(ClientWorker.java:230)
    at
org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:58)
    at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
    at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
    at java.lang.Thread.run(Thread.java:595)


-- 
http://wso2.org
http://llvm.org
http://www.minix3.org/

Mime
View raw message