activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gary Tully <>
Subject Re: MySQL column MSG format
Date Thu, 17 Apr 2014 13:36:49 GMT
you really need a custom persistence adapter b/c the message blob is
the marshalled message (marshalled with opewire) so the same encoding
as we use on the wire by default.

peek at:

You would need to use an XML marshaller like we do for the http transport.
see: org.apache.activemq.transport.xstream.XStreamWireFormat

all of the statements can be changed via xml configuration (peek at
the schema) - so it should be possible to modify the blob type

On 17 April 2014 05:54, HubbaBubba <> wrote:
> Hi all,
> I'm using activeMQ v5.6 and connecting a simple chat application using
> ws+stomp. Ideally I would like to input the chat messages into the connected
> MySQL database (table activemq.activemq_msgs) as an XML object, however,
> looking at the messages in the MySQL table, it seems this is not entirely
> the case:
> MSG:   J    { /ID:hostname-55969-1397709076980-2:3       ????????e chat  n{
> /ID:hostname-55969-1397709076980-2:3       ????????              c
> Em?W    W<message type="chat" from="fred" text="This is a test."
> time="1397709362949"/>                       Em?W
> I understand one can change the default MySQL column definition in newer
> version of activeMQ via <statements binaryDataType ="?"/>, but this is not
> an option for me. I wonder if others have thought of another way?
> Thanks in advance.
> --
> View this message in context:
> Sent from the ActiveMQ - User mailing list archive at


View raw message