Wednesday, July 15, 2009

Apache ODE with JBoss and Oracle

The following steps describe how you can install Apache Ode with JBoss and Oracle.

Assumptions:
Apache ODE 1.2
JBoss 4.2.2.GA installed
Oracle 9i installed

  1. Get the copy of Apache ODE 1.2. (apache-ode-war-1.2.zip), unpacking it and rename it as "ode.war". Put that war into JBOSS_HOME\server\default\deploy.
  2. Create the schema in Oracle. All the objects can be created with the sql script located in the ODE that you already downloaded.
  3. During your first running of ODE, hibernate will create some tables, but for some odd reason LARGE_DATA table is wrong, so you need to created by hand. Please see this sql scritp to create it. created correctly.
  4. Get the Oracle 10g driver (ojdbc14.jar) and put it into JBOSS_HOME\server\default\lib
  5. Create a new datasource in JBoss. You can see one here for Oracle.
  6. Remove this JAR from ode.war (not compatible with JBoss):
    geronimo-jta_1.1_spec-1.1.jar
  7. Create a new file called "ode-axis2.properties" and put it into "ode.war/WEB-INF/conf/". The content of that file should be like this example.
  8. Create a new file named "jboss-web.xml" and put it into "ode.war/WEB-INF". The content must refer to the previously datasource created. See this example.
  9. Edit the ode.war\WEB-INF\web.xml file and create a reference to the datasource. See this example.
  10. When running JBoss, be sure that you give this parameter -Dode.persistence=hibernate. For example, add to the run.bat this: set JAVA_OPTS=%JAVA_OPTS% -Dode.persistence=hibernate

References:
Install ODE 1.2 with JBOSS 4.2.3 (spanish)
Apache Ode, Jboss and MySQL

2 comments:

Nashiely I. said...

Thank you very much for sharing information about BPEL. Find information related to this topic is very difficult.

Angel said...

Thanks man, just what I was looking for :)