Set the EC Server data source
Use this procedure to set the database in EC application.
- On the EC Configuration page, click the Edit Properties. link.
- In the Application Defined Properties list, scroll down to Database group and expand the view.
-
Perform these steps for every property to configure in this group.
- Click the value link across the property to update.
-
On the Edit Property window, specify a new value.
See the table below for the property value guidelines.
-
Click Update Property.
Use these guidelines:
Property Description Database.ConnectionPool.Driver
This is a JDBC driver that is used to communicate with the database.
Data is:
com.microsoft.sqlserver.jdbc.SQLServerDriver
Database.ConnectionPool.URL
Specify the connection parameters.
Path:
DRIVER/COMPUTER:PORT
Data:
jdbc:microsoft:sqlserver://Computer.lawson.se:1433
Database.ConnectionPool.Auto
Specify a value for this property only if you are using a trusted connection.
Data is
0
Database.ConnectionPool.User
Specify a case sensitive user name to connect to the database.
Data is
Usr
Database.ConnectionPool.Password
Specify a case sensitive password to connect to the database. Database.ConnectionPool.Catalog
Specify a case sensitive database name.
Data is
MEC_Storage
Database.ConnectionPool.Schema
Specify a case sensitive schema name. Database.ConnectionPoolExt.RemoveInactivePools
Use this to remove inactive pools which are not used for
RemoveInactivePoolsTimeout
.Data is: True
-
Save the changes.
MEC displays the status of the database in the server user interface. This covers issues when the database becomes unavailable or the system goes down. When the database transaction logs are full, the database becomes unusable but this still appears as OK in the database state in the UI.