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 databasepassword
- the password needed to connect to the databaseurl
- 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.