Fw: how to use intalio bpm server with oracle database

[James Hu]

hi,

 

I downloaded intalio-bpms-5.2.0.050 from bpm.intalio.com site, and tried to use it with oracle database. But it reported error and I could not login in ui-fw web content.

 

The steps I have done are here, please tell me how to support oracle database. 

 

(1) Put oracle jdbc thin driver(ojdbc14-10.2.0.2.0.jar) into D:\Run\intalio-bpms-5.2.0.050\repository\com\oracle\ojdbc14\10.2.0.2.0 directory.

(2) Start Intalio bpm server (now it means using derby database).

(3) Login into geronimo web console and  register the oracle dirver into common lib.

(4) Write the deploy plan file as attachment file named "geronimo-ds.xml". In this plan file I set the name of "connectiondefinition-instance" to "BPMSDS", and use moduleId as this:

 

        <dep:moduleId>

            <dep:groupId>com.intalio.bpms</dep:groupId>

            <dep:artifactId>BPMSDS</dep:artifactId>

            <dep:version>1.0</dep:version>

            <dep:type>rar</dep:type>

        </dep:moduleId>

 

(5) Using deploy command to deploy it like this: java -jar bin/deployer.jar redeploy databases\Oracle\geronimo-ds.xml repository\org\tranql\tranql-connector-ra\1.3\tranql-connector-ra-1.3.rar

 

The result of deploy command is here:

Username: system

Password: *******

    No ModuleID or TargetModuleID provided.  Attempting to guess based

    on the content of the plan.

    Attempting to use ModuleID 'com.intalio.bpms/BPMSDS/1.0/rar'

    Stopped com.intalio.bpms/BPMSDS/1.0/rar

    Unloaded com.intalio.bpms/BPMSDS/1.0/rar

    Uninstalled com.intalio.bpms/BPMSDS/1.0/rar

    Deployed com.intalio.bpms/BPMSDS/1.0/rar

    Started com.intalio.bpms/BPMSDS/1.0/rar

    Redeployed com.intalio.bpms/BPMSDS/1.0/rar

 

(6) Restart server and login ui-fw with "admin/changeit" user/password, but it report error. The output in console is here:

17:10:48,875 ERROR [LoginController] Error during login

java.lang.SecurityException: org.apache.axis2.AxisFault: Transport error: 404 Error: Not Found

        at org.intalio.tempo.web.controller.LoginController.authenticate(LoginController.java:278)

        at org.intalio.tempo.web.controller.LoginController.authenticate(LoginController.java:308)

        at org.intalio.tempo.web.controller.LoginController.logIn(LoginController.java:328)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

 

I find that it's because of "axis2" war can not be start successfully. But I do not know which reason.

 

(7) Then I change to use Derby again. I edit the "geronimo-ds.xml" in "databases/Derby" directory, to change "CreateDatabase" element to "false".

 

(8) Using deploy command to deploy derby database connector plan like this: java -jar bin/deployer.jar redeploy databases\Derby\geronimo-ds.xml repository\org\tranql\tranql-connector-derby-embed-xa\1.3\tranql-connector-derby-embed-xa-1.3.rar . This runs ok.

 

(9) Then restart server and login ui-fw again. but it still report error, same as before. I do not why this time?

 

Can anyboby tell me how to execute intalio server with oracle database?

Thanks.

 

2008-12-24

---

James Hu

[Nicolas Modrzyk]

Intalio server with Oracle database is extensively supported and addressed in in the Enterprise Edition of Intalio|BPMS.

Nicolas,

2008/12/25 James Hu <jame...@vip.sina.com>