We have upgraded activemq version from 5.8 to 5.14.1 we added an attribute for our broker so that it can read the older messages from 5.8 as storeOpenWireVersion="6"
It is working fine in mysql But in MsSql, we are getting errror as follows "Operand type clash: nvarchar is incompatible with image" jvm 1 | javax.jms.JMSException: Operand type clash: nvarchar is incompatible with image jvm 1 | at org.apache.activemq.util.JMSExceptionSupport.create(JMSExceptionSupport.java:54) jvm 1 | at org.apache.activemq.ActiveMQConnection.syncSendPacket(ActiveMQConnection.java:1399) jvm 1 | at org.apache.activemq.ActiveMQConnection.syncSendPacket(ActiveMQConnection.java:1428) jvm 1 | at org.apache.activemq.ActiveMQConnection.syncSendPacket(ActiveMQConnection.java:1323) jvm 1 | at org.apache.activemq.ActiveMQSession.send(ActiveMQSession.java:1967) jvm 1 | at org.apache.activemq.ActiveMQMessageProducer.send(ActiveMQMessageProducer.java:288) jvm 1 | at org.apache.activemq.ActiveMQMessageProducer.send(ActiveMQMessageProducer.java:223) jvm 1 | at org.apache.activemq.ActiveMQMessageProducerSupport.send(ActiveMQMessageProducerSupport.java:241) jvm 1 | at jvm 1 | Caused by: java.io.IOException: Operand type clash: nvarchar is incompatible with image jvm 1 | at org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:46) jvm 1 | at org.apache.activemq.store.jdbc.TransactionContext.close(TransactionContext.java:165) jvm 1 | at org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:165) jvm 1 | at org.apache.activemq.store.memory.MemoryTransactionStore.addMessage(MemoryTransactionStore.java:352) jvm 1 | at org.apache.activemq.store.memory.MemoryTransactionStore$1.asyncAddQueueMessage(MemoryTransactionStore .java:159) jvm 1 | at org.apache.activemq.broker.region.Queue.doMessageSend(Queue.java:837) jvm 1 | at org.apache.activemq.broker.region.Queue.send(Queue.java:727) jvm 1 | at org.apache.activemq.broker.region.AbstractRegion.send(AbstractRegion.java:503) jvm 1 | at org.apache.activemq.broker.region.RegionBroker.send(RegionBroker.java:468) jvm 1 | at org.apache.activemq.broker.BrokerFilter.send(BrokerFilter.java:153) jvm 1 | at org.apache.activemq.broker.scheduler.SchedulerBroker.send(SchedulerBroker.java:195) jvm 1 | at org.apache.activemq.broker.BrokerFilter.send(BrokerFilter.java:153) jvm 1 | at org.apache.activemq.broker.CompositeDestinationBroker.send(CompositeDestinationBroker.java:96) jvm 1 | at org.apache.activemq.broker.TransactionBroker.send(TransactionBroker.java:293) jvm 1 | at org.apache.activemq.broker.MutableBrokerFilter.send(MutableBrokerFilter.java:158) jvm 1 | at org.apache.activemq.broker.MutableBrokerFilter.send(MutableBrokerFilter.java:158) jvm 1 | at org.apache.activemq.broker.TransportConnection.processMessage(TransportConnection.java:578) jvm 1 | at org.apache.activemq.command.ActiveMQMessage.visit(ActiveMQMessage.java:768) jvm 1 | at org.apache.activemq.broker.TransportConnection.service(TransportConnection.java:333) jvm 1 | at org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:197) jvm 1 | at org.apache.activemq.transport.MutexTransport.onCommand(MutexTransport.java:50) jvm 1 | at org.apache.activemq.transport.WireFormatNegotiator.onCommand(WireFormatNegotiator.java:125) jvm 1 | at org.apache.activemq.transport.AbstractInactivityMonitor.onCommand(AbstractInactivityMonitor.java:300) jvm 1 | at org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:83) jvm 1 | at org.apache.activemq.transport.tcp.TcpTransport.doRun(TcpTransport.java:233) jvm 1 | at org.apache.activemq.transport.tcp.TcpTransport.run(TcpTransport.java:215) jvm 1 | at java.lang.Thread.run(Thread.java:722) jvm 1 | Caused by: java.lang.Throwable: java.sql.BatchUpdateException: Operand type clash: nvarchar is incompatible w ith image jvm 1 | at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:1069) jvm 1 | at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345) jvm 1 | at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345) jvm 1 | at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345) jvm 1 | at org.apache.activemq.store.jdbc.TransactionContext.executeBatch(TransactionContext.java:130) jvm 1 | at org.apache.activemq.store.jdbc.TransactionContext.executeBatch(TransactionContext.java:108) jvm 1 | at org.apache.activemq.store.jdbc.TransactionContext.close(TransactionContext.java:156) jvm 1 | ... 25 more -- View this message in context: http://activemq.2283324.n4.nabble.com/Caused-by-java-lang-Throwable-java-sql-BatchUpdateException-Operand-type-clash-nvarchar-is-incompatie-tp4720797.html Sent from the ActiveMQ - User mailing list archive at Nabble.com.
