Updating Database Connection Details

You can update the Sentinel LDK-EMS database connection properties, when needed. For example, you may want to point to a database on a different machine.

**WARNING**   Database connection files contain sensitive information such as database connection strings and passwords. Make sure to secure these files to ensure that only authorized and trusted users can access them. We recommend limiting both read and write access.

To modify the database connection properties:

In a text editor, edit the following files, as needed.

>%EMS_HOME%\EMSServer\webapps\ems\META-INF\context.xml

>%EMS_HOME%\EMSServer\webapps\ems\WEB-INF\classes\ems.properties

>%EMS_HOME%\EMSServer\webapps\ems\WEB-INF\classes\ems-quartz.properties

NOTE   The values for the properties specified in these files must match.

context.xml

Property Name Description Default Value

driverClass

Database driver class name

net.sourceforge.jtds.jdbc.Driver

jdbcUrl

Database connection URL

jdbc:jtds:sqlserver://127.0.0.1:3745/EMSDB

user

Database connection username

xx

password

Database connection password

xxxxxxx

ems.properties

Property Name Description Default Value

url

Database connection URL

jdbc:jtds:sqlserver://127.0.0.1:3745/EMSDB

username

Database connection username

xx

password

Database connection password

xxxxxxx

ems-quartz.properties

Property Name Description Default Value

org.quartz.dataSource.
quartzDS.driver

Database driver class name

net.sourceforge.jtds.jdbc.Driver

org.quartz.dataSource.
quartzDS.URL

Database connection URL

jdbc\:jtds\:sqlserver\://127.0.0.1\:3745/EMSDB

org.quartz.dataSource.
quartzDS.user

Database connection username

xx

org.quartz.dataSource.
quartzDS.password

Database connection password

xxxxxxx

org.quartz.dataSource.
quartzDS.maxConnections

Maximum number of connections that the DataSource can create in its connection pool