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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
