Configuring Databases

When you click on the name of a database in the Database section, the Database configuration interface displays.

This interface has buttons to manage the database: Edit, Reinitialize, access to Permissions, Deactivate or Delete the database. More details are shown in Managing Databases.

Several subsections display information on the database. The parameter values indicated were defined when the database connection was created. Refer to Creating Databases for the details of each parameter. Some parameters can be modified directly in the section, others by clicking on Edit.

General information

This subsection displays the name, Id (internal JMap identifier), a description, and the database owner.

Database connection pool

This subsection displays the details of the connection pool. The parameters indicated are the following: Initial size, Maximum size, Pool usage, Pool usage peak, Connection timeout, and Connection wait timeout.

Database connection

This subsection displays the details of the database connection. The parameters indicated are the following: Status, Database (indicates the type), Driver, Connection string, Username, Validation query, and Connection type.

References

This subsection shows all the resources using the data from the database. The information in this section is presented hierarchically and displays the spatial data sources as well as the projects with the layers, reports, and forms, all showing the attributes used. This can be useful to view the resources that would be affected by changes made to the database.