What JDBC driver are you using and what is your XML like?

On 8/30/06, eklas <klas.eriksson@netgiro.com> wrote:
>
> This seems to happen:
>
> Caused by: java.io.IOException: Data truncation: Data too long for column
> 'MSG' at row 1
>  at
> org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:42)
>  at
> org.apache.activemq.store.jdbc.TransactionContext.close(TransactionContext.java:125)
>  at
> org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:74)
>  at
> org.apache.activemq.store.memory.MemoryTransactionStore.addMessage(MemoryTransactionStore.java:223)
>  at
> org.apache.activemq.store.memory.MemoryTransactionStore$1.addMessage(MemoryTransactionStore.java:116)
>  at org.apache.activemq.broker.region.Queue.send(Queue.java:253)
>  at
> org.apache.activemq.broker.region.AbstractRegion.send(AbstractRegion.java:225)
>  at
> org.apache.activemq.broker.region.RegionBroker.send(RegionBroker.java:342)
>  at
> org.apache.activemq.broker.TransactionBroker.send(TransactionBroker.java:192)
>  at org.apache.activemq.broker.BrokerFilter.send(BrokerFilter.java:113)
>  at
> org.apache.activemq.broker.CompositeDestinationBroker.send(CompositeDestinationBroker.java:97)
>  at
> org.apache.activemq.broker.MutableBrokerFilter.send(MutableBrokerFilter.java:126)
>  at
> org.apache.activemq.broker.AbstractConnection.processMessage(AbstractConnection.java:351)
>  at
> org.apache.activemq.command.ActiveMQMessage.visit(ActiveMQMessage.java:590)
>  at
> org.apache.activemq.broker.AbstractConnection.service(AbstractConnection.java:201)
>  at
> org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:62)
>  at
> org.apache.activemq.transport.ResponseCorrelator.onCommand(ResponseCorrelator.java:97)
>  at
> org.apache.activemq.transport.TransportFilter.onCommand(TransportFilter.java:63)
>  at
> org.apache.activemq.transport.WireFormatNegotiator.onCommand(WireFormatNegotiator.java:114)
>  at
> org.apache.activemq.transport.InactivityMonitor.onCommand(InactivityMonitor.java:122)
>  at
> org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:87)
>  at
> org.apache.activemq.transport.tcp.TcpTransport.run(TcpTransport.java:143)
>  at java.lang.Thread.run(Thread.java:595)
> Caused by: java.lang.Throwable: java.sql.BatchUpdateException: Data
> truncation: Data too long for column 'MSG' at row 1
>  at
> com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648)
>  at
> org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:205)
>  at
> org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:205)
>  at
> org.apache.activemq.store.jdbc.TransactionContext.executeBatch(TransactionContext.java:92)
>  at
> org.apache.activemq.store.jdbc.TransactionContext.executeBatch(TransactionContext.java:71)
>  at
> org.apache.activemq.store.jdbc.TransactionContext.close(TransactionContext.java:107)
>
>
> Jonathan Duty-2 wrote:
> >
> > I notice that the mysql persistence uses the datatype "blob''.  What
> > happens if a message is larger than 2^16 ?
> >
>
> --
> View this message in context: http://www.nabble.com/mysql-message-size-tf693529.html#a6053536
> Sent from the ActiveMQ - User forum at Nabble.com.
>
>


-- 

James
-------
http://radio.weblogs.com/0112098/