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','u...@sample.domain','user');
  | INSERT INTO JBPM_ID_USER 
VALUES(2,'U','manager','mana...@sample.domain','manager');
  | INSERT INTO JBPM_ID_USER 
VALUES(3,'U','admin','ad...@sample.domain','admin');
  | INSERT INTO JBPM_ID_USER 
VALUES(4,'U','shipper','ship...@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
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to