Apache ODE 1.2
JBoss 4.2.2.GA installed
Oracle 9i installed
- 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.
- Create the schema in Oracle. All the objects can be created with the sql script located in the ODE that you already downloaded.
- 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.
- Get the Oracle 10g driver (ojdbc14.jar) and put it into JBOSS_HOME\server\default\lib
- Create a new datasource in JBoss. You can see one here for Oracle.
- Remove this JAR from ode.war (not compatible with JBoss):
- 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.
- 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.
- Edit the ode.war\WEB-INF\web.xml file and create a reference to the datasource. See this example.
- 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