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?

[adrian.brock]

Just update the database directly.

See the FAQ on why you shouldn't use JBossMQ