Modifying the Database Configuration

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 Server 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 the format below:

MySQL 5.0/5.1 Database URL

url="jdbc:mysql://mysql:3306/cascade?useUnicode=true&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 2005/2008 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 10g/11g 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.