What steps are necessary to enable Oracle-DB or Microsoft-SQL-Server Content Repositories?

This faq shows you how to setup the support for Oracle-DB or Microsoft-SQL-Server Content Repositories in the CMS.

1 Install JDBC driver

The JDBC-Driver for Oracle-DB or Microsoft-SQL-Server databases is not included in the CMS package and has to be installed manually. To install the JDBC driver simply copy the JAR-file provided by your database vendor to the shared lib directory of the CMS-Tomcat: /Node/tomcat/shared/lib/custom/

2 Configuration

To activate Oracle-DB or Microsoft-SQL-Server support in the CMS you have to configure the full class name (including the package name – e.g.: “oracle.jdbc.OracleDriver”) of the JDBC driver in the node.conf:

node.conf

// activate Oracle-DB support for content repositories
$CONTENTREPOSITORY_DRIVERCLASS["oracle"] = "<FULL-JDBC-DRIVER-CLASS-NAME>";

// activate Microsoft-SQL-Server support for content repositories
$CONTENTREPOSITORY_DRIVERCLASS["mssql"] = "<FULL-JDBC-DRIVER-CLASS-NAME>";

After making theses changes the CMS (the Tomcat server) has to be restarted. After the CMS restart it should be possible to choose the Oracle-DB or Microsoft-SQL-Server database type in the Content Repository create and edit dialogs.