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