Before build

Creating the databases

See Configuring the workflow databases for a general description of which databases to create for workflow in the CMS. You can find the SQLServer scripts for osworkflow and quartz in /editor/configuration/jdbc/mssql.

Dependencies

The following dependencies should be added to the CMS:

• check the minimal version of the following dependency:

  <dependency>
        <id>opensymphony:osworkflow</id>
        <version>2.7.0h03</version>
        <properties><cocoon.bundle>true</cocoon.bundle></properties>
      </dependency>

• the jtds jdbc driver for MS SqlServer:

  <dependency>
        <id>net.sourceforge.jtds:jtds</id>
        <version>1.2</version>
        <properties><cocoon.bundle>true</cocoon.bundle></properties>
      </dependency>

Workflow configuration

• Copy the example workflow configuration (example_project_sqlserver) for MSSql in /templates in the trunk of the CMS to /editor/src/configurations/. Rename if you want to.
• set the CMS build property maven.cocoon.servermanager.configuration to example_project_sqlserver

Build properties

You can use the following CMS build properties (for MS SqlServer 2005!) as an example:

# turn off the default hsqldb worfklow/scheduler database
maven.cocoon.hsqldb.use=false

# use the sqlserver worfklow configuration
maven.cocoon.servermanager.configuration=example_project_sqlserver

# Per project workflow and scheduler
cms.datasource.workflow.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
cms.datasource.workflow.url=jdbc:sqlserver://localhost;DatabaseName=myproject_projectdata;
cms.datasource.workflow.user=sa
cms.datasource.workflow.password=root

cms.datasource.scheduler.name=quartz
cms.datasource.scheduler.driver=net.sourceforge.jtds.jdbc.Driver
cms.datasource.scheduler.url=jdbc:jtds:sqlserver://localhost/myproject_projectdata;useCursors=true
cms.datasource.scheduler.user=sa
cms.datasource.scheduler.password=root


# Per cocoon instance scheduler, must be different from site schedular (cocoon.xconf)
cms.datasource.quartz.driver=net.sourceforge.jtds.jdbc.Driver
cms.datasource.quartz.name=quartz
cms.datasource.quartz.url=jdbc:jtds:sqlserver://localhost/myproject_cocoonscheduler;useCursors=true
cms.datasource.quartz.user=sa
cms.datasource.quartz.password=root

# Per cocoon instance scheduler, must be different from site schedular (schedulerStore.xml)
cms.datasource.serverscheduler.driver=net.sourceforge.jtds.jdbc.Driver
cms.datasource.serverscheduler.name=quartz
cms.datasource.serverscheduler.url=jdbc:jtds:sqlserver://localhost/myproject_serverscheduler;useCursors=true
cms.datasource.serverscheduler.user=sa
cms.datasource.serverscheduler.password=root

Note For SQLServer 2000, the JDBC Driver is com.microsoft.jdbc.sqlserver.SQLServerDriver (really confusing) and the JDBC url should start with jdbc:microsoft:sqlserver://

After build

Copy MSSQL Server JDBC driver to target LIB directory

Add the Microsoft SQLServer JDBC Driver to the CMS' lib directory. Which driver you need depends on the type of SQLServer you're using. Search the JDBC driver via http://www.microsoft.com/downloads. Add the needed JAR(s) to /editor/target/hippo-cms-v.X.XX.XX/cocoon/WEB-INF/lib.