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.ma...@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
