How to disable transactions from the client side when connecting to MetaMatrix
Issue
- Disable transactions for a client connection
- Receive below error when executing read-only queries:
Exception in thread "main" com.metamatrix.jdbc.MMSQLException: Error occurred on connector mmuuid:0ac0bc40-a684-1200-8f24-b98cb158fd37 - Connection must be of type XAConnection. at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:71) at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:52) at com.metamatrix.jdbc.MMStatement.setException(MMStatement.java:358) at com.metamatrix.jdbc.MMPreparedStatement.processQueryMessage(MMPreparedStatement.java:176) at com.metamatrix.jdbc.MMPreparedStatement.executeQuery(MMPreparedStatement.java:210) at DataSourceCommandTest.main(DataSourceCommandTest.java:66) Caused by: [MetaMatrixException]Error occurred on connector mmuuid:0ac0bc40-a684-1200-8f24-b98cb158fd37 - Connection must be of type XAConnection. 1 [ConnectorException]Error occurred on connector mmuuid:0ac0bc40-a684-1200-8f24-b98cb158fd37 - Connection must be of type XAConnection. at com.metamatrix.dqp.message.ResultsMessage.setException(ResultsMessage.java:272) at com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorker.handleError(ConnectorWorker.java:181) at com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorker.process(ConnectorWorker.java:156) at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:51) Caused by: com.metamatrix.api.exception.MetaMatrixException[0]: com.metamatrix.data.exception.ConnectorException[0]: ConnectorException: com.metamatrix.core.MetaMatrixCoreException$StatusHolder@102799c at com.metamatrix.dqp.internal.datamgr.impl.ConnectorRequestState.getConnection(ConnectorRequestState.java:113) at com.metamatrix.dqp.internal.datamgr.impl.ConnectorRequestState.createExecution(ConnectorRequestState.java:142) at com.metamatrix.dqp.internal.datamgr.impl.ConnectorRequestStateManager.createExecution(ConnectorRequestStateManager.java:114) at com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorker.process(ConnectorWorker.java:138) at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:51) Caused by: com.metamatrix.data.exception.ConnectorException[0]: ConnectorException: com.metamatrix.core.MetaMatrixCoreException$StatusHolder@102799c at com.metamatrix.dqp.internal.datamgr.impl.ConnectorRequestState.getConnection(ConnectorRequestState.java:113) at com.metamatrix.dqp.internal.datamgr.impl.ConnectorRequestState.createExecution(ConnectorRequestState.java:142) at com.metamatrix.dqp.internal.datamgr.impl.ConnectorRequestStateManager.createExecution(ConnectorRequestStateManager.java:114) at com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorker.process(ConnectorWorker.java:138) at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:51) Caused by: ConnectorException: com.metamatrix.core.MetaMatrixCoreException$StatusHolder@102799c at com.metamatrix.dqp.internal.datamgr.impl.ConnectorRequestState.getConnection(ConnectorRequestState.java:113) at com.metamatrix.dqp.internal.datamgr.impl.ConnectorRequestState.createExecution(ConnectorRequestState.java:142) at com.metamatrix.dqp.internal.datamgr.impl.ConnectorRequestStateManager.createExecution(ConnectorRequestStateManager.java:114) at com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorker.process(ConnectorWorker.java:138) at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:51)
Environment
- MetaMatrix Enterprise Server 5.5.4
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.