Home > Cloud Cruiser 4 > Administering > Managing the application server > Modifying the database connection

Modifying the database connection

To modify the way Cloud Cruiser connects to your database, you use a text editor to edit the properties file <install_dir>/apache-tomcat-7.0.54/webapps/ROOT/WEB-INF/classes/database.properties. The following sections explain the properties available for each database type. You can also view a sample version of this file named database.properties.sample in the same directory.

Microsoft SQL Server

The syntax of the database.properties file for SQL Server is:

jdbc.driver=net.sourceforge.jtds.jdbc.Driver
jdbc.url=jdbc:jtds:sqlserver://<server_name>:<port>/<db_name>;instance=<instance_name>;domain=<domain_name>
jdbc.username=<user_name>
jdbc.password=<password>
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
validation.query=select 1
validation.query.timeout=5

The properties referenced by this syntax are:

<server_name>

Host name or IP address of the database server

<port>

Port that the database is listening to (typically 1433)

<db_name>

Name of the database where the chargeback data will reside. This is defined during initial database setup.

<instance_name>

Instance name of the Microsoft SQL Server

<domain_name>

Domain used if SQL Server is set to Windows authentication. This should be the name of the local machine, or blank if using Mixed Mode authentication.

<user_name>

User account with which Cloud Cruiser will log in to SQL Server if using Mixed Mode authentication

<password>

The password for this user

Oracle

NOTE: The hibernate.dialect property should refer to Oracle10gDialect, even if you are using Oracle 11g.

The syntax of the database.properties file for Oracle is:

jdbc.driver=oracle.jdbc.OracleDriver
jdbc.url=jdbc:oracle:thin:@//<server_name>:<port>/<instance_name>
jdbc.username=<user_name>
jdbc.password=<password>
hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
validation.query=select 1 from dual
validation.query.timeout=5

The properties referenced by this syntax are:

<server_name>

Host name or IP address of the database server

<port>

Port that the database is listening to (typically 1521)

<instance_name>

Instance name of the Oracle database service (typically XE)

<user_name>

User account with which Cloud Cruiser will log in to Oracle

<password>

The password for this user

Last modified

Tags

This page has no custom tags.

Classifications

This page has no classifications.
© Copyright 2018 Hewlett Packard Enterprise Development LP