Return-Path: X-Original-To: apmail-activemq-users-archive@www.apache.org Delivered-To: apmail-activemq-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A612145B5 for ; Tue, 31 May 2011 09:16:38 +0000 (UTC) Received: (qmail 99312 invoked by uid 500); 31 May 2011 09:16:38 -0000 Delivered-To: apmail-activemq-users-archive@activemq.apache.org Received: (qmail 99253 invoked by uid 500); 31 May 2011 09:16:37 -0000 Mailing-List: contact users-help@activemq.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@activemq.apache.org Delivered-To: mailing list users@activemq.apache.org Received: (qmail 99245 invoked by uid 99); 31 May 2011 09:16:37 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 May 2011 09:16:37 +0000 X-ASF-Spam-Status: No, hits=2.3 required=5.0 tests=FREEMAIL_FROM,RFC_ABUSE_POST,SPF_SOFTFAIL,T_TO_NO_BRKTS_FREEMAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: softfail (nike.apache.org: transitioning domain of liuhebian@hotmail.com does not designate 216.139.236.26 as permitted sender) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 May 2011 09:16:30 +0000 Received: from joe.nabble.com ([192.168.236.139]) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1QRL3Z-0005jr-MV for users@activemq.apache.org; Tue, 31 May 2011 02:16:09 -0700 Date: Tue, 31 May 2011 02:16:09 -0700 (PDT) From: Scott To: users@activemq.apache.org Message-ID: <1306833369681-3562612.post@n4.nabble.com> Subject: How to get back message data from SQL Server 2008 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org 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.