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

[mpurdy1973]

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#4179214

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4179214