1 Reply Latest reply on Feb 12, 2009 3:40 AM by Stefano Ferrante

    Oracle DB with jbpm 3.3.1 GA

    Aby V Newbie

      Hi,
      Is it possible to use Oracle 9i as a persistent store with jbpm 3.3.1 GA ??

      I experimented by changing the configuration in the following files

      1: jbpm\jbpm-service.sar\hibernate.cfg.xml
      2: jbpm\jbpm-hsqldb-ds

      I was able to start the JBPM Server and view the console but was not able to login.

      Can anyone suggest an approach how to set Oracle as the DB for jbpm

      Thanks and Regds
      Aby

        • 1. Re: Oracle DB with jbpm 3.3.1 GA
          Stefano Ferrante Newbie

          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@sample.domain','user');
          INSERT INTO JBPM_ID_USER VALUES(2,'U','manager','manager@sample.domain','manager');
          INSERT INTO JBPM_ID_USER VALUES(3,'U','admin','admin@sample.domain','admin');
          INSERT INTO JBPM_ID_USER VALUES(4,'U','shipper','shipper@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.