Configuring and Managing Databases

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

This interface has buttons to Edit, Reinitialize, Deactivate or Delete the database. The button allows you to access the SQL Console and Permissions sections.

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. These parameters can be modified 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.

Reinitializing databases

Reinitializing a database closes all open connections and creates new ones. This can be useful to force a reconnection to a database system.

Deactivating databases

Deactivating a database closes connections to the database without deleting its configuration. JMap Server can no longer query the database. Deactivating is useful when the database stops responding and causes delays in the local server.

Deleting databases

Deleting a database deletes the connection configuration for the database system. The data contained in the database is not affected at all.

Database statuses

Each database has a status. The status indicates the condition of the database connection. The following table describes the possible statuses of a database.

Statuses
Error	The database connections are broken. The database cannot be used until the error is resolved and the connections are reopened. Reinitializing the database might correct the problem. You can view a description of the error by clicking on the word Error displayed in red.
Inactive	The database connections are closed but they are configured. JMap can no longer query the database.
Connected	The database connections were created successfully and are ready to be used.