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/