How to get back message data from SQL Server 2008

[Scott <li...@hotmail.com>]

I have setup JDBC Persistence Adapter in MSSQL2008. And topic and queue
information were successfully log into database.

But i cant find a way to convert "ACTIVEMQ_MSGS.MSG" (image data type) value
to plain text value.

Is there a way to do on database level, or we have to retrieve those data
and do it in application level if we want to see that?

--
View this message in context: http://activemq.2283324.n4.nabble.com/How-to-get-back-message-data-from-SQL-Server-2008-tp3562612p3562612.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.

Re: How to get back message data from SQL Server 2008

[Gary Tully <ga...@gmail.com>]

that has to be done at the application level. The serialized jms
message is stored as a blob of bytes.

have a peek at: addMessage/getMessage of the persistence adapter impl
to see the serialization etc:

http://svn.apache.org/viewvc/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/JDBCMessageStore.java?view=markup


On 31 May 2011 10:16, Scott <li...@hotmail.com> wrote:
> I have setup JDBC Persistence Adapter in MSSQL2008. And topic and queue
> information were successfully log into database.
>
> But i cant find a way to convert "ACTIVEMQ_MSGS.MSG" (image data type) value
> to plain text value.
>
> Is there a way to do on database level, or we have to retrieve those data
> and do it in application level if we want to see that?
>
> --
> View this message in context: http://activemq.2283324.n4.nabble.com/How-to-get-back-message-data-from-SQL-Server-2008-tp3562612p3562612.html
> Sent from the ActiveMQ - User mailing list archive at Nabble.com.
>



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