[jboss-user] [JBoss Messaging] - Re: How to browse the DLQ?

[Aurélien Lansmanne]

Aurélien Lansmanne [http://community.jboss.org/people/alansmanne] created the discussion

"Re: How to browse the DLQ?"

To view the discussion, visit: http://community.jboss.org/message/622915#622915

--------------------------------------------------------------
I'm sorry but I can't share my code.

The DLQ is stored using an hsql local database. If you can connect to this local database, you should be able to browse the DLQ with a simple query :
SELECT messageid FROM jms_messages WHERE destination = 'QUEUE.DLQ'

The configuration file is hsqldb-ds.xml in jbossdir/server/xxxx/deploy/
The default datasource name is  +<jndi-name>DefaultDS</jndi-name>+
So you should be able to connected using something like 
>  dataSource = (DataSource) context.lookup("java:/DefaultDS");
> dataSource.createConnection().createStatement(...
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/622915#622915]

Start a new discussion in JBoss Messaging at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2042]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110825/770c650b/attachment.html