1 Reply Latest reply on Sep 30, 2008 11:35 AM by Adrian Brock

    adding a JMS user for Durable JMS Consumer

    Matthew Purdy Newbie

      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?