[jboss-user] [JBoss jBPM] - Re: Oracle DB with jbpm 3.3.1 GA
Toriton
do-not-reply at jboss.com
Thu Feb 12 03:40:32 EST 2009
I'm not sure if is the same problem i had at start :), but could be that you don' have USERS GROUPS and MEMBERSHIP in your tables.
If you need a script to create the db in oracle it is in the jBPM runtime location you configured.
The script posted here is for standard user as they are listed in the login page console.
(got this script from this post
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4067793#4067793 and worked fine for may Oracle Express 10)
| INSERT INTO JBPM_ID_GROUP VALUES(1,'G','sales','organisation',NULL);
| INSERT INTO JBPM_ID_GROUP VALUES(2,'G','admin','security-role',NULL);
| INSERT INTO JBPM_ID_GROUP VALUES(3,'G','user','security-role',NULL);
| INSERT INTO JBPM_ID_GROUP VALUES(4,'G','hr','organisation',NULL);
| INSERT INTO JBPM_ID_GROUP VALUES(5,'G','manager','security-role',NULL);
| INSERT INTO JBPM_ID_USER VALUES(1,'U','user','user at sample.domain','user');
| INSERT INTO JBPM_ID_USER VALUES(2,'U','manager','manager at sample.domain','manager');
| INSERT INTO JBPM_ID_USER VALUES(3,'U','admin','admin at sample.domain','admin');
| INSERT INTO JBPM_ID_USER VALUES(4,'U','shipper','shipper at sample.domain','shipper');
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(1,'M',NULL,NULL,2,4);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(2,'M',NULL,NULL,3,4);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(3,'M',NULL,NULL,4,4);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(4,'M',NULL,NULL,4,3);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(5,'M',NULL,NULL,1,3);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(6,'M',NULL,NULL,2,3);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(7,'M',NULL,NULL,3,3);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(8,'M',NULL,NULL,3,2);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(9,'M',NULL,NULL,2,2);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(10,'M',NULL,NULL,2,5);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(11,'M',NULL,'boss',2,1);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(12,'M',NULL,NULL,1,1);
I hope this help.
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4209380#4209380
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4209380
More information about the jboss-user
mailing list