[jboss-user] [JBoss jBPM] - Re: jBPM 3.2.1 on AS 4.2.1

[mputz]

Angelo, 

good to hear that it's working now.

Now on to the move to Oracle ;-)

First, please have a look at Chapter 8 of the docu for a general overview of the necessary steps for switching the database backend:
http://docs.jboss.com/jbpm/v3.2/userguide/html/thejbpmdatabase.html
(Please note that the user guide is sometimes still referring to the 3.1 version and contains therefore outdated path references!)

The steps in short are the following:
1.) create the db schema
2.) deploy the appropriate *-ds.xml datasource configuration file
3.) copy the db driver to the server/your_config/lib folder
4.) tell hibernate which db you are using by updating jbpm-enterprise.ear/lib/jbpm-configs.jar/hibernate.cfg.xml with the correct hibernate.dialect property value

Regarding step 1.), the scripts for different databases including Oracle can be found in the jbpm-jpdl-3.2.1/db folder - for Oracle it's the file 'jbpm.jpdl.oracle.sql'. (If you were using jBPM 3.2.GA then the ddl statements for the tables for the identity components are missing in this file, however. This has been changed recently so if you checked out the latest version from CVS or work with 3.2.1 you should be fine and get a script which contains the create statements for all tables.)

In order to execute this start sqlplus with a user with sufficient privileges and invoke '@<path-to-file>/jbpm.jpdl.oracle.sql'. 

After that you might want to insert the test users to play around; here are the relevant sql statements for this:
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 at sample.domain','user');
  | INSERT INTO JBPM_ID_USER VALUES(2,'U','manager','manager at sample.domain','manager');
  | INSERT INTO JBPM_ID_USER VALUES(3,'U','admin','admin at sample.domain','admin');
  | INSERT INTO JBPM_ID_USER VALUES(4,'U','shipper','shipper at 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);

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

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