[jboss-user] [JBoss jBPM] - Re: jBPM3.2.3 with Tomcat 6

[melgamal]

thanx 4 ur replay

I allready insert data in Identity tables like this:

  | INSERT INTO JBPM_ID_GROUP VALUES(1,'G','sales','organisation',NULL);
  | INSERT INTO JBPM_ID_GROUP VALUES(2,'G','hr','organisation',NULL);
  | INSERT INTO JBPM_ID_GROUP VALUES(3,'G','participant','security-role',NULL);
  | INSERT INTO JBPM_ID_GROUP VALUES(4,'G','manager','security-role',NULL);
  | INSERT INTO JBPM_ID_GROUP VALUES(5,'G','administrator','security-role',NULL);
  | INSERT INTO JBPM_ID_USER VALUES(1,'U','cookie monster','cookie.monster at sesamestreet.tv','cookie monster');
  | INSERT INTO JBPM_ID_USER VALUES(2,'U','ernie','ernie at sesamestreet.tv','ernie');
  | INSERT INTO JBPM_ID_USER VALUES(3,'U','bert','bert at sesamestreet.tv','bert');
  | INSERT INTO JBPM_ID_USER VALUES(4,'U','grover','grover at sesamestreet.tv','grover');
  | INSERT INTO JBPM_ID_MEMBERSHIP VALUES(1,'M',NULL,NULL,1,3);
  | INSERT INTO JBPM_ID_MEMBERSHIP VALUES(2,'M',NULL,NULL,2,3);
  | INSERT INTO JBPM_ID_MEMBERSHIP VALUES(3,'M',NULL,NULL,4,2);
  | INSERT INTO JBPM_ID_MEMBERSHIP VALUES(4,'M',NULL,NULL,4,3);
  | INSERT INTO JBPM_ID_MEMBERSHIP VALUES(5,'M',NULL,NULL,3,3);
  | INSERT INTO JBPM_ID_MEMBERSHIP VALUES(6,'M',NULL,NULL,3,2);
  | INSERT INTO JBPM_ID_MEMBERSHIP VALUES(7,'M',NULL,NULL,2,2);
  | INSERT INTO JBPM_ID_MEMBERSHIP VALUES(8,'M',NULL,NULL,2,4);
  | INSERT INTO JBPM_ID_MEMBERSHIP VALUES(9,'M',NULL,NULL,2,5);
  | INSERT INTO JBPM_ID_MEMBERSHIP VALUES(10,'M',NULL,'boss',2,1);
  | INSERT INTO JBPM_ID_MEMBERSHIP VALUES(11,'M',NULL,NULL,1,1);
  | 

and also update data for oracl database using the following sql script:

  | update jbpm_id_membership j
  | set j.NAME_ = (SELECT u.NAME_ from jbpm_id_user u where j.USER_ = u.ID_)
  | 
  | 
  | update jbpm_id_membership j
  | set j.ROLE_ = (SELECT g.NAME_ from jbpm_id_group g where j.GROUP_ = g.ID_)
  | 

and define the realm as follow:

  | <Context>
  |  <Realm  className="org.apache.catalina.realm.JDBCRealm" 
  |     driverName="oracle.jdbc.driver.OracleDriver"
  |     connectionURL="jdbc:oracle:thin:@localhost:1521:orcl"
  |     connectionName="****" 
  |     connectionPassword="*****"
  |     userTable="JBPM_ID_USER" 
  |     userNameCol="NAME_" 
  |     userCredCol="PASSWORD_"
  |     userRoleTable="JBPM_ID_MEMBERSHIP" 
  |     roleNameCol="NAME_" />
  | </Context>     
  | 
am I missing any thing else?


View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4243062#4243062

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4243062