activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gary Tully <gary.tu...@gmail.com>
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: https://github.com/apache/activemq/blob/trunk/activemq-jdbc-store/src/main/java/org/apache/activemq/store/jdbc/JDBCMessageStore.java#L117

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 <stacy.mader@csiro.au> 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: http://activemq.2283324.n4.nabble.com/MySQL-column-MSG-format-tp4680378.html
> Sent from the ActiveMQ - User mailing list archive at Nabble.com.



-- 
http://redhat.com
http://blog.garytully.com

Mime
View raw message