[jbpm-users] [JBoss jBPM] - Re: JBPM-3.3.0 login issues
They are missing in the 3.3.0 version.
I took them from the 3.2.3 version:
create table JBPM_ID_GROUP (ID_ number(19,0) not null, CLASS_ char(1 char) not null, NAME_
varchar2(255 char), TYPE_ varchar2(255 char), PARENT_ number(19,0), primary key (ID_));
create table JBPM_ID_MEMBERSHIP (ID_ number(19,0) not null, CLASS_ char(1 char) not null,
NAME_ varchar2(255 char), ROLE_ varchar2(255 char), USER_ number(19,0), GROUP_
number(19,0), primary key (ID_));
create table JBPM_ID_PERMISSIONS (ENTITY_ number(19,0) not null, CLASS_ varchar2(255
char), NAME_ varchar2(255 char), ACTION_ varchar2(255 char));
create table JBPM_ID_USER (ID_ number(19,0) not null, CLASS_ char(1 char) not null, NAME_
varchar2(255 char), EMAIL_ varchar2(255 char), PASSWORD_ varchar2(255 char), primary key
(ID_));
create table JBPM_JOB (ID_ number(19,0) not null, CLASS_ char(1 char) not null, VERSION_
number(10,0) not null, DUEDATE_ timestamp, PROCESSINSTANCE_ number(19,0), TOKEN_
number(19,0), TASKINSTANCE_ number(19,0), ISSUSPENDED_ number(1,0), ISEXCLUSIVE_
number(1,0), LOCKOWNER_ varchar2(255 char), LOCKTIME_ timestamp, EXCEPTION_ varchar2(4000
char), RETRIES_ number(10,0), NAME_ varchar2(255 char), REPEAT_ varchar2(255 char),
TRANSITIONNAME_ varchar2(255 char), ACTION_ number(19,0), GRAPHELEMENTTYPE_ varchar2(255
char), GRAPHELEMENT_ number(19,0), NODE_ number(19,0), primary key (ID_));
You can populate them with this data for a starter:
INSERT INTO JBPM_ID_USER
VALUES(1,'U','user','user(a)sample.domain','user'); INSERT
INTO JBPM_ID_USER
VALUES(2,'U','manager','manager(a)sample.domain','manager');
INSERT INTO JBPM_ID_USER
VALUES(3,'U','admin','admin(a)sample.domain','admin');
INSERT INTO JBPM_ID_USER
VALUES(4,'U','shipper','shipper(a)sample.domain','shipper');
INSERT INTO JBPM_ID_GROUP
VALUES(1,'G','sales','organisation',NULL); INSERT INTO
JBPM_ID_GROUP VALUES(2,'G','manager','security-role',NULL); INSERT
INTO JBPM_ID_GROUP VALUES(3,'G','hr','organisation',NULL); INSERT
INTO JBPM_ID_GROUP VALUES(4,'G','admin','security-role',NULL);
INSERT INTO JBPM_ID_GROUP
VALUES(5,'G','user','security-role',NULL); INSERT INTO
JBPM_ID_MEMBERSHIP VALUES(1,'M',NULL,NULL,2,2); INSERT INTO JBPM_ID_MEMBERSHIP
VALUES(2,'M',NULL,NULL,2,4); INSERT INTO JBPM_ID_MEMBERSHIP
VALUES(3,'M',NULL,NULL,3,4); INSERT INTO JBPM_ID_MEMBERSHIP
VALUES(4,'M',NULL,NULL,2,5); INSERT INTO JBPM_ID_MEMBERSHIP
VALUES(5,'M',NULL,NULL,1,5); INSERT INTO JBPM_ID_MEMBERSHIP
VALUES(6,'M',NULL,NULL,4,3); INSERT INTO JBPM_ID_MEMBERSHIP
VALUES(7,'M',NULL,NULL,4,5); INSERT INTO JBPM_ID_MEMBERSHIP
VALUES(8,'M',NULL,NULL,3,5); INSERT INTO JBPM_ID_MEMBERSHIP
VALUES(9,'M',NULL,NULL,3,3); INSERT INTO JBPM_ID_MEMBERSHIP
VALUES(10,'M',NULL,NULL,2,3); INSERT INTO JBPM_ID_MEMBERSHIP
VALUES(11,'M',NULL,'boss',2,1); INSERT INTO JBPM_ID_MEMBERSHIP
VALUES(12,'M',NULL,NULL,1,1);
It worked for me!!
Jan
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4196457#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...