To configure Cascade's connection to the database, follow the steps below:

  • Edit the file tomcat\conf\context.xml 
  • Locate the Configuration template for the database vendor to which Cascade CMS will be connecting
  • In the <Resource>  element, update the following attributes:
    username  - the username needed to connect to the database
    password  - the password needed to connect to the database
    url - the host, port, and database name following on of the formats below depending on your vendor

MySQL 5.5/5.6 Database URL

url="jdbc:mysql://mysql:3306/cascade?useUnicode=true&amp;characterEncoding=UTF-8"

The connection url above will attempt to connect to a database named cascade running at hostname mysql over port 3306.

SQL Server 2012/2014 Database URL

url="jdbc:jtds:sqlserver://sqlserver:1433/cascade;SelectMethod=cursor"

The connection url above will attempt to connect to a database named cascade running on a server at hostname sqlserver on port 1433.

Oracle 11g/12c Database URL

url="jdbc:oracle:thin:@huxley:1521:orcl"

The connection url above will attempt to connect to an Oracle SID called orcl on a server at hostname huxley running on port 1521 using the thin driver. With Oracle, the database schema is specified using the cascadeSchemaName resource.

Ensure that the following line in tomcat/conf/context.xml  is uncommented:

<ResourceLink name='schemaName' type='java.lang.String' global='cascadeSchemaName'/>

and then un-comment and update the "cascadeSchemaName" environment variable to have the value for your database's schema in the tomcat/conf/server.xml file:

<Environment name="cascadeSchemaName" type="java.lang.String" value="my_cascade_db"/>

IMPORTANT: With Oracle, it is required that the connecting username matches the name of the database schema.

Did this answer your question?