Apache ODE under Hibernate

How to run Apache Ode under Hibernate and SQL Server.
1. Create database ODE using script sqlserverh.sql.
2. Unzip Apache ODE 1.3.5 or 1.3.4 and copy ode.war into $Tomcat/webapps/ode directory.
3. Unzip lib.zip and copy files to $Tomcat/webapps/ode/WEB-INF/lib. You have to accept Hibernate license.
4. Create or edit $Tomcat/webapps/ode/WEB-INF/conf/ode-axis2.properties and add following content.
       ode-axis2.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl
       ode-axis2.db.mode=INTERNAL
       ode-axis2.db.int.mcf=org.tranql.connector.sqlserver.XAMCF
       ode-axis2.db.int.mcf.databaseName=ODE
       ode-axis2.db.int.mcf.userName=user
       ode-axis2.db.int.mcf.password=Password
       ode-axis2.db.int.mcf.portNumber=1433
       ode-axis2.db.int.mcf.serverName=10.0.100.1

Apache ODE and SQL Server

Configuring ODE in Tomcat with a SQL Server database

The ODE war should have been copied to the webapps directory of Tomcat and the server should have been started at least once before following these instructions. This ensures that the webapp is properly exploded.

1. Drop the Sql Server jTDs driver (jtds-1.2.5.jar) in the common/lib directory of Tomcat.
2. Add the following stanza to conf/server.xml inside the <Host> element:
<Context path="/ode" docBase="ode" debug="5" reloadable="true" crossContext="true">
               <Resource name="SQLServer" auth="Container" type="javax.sql.DataSource"
                maxActive="100" maxIdle="30" maxWait="10000"
                username="username" password="******" driverClassName="net.sourceforge.jtds.jdbc.Driver"
                url="jdbc:jtds:sqlserver://10.0.101.44:1444/ODE"/>
</Context>
3. Make sure that the ODE schema has been loaded in a ode database.
ODE 1.3.4/1.3.5 SQL Server schema.

4. Add a file named ode-axis2.properties under webapps/ode/WEB-INF/conf with the following content:
ode-axis2.db.mode=EXTERNAL
ode-axis2.db.ext.dataSource=java:comp/env/SQLServer