[jboss-user] [JBossMQ] - adding a JMS user for Durable JMS Consumer

I have looked at the sql in hsqldb-jdbc-state-service.xml and come to the conclusion that i could append to the attribute name="SqlProperties" with the following: | POPULATE.TABLES.15 = INSERT INTO JMS_USERS (USERID, PASSWD) VALUES ('test', 'testUser') | POPULATE.TABLES.16 = INSERT INTO JMS_ROLES (ROLEID, USERID) VALUES ('subscriber','test') | POPULATE.TABLES.17 = INSERT INTO JMS_ROLES (ROLEID, USERID) VALUES ('publisher','test') | POPULATE.TABLES.18 = INSERT INTO JMS_ROLES (ROLEID, USERID) VALUES ('durpublisher','test') | | | then use the method: TopicConnectionFactory.createTopicConnection('test', 'testUser'); | | however, is there an easier way to do this? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4179214#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...