The latest production-release driver: mysql-connector-java-3.1.13-bin.jar XML from: http://incubator.apache.org/activemq/jdbc-support.html: <bean id="mysql-ds" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost/activemq?relaxAutoCommit=true"/> <property name="username" value="activemq"/> <property name="password" value="activemq"/> <property name="poolPreparedStatements" value="true"/> </bean>
James.Strachan wrote: > > What JDBC driver are you using and what is your XML like? > > On 8/30/06, eklas <[EMAIL PROTECTED]> 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/ > > -- View this message in context: http://www.nabble.com/mysql-message-size-tf693529.html#a6133003 Sent from the ActiveMQ - User forum at Nabble.com.
