[jbpm-users] [JBoss jBPM] - Re: jBPM3.2.3 with Tomcat 6

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&#39;,&#39;cookie.monster(a)sesamestreet.tv&#39;,&#39;cookie monster'); | INSERT INTO JBPM_ID_USER VALUES(2,&#39;U&#39;,&#39;ernie&#39;,&#39;ernie(a)sesamestreet.tv&#39;,&#39;ernie&#39;); | INSERT INTO JBPM_ID_USER VALUES(3,&#39;U&#39;,&#39;bert&#39;,&#39;bert(a)sesamestreet.tv&#39;,&#39;bert&#39;); | INSERT INTO JBPM_ID_USER VALUES(4,&#39;U&#39;,&#39;grover&#39;,&#39;grover(a)sesamestreet.tv&#39;,&#39;grover&#39;); | 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#... Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...