Project Ode has retired. For details please refer to its Attic page.
Apache ODE – ODE Schema

ODE Schema

Database scripts for fresh installation of ODE 1.3.7 is now packaged within the distribution archive.

ODE 1.3.6 - 1.3.7

Migration is necessary from 1.3.6, read the migration script available here.

ODE 1.3.4 - 1.3.6

ODE 1.3.4, 1.3.5 and 1.3.6 share the same schema definitions.

For use with OpenJPA

For use with Hibernate

Configuring Hibernate

In order to run ODE 1.3.6 under Hibernate, you need to grab external dependencies (and accept Hibernate license). This script can be used to create a fully configured bundle with Apache Tomcat, Hibernate, and Bitronix.

Configuring H2 Database

Run this:

java -cp h2-1.1.117.jar org.h2.tools.RunScript -url 'jdbc:h2:file:ode-db;DB_CLOSE_ON_EXIT=false;user=sa' -showResults -script ode-1.3.4-hib-h2.sql

Then you will get ode-db* files in directory.

Then edit ode-axis2.properties and set:

ode-axis2.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl
ode-axis2.db.mode=INTERNAL
ode-axis2.db.int.jdbcurl=jdbc:h2:file:ode-db;DB_CLOSE_ON_EXIT=false;user=sa
ode-axis2.db.int.driver=org.h2.Driver
hibernate.dialect=org.hibernate.dialect.H2Dialect

Upgrade from previous versions

Please refer to this page: Upgrading ODE