User Guide

Adobe LiveCycle Preparing Your Environment
Installing and Configuring LiveCycle for JBoss Creating a JMS database on SQL Server 47
12. Ensure that the default database is set to the database that you created in step 4 and that the default
language is English.
13. Click the Database Access tab, select the database that you created in step 4
and, in the Permit in
Database Role list, select public, and then click OK.
14. In the Confirm Password dialog box, select Blank Password and click OK.
15. Select Start > Programs > Microsoft SQL Server > Query Analyzer, and then log in as the user you
created in step 7
.
16. Copy the following SQL script into the Query window:
USE YourDatabase;
CREATE TABLE JMS_MESSAGES (MESSAGEID INTEGER NOT NULL,
DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER, TXOP CHAR(1),
MESSAGEBLOB IMAGE, PRIMARY KEY (MESSAGEID, DESTINATION));
CREATE TABLE JMS_TRANSACTIONS (TXID INTEGER);
CREATE TABLE JMS_USERS (USERID VARCHAR(32) NOT NULL,
PASSWD VARCHAR(32) NOT NULL, CLIENTID VARCHAR(128), PRIMARY KEY(USERID));
CREATE TABLE JMS_ROLES (ROLEID VARCHAR(32) NOT NULL,
USERID VARCHAR(32) NOT NULL, PRIMARY KEY(USERID, ROLEID));
CREATE TABLE JMS_SUBSCRIPTIONS (CLIENTID VARCHAR(128) NOT NULL,
SUBNAME VARCHAR(128) NOT NULL, TOPIC VARCHAR(255) NOT NULL,
SELECTOR VARCHAR(255), PRIMARY KEY(CLIENTID, SUBNAME));
INSERT INTO JMS_USERS (USERID, PASSWD) VALUES ('guest', 'guest');
INSERT INTO JMS_USERS (USERID, PASSWD) VALUES ('j2ee', 'j2ee');
INSERT INTO JMS_USERS (USERID, PASSWD, CLIENTID) VALUES ('john', 'needle',
'DurableSubscriberExample');
INSERT INTO JMS_USERS (USERID, PASSWD) VALUES ('nobody', 'nobody');
INSERT INTO JMS_USERS (USERID, PASSWD) VALUES ('dynsub', 'dynsub');
INSERT INTO JMS_ROLES (ROLEID, USERID) VALUES ('guest','guest');
INSERT INTO JMS_ROLES (ROLEID, USERID) VALUES ('j2ee','guest');
INSERT INTO JMS_ROLES (ROLEID, USERID) VALUES ('john','guest');
INSERT INTO JMS_ROLES (ROLEID, USERID) VALUES ('subscriber','john');
INSERT INTO JMS_ROLES (ROLEID, USERID) VALUES ('publisher','john');
INSERT INTO JMS_ROLES (ROLEID, USERID) VALUES ('publisher','dynsub');
INSERT INTO JMS_ROLES (ROLEID, USERID) VALUES ('durpublisher','john');
INSERT INTO JMS_ROLES (ROLEID, USERID) VALUES ('durpublisher','dynsub');
INSERT INTO JMS_ROLES (ROLEID, USERID) VALUES ('noacc','nobody');
17. In the first line of the script, replace YourDatabase with the name of the database that you created in
step 4
.
18. Run the script by clicking the green arrow on the taskbar. The SQL script should run without error.